In MicroStrategy 9, users can cache their entire formatted report services document output in different formats through the new feature called Report Services Document Caching.
As seen below, administrators can specify the output formats such as PDF, XML and Excel at the project level or at the document level. HTML formats can also be specified at the same level; however, HTML document caches are created when a document subscription is created with export format set to HTML.
Benefits of Report Services Document Caching
The benefits of Report Services Document Caching are two-fold:
- 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.
Support for Report Services Document Caching
Although Report Services Document Caching must be configured via MicroStrategy Desktop, Report Services Document cache creation is currently not supported via MicroStrategy Desktop. Document cache can be created via MicroStrategy Web, MicroStrategy Office, MicroStrategy Narrowcast Server and MicroStrategy Scheduler.
How to Enable Document Caching
Even though document cache creation is not supported in MicroStrategy Desktop, document caching must be first configured via MicroStrategy Desktop and then in MicroStrategy Web as seen below:
- 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.
TN20538: New Feature in MicroStrategy 9 – Report Services Document Caching