Integrating MDX Cubes into MicroStrategy

Once you understand the relationships between the objects in an MDX cube source and MicroStrategy, and you connect to your MDX cube source, you can start integrating your MDX cube data into MicroStrategy.

The best place to start is with the MDX Cube Catalog, where you can perform the following tasks which are covered in this section:

Throughout these topics, SAP BW is used as the example MDX cube source but the procedures are similar for Analysis Services, Oracle Essbase, and TM1.

The importing and mapping tasks integrate your MDX cube source data into your MicroStrategy project, and therefore must be done before you can begin creating any MDX cube reports. The MDX Cube Catalog can be accessed from the Schema menu in MicroStrategy Developer and is available only after an MDX cube source database instance has been created. To learn how to create a database instance for an MDX cube source, see Connecting to MDX Cube Sources.

After you have fully integrated your MDX cube data into MicroStrategy, report designers can create MicroStrategy MDX cube reports, and analysts can then view and analyze data from MDX cube sources. MDX cube reports are covered in Reporting on MDX Cubes.