MicroStrategy ONE

Create Intelligent Cubes

Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Creating an Intelligent cube is similar to creating 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 for more information.

Check out the video below to learn more!

The Intelligent Cube Editor uses the new Modeling service infrastructure. Make sure the service is properly configured and running before using the Intelligent Cube Editor.

To view an existing cube, you must have the following minimal privileges:

  • Use analytics

  • Use Intelligent Cube Editor

  • Modify the list of Report objects (use object browser).

To create cubes, you must have the following additional privileges:

  • Use Architect Editors

  • Create application objects

Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. The Editor and Filter panels are stacked together by default.

  1. Open the Workstation window.
  2. In the Navigation pane, click , next to Datasets.

  3. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK.

  4. Use the Objects section to search for the desired metrics and attributes and drag them into the Editor panel.

  5. Click Save and Publish.

  6. Click Publish to see the data preview.

  7. Switch to the SQL Query panel to view the associated SQL.