XML for Analysis

OLE DB for OLAP Schema Rowsets

Synchronous versus Asynchronous XMLA

See https://developer.mozilla.org/en-US/docs/Web/API/XMLHttpRequest/Synchronous_and_Asynchronous_Requests
Apparently, asynchronous always is better, since it allows to do further things after invocing a request.

Marshalling and Unmarshalling

Marshalling (von engl. to marshal‚ aufstellen, (an)ordnen) ist das Umwandeln von strukturierten oder elementaren Daten in ein Format, das die Übermittlung an andere Prozesse ermöglicht. Auf Empfängerseite werden aus diesem Format die Daten in ihrer ursprünglichen Struktur wiederhergestellt, was als Unmarshalling oder Demarshalling bezeichnet wird.

In XML means to load Java Objects into XML file and back (unmarshalling).

Example XMLA outputs

Can be generated by test case LD_Cubes_Explorer_XmlaTest.java

Metadata queries (discoveries)

200
OK
<?xml version="1.0" encoding="ISO-8859-1"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" ><SOAP-ENV:Header></SOAP-ENV:Header><SOAP-ENV:Body><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">  <cxmla:return>    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">      <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified">        <xsd:element name="root">          <xsd:complexType>            <xsd:sequence>              <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/>            </xsd:sequence>          </xsd:complexType>        </xsd:element>        <xsd:simpleType name="uuid">          <xsd:restriction base="xsd:string">            <xsd:pattern value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"/>          </xsd:restriction>        </xsd:simpleType>        <xsd:complexType name="row">          <xsd:sequence>            <xsd:element sql:field="DataSourceName" name="DataSourceName" type="xsd:string"/>            <xsd:element sql:field="DataSourceDescription" name="DataSourceDescription" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="URL" name="URL" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="DataSourceInfo" name="DataSourceInfo" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="ProviderName" name="ProviderName" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="ProviderType" name="ProviderType" type="xsd:string" maxOccurs="unbounded"/>            <xsd:element sql:field="AuthenticationMode" name="AuthenticationMode" type="xsd:string"/>          </xsd:sequence>        </xsd:complexType>      </xsd:schema>      <row>        <DataSourceName>[XMLA olap4ld]</DataSourceName>        <URL>@datasourceUrl@</URL>        <DataSourceInfo>[LdCatalogSchema]</DataSourceInfo>        <ProviderType>TDP</ProviderType>        <AuthenticationMode>Unauthenticated</AuthenticationMode>      </row>    </root>  </cxmla:return></cxmla:DiscoverResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
200
OK
<?xml version="1.0" encoding="ISO-8859-1"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" ><SOAP-ENV:Header></SOAP-ENV:Header><SOAP-ENV:Body><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">  <cxmla:return>    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">      <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified">        <xsd:element name="root">          <xsd:complexType>            <xsd:sequence>              <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/>            </xsd:sequence>          </xsd:complexType>        </xsd:element>        <xsd:simpleType name="uuid">          <xsd:restriction base="xsd:string">            <xsd:pattern value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"/>          </xsd:restriction>        </xsd:simpleType>        <xsd:complexType name="row">          <xsd:sequence>            <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string"/>            <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string"/>            <xsd:element sql:field="ROLES" name="ROLES" type="xsd:string"/>            <xsd:element sql:field="DATE_MODIFIED" name="DATE_MODIFIED" type="xsd:dateTime" minOccurs="0"/>          </xsd:sequence>        </xsd:complexType>      </xsd:schema>      <row>        <CATALOG_NAME>[LdCatalogSchema]</CATALOG_NAME>        <DESCRIPTION>No description available</DESCRIPTION>        <ROLES></ROLES>      </row>    </root>  </cxmla:return></cxmla:DiscoverResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
200
OK
<?xml version="1.0" encoding="ISO-8859-1"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" ><SOAP-ENV:Header></SOAP-ENV:Header><SOAP-ENV:Body><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">  <cxmla:return>    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">      <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified">        <xsd:element name="root">          <xsd:complexType>            <xsd:sequence>              <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/>            </xsd:sequence>          </xsd:complexType>        </xsd:element>        <xsd:simpleType name="uuid">          <xsd:restriction base="xsd:string">            <xsd:pattern value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"/>          </xsd:restriction>        </xsd:simpleType>        <xsd:complexType name="row">          <xsd:sequence>            <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string"/>            <xsd:element sql:field="CUBE_TYPE" name="CUBE_TYPE" type="xsd:string"/>            <xsd:element sql:field="CUBE_GUID" name="CUBE_GUID" type="uuid" minOccurs="0"/>            <xsd:element sql:field="CREATED_ON" name="CREATED_ON" type="xsd:dateTime" minOccurs="0"/>            <xsd:element sql:field="LAST_SCHEMA_UPDATE" name="LAST_SCHEMA_UPDATE" type="xsd:dateTime" minOccurs="0"/>            <xsd:element sql:field="SCHEMA_UPDATED_BY" name="SCHEMA_UPDATED_BY" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="LAST_DATA_UPDATE" name="LAST_DATA_UPDATE" type="xsd:dateTime" minOccurs="0"/>            <xsd:element sql:field="DATA_UPDATED_BY" name="DATA_UPDATED_BY" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="IS_DRILLTHROUGH_ENABLED" name="IS_DRILLTHROUGH_ENABLED" type="xsd:boolean"/>            <xsd:element sql:field="IS_WRITE_ENABLED" name="IS_WRITE_ENABLED" type="xsd:boolean"/>            <xsd:element sql:field="IS_LINKABLE" name="IS_LINKABLE" type="xsd:boolean"/>            <xsd:element sql:field="IS_SQL_ENABLED" name="IS_SQL_ENABLED" type="xsd:boolean"/>            <xsd:element sql:field="CUBE_CAPTION" name="CUBE_CAPTION" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="DIMENSIONS" name="DIMENSIONS" minOccurs="0"/>            <xsd:element sql:field="SETS" name="SETS" minOccurs="0"/>            <xsd:element sql:field="MEASURES" name="MEASURES" minOccurs="0"/>          </xsd:sequence>        </xsd:complexType>      </xsd:schema>      <row>        <CATALOG_NAME>[LdCatalogSchema]</CATALOG_NAME>        <SCHEMA_NAME>[LdCatalogSchema]</SCHEMA_NAME>        <CUBE_NAME>[httpXXX3AXXX2FXXX2Folap4ldYYYgooglecodeYYYcomXXX2FgitXXX2FOLAP4LDZZZtrunkXXX2FtestsXXX2FedgarwrapXXX2F0001193125ZZZ10ZZZ230379YYYrdfXXX23ds]</CUBE_NAME>        <CUBE_TYPE>CUBE</CUBE_TYPE>        <LAST_SCHEMA_UPDATE>2013-09-26T23:16:23</LAST_SCHEMA_UPDATE>        <IS_DRILLTHROUGH_ENABLED>true</IS_DRILLTHROUGH_ENABLED>        <IS_WRITE_ENABLED>false</IS_WRITE_ENABLED>        <IS_LINKABLE>false</IS_LINKABLE>        <IS_SQL_ENABLED>false</IS_SQL_ENABLED>        <CUBE_CAPTION>10-K - COSTCO WHOLESALE CORP /NEW - 2010-08-29</CUBE_CAPTION>        <DESCRIPTION>null</DESCRIPTION>      </row>    </root>  </cxmla:return></cxmla:DiscoverResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>
200
OK
<?xml version="1.0" encoding="ISO-8859-1"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" ><SOAP-ENV:Header></SOAP-ENV:Header><SOAP-ENV:Body><cxmla:DiscoverResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis">  <cxmla:return>    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception">      <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sql="urn:schemas-microsoft-com:xml-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" elementFormDefault="qualified">        <xsd:element name="root">          <xsd:complexType>            <xsd:sequence>              <xsd:element name="row" type="row" minOccurs="0" maxOccurs="unbounded"/>            </xsd:sequence>          </xsd:complexType>        </xsd:element>        <xsd:simpleType name="uuid">          <xsd:restriction base="xsd:string">            <xsd:pattern value="[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}"/>          </xsd:restriction>        </xsd:simpleType>        <xsd:complexType name="row">          <xsd:sequence>            <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string"/>            <xsd:element sql:field="MEASURE_NAME" name="MEASURE_NAME" type="xsd:string"/>            <xsd:element sql:field="MEASURE_UNIQUE_NAME" name="MEASURE_UNIQUE_NAME" type="xsd:string"/>            <xsd:element sql:field="MEASURE_CAPTION" name="MEASURE_CAPTION" type="xsd:string"/>            <xsd:element sql:field="MEASURE_GUID" name="MEASURE_GUID" type="uuid" minOccurs="0"/>            <xsd:element sql:field="MEASURE_AGGREGATOR" name="MEASURE_AGGREGATOR" type="xsd:int"/>            <xsd:element sql:field="DATA_TYPE" name="DATA_TYPE" type="xsd:unsignedShort"/>            <xsd:element sql:field="MEASURE_IS_VISIBLE" name="MEASURE_IS_VISIBLE" type="xsd:boolean"/>            <xsd:element sql:field="LEVELS_LIST" name="LEVELS_LIST" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" minOccurs="0"/>            <xsd:element sql:field="DEFAULT_FORMAT_STRING" name="DEFAULT_FORMAT_STRING" type="xsd:string" minOccurs="0"/>          </xsd:sequence>        </xsd:complexType>      </xsd:schema>      <row>        <CATALOG_NAME>[LdCatalogSchema]</CATALOG_NAME>        <SCHEMA_NAME>[LdCatalogSchema]</SCHEMA_NAME>        <CUBE_NAME>[httpXXX3AXXX2FXXX2Folap4ldYYYgooglecodeYYYcomXXX2FgitXXX2FOLAP4LDZZZtrunkXXX2FtestsXXX2FedgarwrapXXX2F0001193125ZZZ10ZZZ230379YYYrdfXXX23ds]</CUBE_NAME>        <MEASURE_NAME>[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValueAGGFUNCAVG]</MEASURE_NAME>        <MEASURE_UNIQUE_NAME>[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValueAGGFUNCAVG]</MEASURE_UNIQUE_NAME>        <MEASURE_CAPTION>Observation</MEASURE_CAPTION>        <MEASURE_AGGREGATOR>5</MEASURE_AGGREGATOR>        <DATA_TYPE>130</DATA_TYPE>        <MEASURE_IS_VISIBLE>true</MEASURE_IS_VISIBLE>        <LEVELS_LIST>[httpXXX3AXXX2FXXX2FedgarwrapYYYontologycentralYYYcomXXX2FvocabXXX2FedgarXXX23issuer],[httpXXX3AXXX2FXXX2FedgarwrapYYYontologycentralYYYcomXXX2FvocabXXX2FedgarXXX23segment],[httpXXX3AXXX2FXXX2FedgarwrapYYYontologycentralYYYcomXXX2FvocabXXX2FedgarXXX23subject],[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtend],[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LEVELS_LIST>        <DESCRIPTION>Observation</DESCRIPTION>      </row>      <row>        <CATALOG_NAME>[LdCatalogSchema]</CATALOG_NAME>        <SCHEMA_NAME>[LdCatalogSchema]</SCHEMA_NAME>        <CUBE_NAME>[httpXXX3AXXX2FXXX2Folap4ldYYYgooglecodeYYYcomXXX2FgitXXX2FOLAP4LDZZZtrunkXXX2FtestsXXX2FedgarwrapXXX2F0001193125ZZZ10ZZZ230379YYYrdfXXX23ds]</CUBE_NAME>        <MEASURE_NAME>[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValueAGGFUNCCOUNT]</MEASURE_NAME>        <MEASURE_UNIQUE_NAME>[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValueAGGFUNCCOUNT]</MEASURE_UNIQUE_NAME>        <MEASURE_CAPTION>Observation</MEASURE_CAPTION>        <MEASURE_AGGREGATOR>2</MEASURE_AGGREGATOR>        <DATA_TYPE>130</DATA_TYPE>        <MEASURE_IS_VISIBLE>true</MEASURE_IS_VISIBLE>        <LEVELS_LIST>[httpXXX3AXXX2FXXX2FedgarwrapYYYontologycentralYYYcomXXX2FvocabXXX2FedgarXXX23issuer],[httpXXX3AXXX2FXXX2FedgarwrapYYYontologycentralYYYcomXXX2FvocabXXX2FedgarXXX23segment],[httpXXX3AXXX2FXXX2FedgarwrapYYYontologycentralYYYcomXXX2FvocabXXX2FedgarXXX23subject],[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtend],[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LEVELS_LIST>        <DESCRIPTION>Observation</DESCRIPTION>      </row>    </root>  </cxmla:return></cxmla:DiscoverResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>

Olap query (execute)

<?xml version="1.0" encoding="ISO-8859-1"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" ><SOAP-ENV:Header></SOAP-ENV:Header><SOAP-ENV:Body><cxmla:ExecuteResponse xmlns:cxmla="urn:schemas-microsoft-com:xml-analysis"> <cxmla:return> <root xmlns="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception"> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns="urn:schemas-microsoft-com:xml-analysis:mddataset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sql="urn:schemas-microsoft-com:xml-sql" elementFormDefault="qualified"> <xsd:complexType name="MemberType"> <xsd:sequence> <xsd:element name="UName" type="xsd:string"/> <xsd:element name="Caption" type="xsd:string"/> <xsd:element name="LName" type="xsd:string"/> <xsd:element name="LNum" type="xsd:unsignedInt"/> <xsd:element name="DisplayInfo" type="xsd:unsignedInt"/> <xsd:sequence maxOccurs="unbounded" minOccurs="0"> <xsd:any processContents="lax" maxOccurs="unbounded"/> </xsd:sequence> </xsd:sequence> <xsd:attribute name="Hierarchy" type="xsd:string"/> </xsd:complexType> <xsd:complexType name="PropType"> <xsd:attribute name="name" type="xsd:string"/> </xsd:complexType> <xsd:complexType name="TupleType"> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="Member" type="MemberType"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="MembersType"> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="Member" type="MemberType"/> </xsd:sequence> <xsd:attribute name="Hierarchy" type="xsd:string"/> </xsd:complexType> <xsd:complexType name="TuplesType"> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="Tuple" type="TupleType"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="CrossProductType"> <xsd:sequence> <xsd:choice minOccurs="0" maxOccurs="unbounded"> <xsd:element name="Members" type="MembersType"/> <xsd:element name="Tuples" type="TuplesType"/> </xsd:choice> </xsd:sequence> <xsd:attribute name="Size" type="xsd:unsignedInt"/> </xsd:complexType> <xsd:complexType name="OlapInfo"> <xsd:sequence> <xsd:element name="CubeInfo"> <xsd:complexType> <xsd:sequence> <xsd:element name="Cube" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:element name="CubeName" type="xsd:string"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="AxesInfo"> <xsd:complexType> <xsd:sequence> <xsd:element name="AxisInfo" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:element name="HierarchyInfo" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="UName" type="PropType"/> <xsd:element name="Caption" type="PropType"/> <xsd:element name="LName" type="PropType"/> <xsd:element name="LNum" type="PropType"/> <xsd:element name="DisplayInfo" type="PropType" minOccurs="0" maxOccurs="unbounded"/> </xsd:sequence> <xsd:sequence> <xsd:any processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xsd:sequence> </xsd:sequence> <xsd:attribute name="name" type="xsd:string" use="required"/> </xsd:complexType> </xsd:element> </xsd:sequence> <xsd:attribute name="name" type="xsd:string"/> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> <xsd:element name="CellInfo"> <xsd:complexType> <xsd:sequence> <xsd:sequence minOccurs="0" maxOccurs="unbounded"> <xsd:choice> <xsd:element name="Value" type="PropType"/> <xsd:element name="FmtValue" type="PropType"/> <xsd:element name="BackColor" type="PropType"/> <xsd:element name="ForeColor" type="PropType"/> <xsd:element name="FontName" type="PropType"/> <xsd:element name="FontSize" type="PropType"/> <xsd:element name="FontFlags" type="PropType"/> <xsd:element name="FormatString" type="PropType"/> <xsd:element name="NonEmptyBehavior" type="PropType"/> <xsd:element name="SolveOrder" type="PropType"/> <xsd:element name="Updateable" type="PropType"/> <xsd:element name="Visible" type="PropType"/> <xsd:element name="Expression" type="PropType"/> </xsd:choice> </xsd:sequence> <xsd:sequence maxOccurs="unbounded" minOccurs="0"> <xsd:any processContents="lax" maxOccurs="unbounded"/> </xsd:sequence> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:complexType name="Axes"> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="Axis"> <xsd:complexType> <xsd:choice minOccurs="0" maxOccurs="unbounded"> <xsd:element name="CrossProduct" type="CrossProductType"/> <xsd:element name="Tuples" type="TuplesType"/> <xsd:element name="Members" type="MembersType"/> </xsd:choice> <xsd:attribute name="name" type="xsd:string"/> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:complexType name="CellData"> <xsd:sequence> <xsd:element name="Cell" minOccurs="0" maxOccurs="unbounded"> <xsd:complexType> <xsd:sequence maxOccurs="unbounded"> <xsd:choice> <xsd:element name="Value"/> <xsd:element name="FmtValue" type="xsd:string"/> <xsd:element name="BackColor" type="xsd:unsignedInt"/> <xsd:element name="ForeColor" type="xsd:unsignedInt"/> <xsd:element name="FontName" type="xsd:string"/> <xsd:element name="FontSize" type="xsd:unsignedShort"/> <xsd:element name="FontFlags" type="xsd:unsignedInt"/> <xsd:element name="FormatString" type="xsd:string"/> <xsd:element name="NonEmptyBehavior" type="xsd:unsignedShort"/> <xsd:element name="SolveOrder" type="xsd:unsignedInt"/> <xsd:element name="Updateable" type="xsd:unsignedInt"/> <xsd:element name="Visible" type="xsd:unsignedInt"/> <xsd:element name="Expression" type="xsd:string"/> </xsd:choice> </xsd:sequence> <xsd:attribute name="CellOrdinal" type="xsd:unsignedInt" use="required"/> </xsd:complexType> </xsd:element> </xsd:sequence> </xsd:complexType> <xsd:element name="root"> <xsd:complexType> <xsd:sequence maxOccurs="unbounded"> <xsd:element name="OlapInfo" type="OlapInfo"/> <xsd:element name="Axes" type="Axes"/> <xsd:element name="CellData" type="CellData"/> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:schema> <OlapInfo> <CubeInfo> <Cube> <CubeName>[httpXXX3AXXX2FXXX2Folap4ldYYYgooglecodeYYYcomXXX2FgitXXX2FOLAP4LDZZZtrunkXXX2FtestsXXX2FedgarwrapXXX2F0001193125ZZZ10ZZZ230379YYYrdfXXX23ds]</CubeName> </Cube> </CubeInfo> <AxesInfo> <AxisInfo name="Axis0"> <HierarchyInfo name="Measures"> <UName name="Measures.[MEMBER_UNIQUE_NAME]"/> <Caption name="Measures.[MEMBER_CAPTION]"/> <LName name="Measures.[LEVEL_UNIQUE_NAME]"/> <LNum name="Measures.[LEVEL_NUMBER]"/> <DisplayInfo name="Measures.[DISPLAY_INFO]"/> </HierarchyInfo> </AxisInfo> <AxisInfo name="Axis1"> <HierarchyInfo name="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName name="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart].[MEMBER_UNIQUE_NAME]"/> <Caption name="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart].[MEMBER_CAPTION]"/> <LName name="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart].[LEVEL_UNIQUE_NAME]"/> <LNum name="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart].[LEVEL_NUMBER]"/> <DisplayInfo name="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart].[DISPLAY_INFO]"/> </HierarchyInfo> </AxisInfo> <AxisInfo name="SlicerAxis"/> </AxesInfo> <CellInfo> <Value name="VALUE"/> <FmtValue name="FORMATTED_VALUE"/> <FormatString name="FORMAT_STRING"/> <Language name="LANGUAGE"/> <BackColor name="BACK_COLOR"/> <ForeColor name="FORE_COLOR"/> <FontFlags name="FONT_FLAGS"/> </CellInfo> </OlapInfo> <Axes> <Axis name="Axis0"> <Tuples> <Tuple> <Member Hierarchy="Measures"> <UName>[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValueAGGFUNCAVG]</UName> <Caption>Observation</Caption> <LName>Measures</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> </Tuples> </Axis> <Axis name="Axis1"> <Tuples> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[1997ZZZ08ZZZ01]</UName> <Caption>1997-08-01</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[1997ZZZ08ZZZ31]</UName> <Caption>1997-08-31</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2002ZZZ11ZZZ30]</UName> <Caption>2002-11-30</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2003ZZZ04ZZZ30]</UName> <Caption>2003-04-30</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2006ZZZ09ZZZ03]</UName> <Caption>2006-09-03</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2007ZZZ02ZZZ28]</UName> <Caption>2007-02-28</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2007ZZZ09ZZZ02]</UName> <Caption>2007-09-02</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2007ZZZ09ZZZ03]</UName> <Caption>2007-09-03</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2007ZZZ10ZZZ31]</UName> <Caption>2007-10-31</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2008ZZZ06ZZZ30]</UName> <Caption>2008-06-30</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2008ZZZ08ZZZ31]</UName> <Caption>2008-08-31</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2008ZZZ09ZZZ01]</UName> <Caption>2008-09-01</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2008ZZZ11ZZZ24]</UName> <Caption>2008-11-24</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2009ZZZ02ZZZ16]</UName> <Caption>2009-02-16</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2009ZZZ05ZZZ11]</UName> <Caption>2009-05-11</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2009ZZZ08ZZZ30]</UName> <Caption>2009-08-30</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2009ZZZ08ZZZ31]</UName> <Caption>2009-08-31</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2009ZZZ11ZZZ23]</UName> <Caption>2009-11-23</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2010ZZZ02ZZZ15]</UName> <Caption>2010-02-15</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2010ZZZ05ZZZ10]</UName> <Caption>2010-05-10</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> <Tuple> <Member Hierarchy="[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]"> <UName>[2010ZZZ08ZZZ29]</UName> <Caption>2010-08-29</Caption> <LName>[httpXXX3AXXX2FXXX2FwwwYYYw3YYYorgXXX2F2002XXX2F12XXX2FcalXXX2FicalXXX23dtstart]</LName> <LNum>1</LNum> <DisplayInfo>0</DisplayInfo> </Member> </Tuple> </Tuples> </Axis> <Axis name="SlicerAxis"> <Tuples/> </Axis> </Axes> <CellData> <Cell CellOrdinal="0"> <Value xsi:type="xsd:string">943000.0</Value> <FmtValue>943000.0</FmtValue> </Cell> <Cell CellOrdinal="1"> <Value xsi:type="xsd:string">22.71</Value> <FmtValue>22.71</FmtValue> </Cell> <Cell CellOrdinal="2"> <Value xsi:type="xsd:string">0.01</Value> <FmtValue>0.01</FmtValue> </Cell> <Cell CellOrdinal="3"> <Value xsi:type="xsd:string">0.01</Value> <FmtValue>0.01</FmtValue> </Cell> <Cell CellOrdinal="4"> <Value xsi:type="xsd:string">-6000000.0</Value> <FmtValue>-6000000.0</FmtValue> </Cell> <Cell CellOrdinal="5"> <Value xsi:type="xsd:string">2000000.03</Value> <FmtValue>2000000.03</FmtValue> </Cell> <Cell CellOrdinal="6"> <Value xsi:type="xsd:string">3.27411917647E9</Value> <FmtValue>3.27411917647E9</FmtValue> </Cell> <Cell CellOrdinal="7"> <Value xsi:type="xsd:string">2.41632210224E9</Value> <FmtValue>2.41632210224E9</FmtValue> </Cell> <Cell CellOrdinal="8"> <Value xsi:type="xsd:string">0.03</Value> <FmtValue>0.03</FmtValue> </Cell> <Cell CellOrdinal="9"> <Value xsi:type="xsd:string">0.0</Value> <FmtValue>0.0</FmtValue> </Cell> <Cell CellOrdinal="10"> <Value xsi:type="xsd:string">3.65440217997E9</Value> <FmtValue>3.65440217997E9</FmtValue> </Cell> <Cell CellOrdinal="11"> <Value xsi:type="xsd:string">1.86689433168E9</Value> <FmtValue>1.86689433168E9</FmtValue> </Cell> <Cell CellOrdinal="12"> <Value xsi:type="xsd:string">3.06200964713E9</Value> <FmtValue>3.06200964713E9</FmtValue> </Cell> <Cell CellOrdinal="13"> <Value xsi:type="xsd:string">2.87425594124E9</Value> <FmtValue>2.87425594124E9</FmtValue> </Cell> <Cell CellOrdinal="14"> <Value xsi:type="xsd:string">4.05905611776E9</Value> <FmtValue>4.05905611776E9</FmtValue> </Cell> <Cell CellOrdinal="15"> <Value xsi:type="xsd:string">1.90416795061E9</Value> <FmtValue>1.90416795061E9</FmtValue> </Cell> <Cell CellOrdinal="16"> <Value xsi:type="xsd:string">1.83160232109E9</Value> <FmtValue>1.83160232109E9</FmtValue> </Cell> <Cell CellOrdinal="17"> <Value xsi:type="xsd:string">3.4069237648E9</Value> <FmtValue>3.4069237648E9</FmtValue> </Cell> <Cell CellOrdinal="18"> <Value xsi:type="xsd:string">3.23755082362E9</Value> <FmtValue>3.23755082362E9</FmtValue> </Cell> <Cell CellOrdinal="19"> <Value xsi:type="xsd:string">4.13379777791E9</Value> <FmtValue>4.13379777791E9</FmtValue> </Cell> <Cell CellOrdinal="20"> <Value xsi:type="xsd:string">1.5981838372E9</Value> <FmtValue>1.5981838372E9</FmtValue> </Cell> </CellData> </root> </cxmla:return></cxmla:ExecuteResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>

XML for Analysis

Synchronous versus Asynchronous XMLA

Marshalling and Unmarshalling

Example XMLA outputs

Navigation menu

Personal tools

Namespaces

Variants

Views

Actions

Search

Navigation

Tools