Using OLE DB for OLAP Providers

Use

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

Prerequisites

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

Procedure

  1. Define a query in BEx Query Designer. More information: 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 that the name of the BEx Query appears as InfoCube-Name/Query-Name in the client application.
  6. The client application prompts you to log on to the BW server. Enter a system name, your user name, password and logon language. More information: Installing OLE DB for OLAP from SAP BW (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.