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 OLAP Services Guide.
Warning: 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 OLAP Services Guide.
You must have a Web Professional license and the Web Define Intelligent Cube Report Web Professional privilege to create a report from a cube source.
You must own the MicroStrategy OLAP Services product.
An Intelligent Cube has been created and published.
In the Shared Reports folder, click Create Report.
Click Choose Intelligent Cube. The Select Cube Report dialog box opens.
Browse to and select a previously saved Intelligent Cube on which to build your report.
Click OK. The report opens with all the objects of the Intelligent Cube included in the Report Objects pane on the left.
Drag and drop the objects into the report grid from the Report Objects pane.
Click Run Report.
Related topics