MicroStrategy ONE

Caching a report

A report cache is the stored result set from an executed report, or the definition and data of a previously run report. Using report caches improves the query response time when the report is run again.

For more information on report caching, see the following topics:

For more information on caching, see the Caching chapter in the System Administration Help. For information on Intelligent Cubes, which can allow reports to execute on a pre-calculated set of data similar to using a report cache, see Sharing sets of data among reports: Intelligent Cubes.

To enable or disable caching for a specific report

  1. In MicroStrategy Developer, edit the report by right-clicking the report and selecting Edit. The Report Editor opens.

  2. From the Data menu, select Report caching options. The Report Caching Options dialog box opens.

  3. Select whether to enable or disable caching of this report:

    • To enable caching for this report even if caching is disabled at the project level, select the Enable Caching option.

    • To disable caching for this report even if caching is enabled at the project level, select the Disable Caching option.

    • To use the default project-level setting for caching, select the Use default project-level behavior option. This indicates that the caching settings configured at the project level in the Project Configuration editor apply to this specific report or document as well.

  4. Click OK. The Report Caching Options dialog box closes and your changes are saved.

To select a schedule for invalidating a specific report cache

  1. In MicroStrategy Developer, edit the report by right-clicking the report and selecting Edit. The Report Editor opens.

  2. From the Data menu, select Report caching options. The Report Caching Options dialog box opens.

  3. Select the Do not expire cache check box.

  4. The Invalidate cache on schedule drop-down list contains all the schedules available for the project source. Select the schedule to use for invalidating the report cache.

  5. Click OK. The Report Caching Options dialog box closes and your changes are saved.

Related Topic