Caching

In general, a cache holds recently accessed values to increase performance. Frequently-requested reports are often cached, providing faster execution because the cached reports do not have to access the data warehouse.

Default settings for the report caches for all reports in a project are commonly configured by your system administrator. You can override the default settings for specific reports. For example, you may want to enable caching for a specific report, even if other reports in your system are not cached, because it puts a large load on the data warehouse. Or, you may want to disable caching for a specific report, even if other reports in your system are cached, because the data used in the report changes so often that the cached version of the report is rarely valid.

You can also select a specific schedule for invalidating the cache. Invalidating a report cache indicates to Intelligence Server that this cache should not be used. For example, you can schedule the cache to be invalidated every time new data is loaded into the data warehouse. In this case, the first time the report is executed after the data load, a new cache is created, with the most up-to-date data.

For reports, the following caches are used:

• The report cache contains pre-processed report data and is stored on disk. Report caches are created automatically. To create a subset report cache, see KB483046.
• Intelligent Cubes are similar to report caches in that they provide a set of data that reports can quickly retrieve without having to re-query a data source. Unlike report caches, Intelligent Cubes are created manually. Intelligent Cubes also allow reports to utilize various OLAP Services features. For an introduction to Intelligent Cubes, see Intelligent Cubes.

For detailed information about all types of caches, see the System Administration Help.

To Enable or Disable Caching for a Specific Report

1. In MicroStrategy Developer, open the report in the Report Editor.
2. Choose Data > Report caching options.
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 option called Enabled: This report should be cached.
• To disable caching for this report even if caching is enabled at the project level, select the option called Disabled: This report should not be cached.
• 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.