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) 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 documents.
• Lower total memory and CPU consumption for the same workload.

You can use the default project-level behavior instead, which is set in the Project Configuration Editor. For information and instructions, see the Project Design Guide.

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, selectors, and widgets.

To enable document caching

  1. In MicroStrategy Developer, open the document in Design View.

  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, chooses a different selector item, or interacts with a widget. For more details on this type of caching, see Caching and page-by, selectors, and widgets.

  7. Click OK to save your changes.