Show TOC

Function documentationOLAP Query Locate this document in the navigation structure

 

You can use the OLAP query in the SAP Manufacturing Integration and Intelligence (SAP MII) Workbench to create query templates that take the output of an online analytical processing (OLAP) data source multidimensional expressions (MDX) query and send the results to SAP MII.

You can use the transaction code MDXTest on the BW server

Note Note

Use MDXTest on BW server to build query statements that can be used in OLAP query.

End of the note.

Features

The request is made through the Web service interface of the target system, such as SAP NetWeaver Business Intelligence or Microsoft SQL Server for Analysis Services, and not a pooled or established connection between the systems.

An example of this request is as follows:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<SOAP-ENV:Body>

<Execute xmlns="urn:schemas-microsoft-com:xml-analysis" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

<Command>

<Statement>SELECT [Measures].MEMBERS ON COLUMNS, NON EMPTY [0D_MATERIAL].MEMBERS DIMENSION PROPERTIES [0D_MATERIAL].[20D_MATERIAL], [0D_MATERIAL].[50D_MATERIAL] ON ROWS FROM 0D_DECU/SALES_QUERY_DAILY</Statement>

</Command>

<Properties>

<PropertyList>

<DataSourceInfo></DataSourceInfo>

<Catalog>0D_DECU</Catalog>

<Format>Tabular</Format>

<Content>SchemaData</Content>

<AxisFormat>ClusterFormat</AxisFormat>

</PropertyList>

</Properties>

</Execute>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

An OLAP query is made up of the following property groups: