- Document formatting is often very CPU intensive. With large datasets, CPU gets maxed out with a small number of simultaneousdocument executions. Report Services Document Caching will increase concurrent document execution count.
- The process of generating document output consume a lot more memory than the final output itself. Report Services DocumentCaching will also reduce memory consumption.
- Configuring Report Services Document Caching via MicroStrategy Desktop
At the Project Level:
In the Project Configuration Editor, under Caching -> Result Caches-> Creation, select the setting called “Enable DocumentOutput Caching in Selected Formats” along with the desired output formats, as seen below:A separate section called “Formatted Documents” contains two additional settings for cache storage, as seen below:Note:Maximum RAM Usage limits the total amount of memory that can be used for document caching for a particular project. The default value is 256.Maximum number of caches limits the number of document caches allowed in the project at one time. The default value is 100,000
At the Document Level:
Document level cache settings can be found by going to Format menu and then to Document Properties as seen below:
Note: Document level settings override project level settings.In the Document Properties dialog box, select the Caching tab and the following dialog will show up where users can disable or enable document caching in various formats.
- Configuring Report Services Document Caching via MicroStrategy Web
As seen below, a new setting has been introduced in MicroStrategy 9 called “Create or Update Dataset Caches For DocumentExecutions From MicroStrategy Web”Note: This setting is enabled by default and is needed to create document and dataset caches. If this setting is not the dataset cacheswill not be created and subsequently no document caches will be created either.