Improving Reporting Performance – MicroStrategy Cache

When a Report is executed, it goes through the cycle we described in Chapter 1, Architecture - Installing and Configuring MicroStrategy, (Refer to Intelligent Server Engines): SQL Generation-Query Execution-Results format and Crosstab. However, for both complex Reports and very large Result sets, this process could take time and resources each time the Report is executed. For scenarios where ad hoc reporting is not needed, the result set from a previously executed Report can be stored in what MicroStrategy calls a cache. When a user executes a Report, a cache is created within a file and the Intelligence Server loads the result set into its memory.  Report caching can be enabled either at the Project level or at the Report level.

Note

Ad hoc reporting involves Reports that require users to answer one or more Prompts. These are sometimes also known as OLAP Reports.

There are two otherobjects that generate caches too: Intelligent Cubes and...