MicroStrategy ONE

Disabling Result Caching

By default, result caching is enabled in Intelligence Server. If the performance gain is marginal compared to the added overhead, you can disable report caching. You may want to disable caching in the following situations:

  • The data warehouse is updated more than once a day.
  • Most reporting is ad hoc so caching provides little value.
  • Reports are heavily prompted, and the answer selections to the prompts are different each time the reports are run.
  • Few users share the same security filters when accessing the reports.

If you disable result caching for a project, you can set exceptions by enabling caching for specific reports or documents. For more information, see Configuring Result Cache Settings.

To Disable Result Caching

  1. Open the Project Configuration Editor for the project.
  2. Expand Caching, expand Result Caches, then select Creation.
  3. To disable report and document caching, clear the Enable report server caching check box.
  4. To disable document caching but not report caching, leave the Enable report server caching check box selected and clear the Enable document output caching in selected formats check box.
  5. Click OK.