Creating a report that accesses an Intelligent Cube

You can perform all of your reporting and data analysis requirements within an Intelligent Cube without executing against the data warehouse. Once an Intelligent Cube is created and then published so its data is available, multiple reports can be created to connect to the Intelligent Cube.

Reporting on a shared Intelligent Cube provides quick access to data as the data has been pre-aggregated. This returns report results much faster than querying the data warehouse. Reporting on Intelligent Cubes also allows you to use all of the OLAP Services features, including derived elements. Derived elements allow you to group attribute elements in a report on-the-fly to provide a new view of report data for analysis and formatting purposes.

Reports that connect to an Intelligent Cube are restricted to only the data available within the Intelligent Cube. This ensures that report results are returned quickly, and it also prevents full ROLAP analysis. Report filters, consolidations, and custom groups are not available for reports that connect to Intelligent Cubes. For a full comparison of personal Intelligent Cubes and Intelligent Cubes, see the In-memory Analytics Guide.

~ If security filters are used to maintain data access security, there are some differences in security filter resolution for reports connected to Intelligent Cubes. For information on these differences, see the In-memory Analytics Guide.

Prerequisites

To create a report from a cube source, you must have the Web Professional privilege called Web Define Intelligent Cube Report.
An Intelligent Cube has been created and published.

To create a report that accesses an Intelligent Cube

1 Click the MicroStrategy icon MicroStrategy icon at the upper left of any page and select New Report.
2 Click Choose Intelligent Cube. The Select Cube Report dialog box opens.
3 Browse to and select a previously saved Intelligent Cube on which to build your report.
4 Click OK. The report opens with all the objects of the Intelligent Cube included in the Report Objects pane on the left.
5 Drag and drop the objects into the report grid from the Report Objects pane.
6 Click Run Report.

Related topics

Creating a report
Creating a report using a template
Creating MDX cube reports