MicroStrategy ONE
How to Create 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. You can also merge multiple intelligent cubes to produce a new dataset while maintaining any existing connections to the cubes. For more information, see the Merging Intelligent Cubes section of the In-memory Analytics Help.
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 Help.
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 Help.
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
- Click Create on any folder page, point to New Report, and select Intelligent Cube Report.
- Browse to and select a previously saved Intelligent Cube on which to build your report.
- Click Select.
- Drag and drop the objects into the report grid from the Report Objects pane.
- Click Run Report.