Relating Objects from SAP BW to MicroStrategy

MDX cube reports based off SAP BW MDX cubes can be treated like standard MicroStrategy reports.

The metadata translation process involves the following steps:

1. From SAP BW to ODBO: SAP exposes its query cubes and InfoCubes to Intelligence Server through the ODBO model. ODBO (OLE database for OLAP) is a protocol defined by Microsoft. ODBO defines an object model that is used in conjunction with MDX to query cubes. The ODBO model is similar to SAP's standard model, but not identical.
2. From ODBO to MicroStrategy: After SAP objects are translated into the ODBO model, they are translated into the MicroStrategy metadata model. You can then interact with SAP content while working within the paradigm that is consistent with the rest of MicroStrategy's products.

This diagram shows how SAP BW objects are exposed in ODBO and then how they are related to objects in the MicroStrategy environment.

Additional information and the process for each SAP BW object is described in the following topics: