Other Third-Party Application Clients 

Use

We recommend you use the following detailed procedure to enable third-party applications to execute queries using OLE DB for OLAP Providers.

Prerequisites

You have installed the required SAP BW front end components on your desktop PC. More information: Installing SAP BW OLE DB for OLAP.

Special instructions apply during installation. These depend on the client application you want to use. More information: Installing Front End Components.

Procedure

...

       1.      Define a query in BEx Query Designer. More information: Query Design: BEx Query Designer

       2.      Select the characteristic dimension and drag it to either the rows area or columns area This dimension is modeled to the QUERY_CUBE dimensions in the OLE DB for OLAP interface (see Mapping the Metadata).

       3.      Define a structure with the required key figures. Take over the key figures from the InfoProvider to this structure. The name of the structure and its content are modeled to the MEASURES dimension in the OLE DB for OLAP interface (see Mapping the Metadata).

       4.      Release the BEx queries so that they can be used in OLE DB for OLAP Providers. In the Query Properties dialog box, set the Allow External Access to This Query flag .  More information: Query Properties (on the Specific tab page).

       5.      Save the query. Note: The name of the BEx Query appears thus in the client application: InfoCube Name/Query Name.

       6.      The client application prompts you to log on to the BI server. Enter a system name, your user name, password and logon language. More information: Installing SAP BW OLE DB for OLAP. (For test purposes, you can also execute the query in BEx).

Result

The QUERY_CUBE you have created now appears in the list of Cubes offered by your client application. You can base your front end display on this.