Version 2021

Creating Intelligent Cubes Cased on MDX Cubes

Once MDX cubes are integrated into MicroStrategy, you can begin to create MDX cube reports directly on these MDX cubes.

Alternatively, once an MDX cube is created, you can create an Intelligent Cube based on the MDX cube. This stores the MDX cube data as an Intelligent Cube, which allows you to take advantage of various Intelligent Cube features, including the improved response time of reporting against Intelligent Cubes.

Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements.

You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP Services privileges.

To Create an Intelligent Cube Based on an MDX Cube

  1. Using MicroStrategy Developer, log in to a project connected to an MDX cube source.
  2. Choose File > New > Intelligent Cube.
  3. On the MDX Sources tab, choose a database instance connected to an MDX cube source and click OK.
  4. Choose an MDX cube to report on:

    To show the technical names for MDX cubes, choose the Display technical names check box.

    If MDX cubes have already been imported by an architect, they are displayed in their respective catalog structure. Click the plus sign (+) next to the catalog name to display its contents, and then choose the imported cube to use for your Intelligent Cube.

    or

    If the MDX cube that you want to report on has not been imported yet, click Retrieve cubes. Choose the MDX cube from the list of MDX cubes from the chosen database instance. If you choose an MDX cube that has not been imported yet, it is imported into MicroStrategy before the report is created. You must have the Import MDX Cube privilege to perform this action.

    You can also use the MDX Cube Catalog to import cubes, as described in Importing MDX Cubes.

  5. Click OK.
  6. From the Object Browser pane, choose attributes, metrics, and other objects from the MDX cube to create the data available for the Intelligent Cube.
  7. Choose File > Save.
  8. In the Object name field, type a descriptive name for the Intelligent Cube.
  9. Click OK.
  10. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar.

Related Topics

Reporting on MDX Cubes

Create an MDX Cube Report