MicroStrategy ONE

Converting reports into Intelligent Cubes

If you have an existing report that contains a set of objects you want to use in an Intelligent Cube, you can convert the report into an Intelligent Cube.

Creating an Intelligent Cube by converting a report allows you to view the set of data you are including in your Intelligent Cube. This is an easy way to share a report's set of data among multiple reports.

Intelligent Cubes do not display report results in the same way as reports can. Instead of building an Intelligent Cube from the start, you can build a report; execute it; view the report data in grid, graph, or grid and graph mode; and then convert the report to an Intelligent Cube. With this method you can verify that you have the set of data you want, rather than just the required report objects, before you publish it as an Intelligent Cube.

When you convert a report to an Intelligent Cube, some parts of the report are not included in the resulting Intelligent Cube. Intelligent Cubes are not used for the same display and analysis purposes as a report. Intelligent Cubes simply act as a sharable set of data. Therefore, when a report is converted into an Intelligent Cube, some of the display and analysis features are no longer necessary. For a list of features that are not included in an Intelligent Cube when converting a report to an Intelligent Cube, see Supporting various features using Intelligent Cubes.

The procedure below explains the high-level steps for converting a report to an Intelligent Cube. The procedure assumes you have already created a report.

Prerequisites

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

To convert a report to an Intelligent Cube

  1. Right-click the report and select Edit. The Report Editor opens.

  2. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube.

  3. Save the Intelligent Cube.

  4. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. To publish an Intelligent Cube, see Publishing Intelligent Cubes.