MicroStrategy ONE

Reporting and analyzing data with personal Intelligent Cubes

While creating and viewing reports in MicroStrategy, you can utilize various OLAP Services features to report and analyze data using an in-memory copy of data rather than querying the data warehouse. When OLAP Services features are used on-the-fly in reports while performing full ROLAP analysis, the in-memory copy of data is referred to as a personal Intelligent Cube (see About personal Intelligent Cubes).

Personal Intelligent Cubes are created automatically for reports that utilize OLAP Services features. This provides both OLAP Services features and full ROLAP analysis on your report with no overhead to create or maintain an Intelligent Cube, or to link your report to an Intelligent Cube.

As you build and modify your report, the personal Intelligent Cube is updated to reflect your ROLAP analysis. While this provides full ROLAP analysis along with OLAP Services analysis, this can require requerying the data warehouse and generating new report SQL. Also, the OLAP Services feature known as derived elements is unavailable for reports that use personal Intelligent Cubes. For a full comparison of personal Intelligent Cubes and Intelligent Cubes, seeDeciding when to use personal Intelligent Cubes and Intelligent Cubes.

Along with all of the standard reporting features available in MicroStrategy, the OLAP Services features listed below can be used when reporting on personal Intelligent Cubes:

The documentation sources listed above describe how to use various OLAP Services features with reports. For information on how to create reports and use all the standard reporting features available in MicroStrategy, see the Basic Reporting Help and the Advanced Reporting Help.