MicroStrategy ONE

Caching documents

A cache is the stored results of a document query that has already been executed. When the document is executed again, the system can quickly access the cache to display the data, rather than putting a load on the system to re-run the request to the data source.

Enable document caching to generate the document only once, the first time that you execute a document in a specific mode (such as Express Mode or Interactive Mode) in MicroStrategy Web. Subsequent document executions in the same mode use the cache. Disable document caching to submit the document query to your data warehouse every time that you execute the document in a different mode.

You define the document caching options in MicroStrategy Developer, but documents are cached only when they are executed or exported in MicroStrategy Web. MicroStrategy Developer does not cache documents.

The benefits of document caching include:

  • Faster single-user response times.

  • The ability to support more concurrent users accessing complex document.

  • Lower total memory and CPU consumption for the same workload.

You can also use the default project-level behavior instead, which is set in the Project Configuration Editor.

You can select which formats to cache. Formats include:

  • Excel (when the document is exported to Excel in MicroStrategy Web)

  • HTML (when the document is exported to HTML view in MicroStrategy Web)

  • PDF (when the document is exported to PDF in MicroStrategy Web)

  • XML (when the document's mode is changed, as from Express Mode to Interactive Mode, in MicroStrategy Web)

By default, a cache is not created for every page-by combination that can be run, since that can use much of the memory allocated to caches. For more information, see Caching and page-by interaction.

To enable document caching

  1. Open a document in the Document Editor. How?

  2. From the Format menu, select Document Properties. The Document Properties dialog box opens.

  3. Select Caching.

  4. Select Enable document caching.

  5. Select the formats to cache.

  6. Choose whether to Create cache when page-by selections are modified. If this check box is selected, a new cache is created each time a user selects a different page.

  7. Click OK to return to the document.

To disable document caching

  1. Open a document in the Document Editor. How?

  2. From the Format menu, select Document Properties. The Document Properties dialog box opens.

  3. Select Caching.

  4. Select Disable document caching.

  5. Click OK to return to the document.

Related Topics