MicroStrategy ONE

Building an Intelligent Cube

Building an Intelligent Cube is similar to building a report. You can add data for your Intelligent Cube by including objects such as attributes, metrics, filters, and so on as report objects or report filters. For a list of objects and features that cannot be included in the definition of Intelligent Cubes, see Supporting various features using Intelligent Cubes.

Since Intelligent Cubes are used simply to share a set of data, no data or report results are displayed when you execute an Intelligent Cube. However, executing an Intelligent Cube publishes the Intelligent Cube, which can then be accessed as a set of data for multiple reports (see Publishing Intelligent Cubes).

Prerequisites

  • You need the Use Intelligent Cube Editor privilege. This privilege is part of OLAP Services.

To build an Intelligent Cube

  1. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. The New Grid dialog box opens.

    If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Expand the Object Templates category, select General, and from the Show templates for the following objects list, select Report. Click OK to accept your changes, and then repeat the previous step to open the New Grid dialog box.

  2. Select Empty Intelligent Cube and click OK. The Report Editor opens.

  3. Add objects such as attributes, metrics, and so on for the Intelligent Cube, the same way you would add report objects.

    You can also create an Intelligent Cube that contains data from an MDX cube integrated into MicroStrategy from an MDX source such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. You must browse to the MDX cube to use to build the Intelligent Cube. Then you can select attributes, metrics, and other object that are included in the MDX cube to create an Intelligent Cube. For information on integrating MDX sources into MicroStrategy, see theMDX Cube Reporting Guide.

  4. Create a filter for the Intelligent Cube as needed.

    If you create a filter on an Intelligent Cube, any data that is restricted from the Intelligent Cube is not available for any reports that connect to the Intelligent Cube. While this can help reduce the size of the Intelligent Cube, it also reduces the amount of data available in the Intelligent Cube.

  5. Click Save and close to save the Intelligent Cube and close the Report Editor.

  6. To publish an Intelligent Cube, see Publishing Intelligent Cubes.