MicroStrategy ONE

Caching and page-by, selectors, and widgets

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 example, for a document paged by Region, a separate cache would be created for each region.

You may want to create a cache for the region that is used most frequently, or for the default region. The Create cache when page-by selections are modified setting allows you to do this. When this check box is selected, caches are also created when a different item is chosen in a selector or when a user interacts with a widget. For instructions to page a document, and the effects of paging a document, see Using page-by on a document. For general information about selectors and widgets, including instructions and examples, see the Dashboards and Widgets Creation Guide.

To use document caching in this way, you:

  1. Enable page-by caching before executing the document.

  2. Select the page, item, or widget view that you want to cache.

  3. Disable page-by caching.

Detailed instructions follow.

To enable document caching for page-by

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. Select the Create cache when page-by selections are modified check box.

  7. Click OK to return to the document.

  8. Save the document.

Cache the information

  1. In MicroStrategy Web, open the document in Presentation Mode.

  2. Select the page, item, or widget view that you want to cache.

  3. Save the document.

Disable page-by 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. Clear the Create cache when page-by selections are modified check box.

  5. Click OK to return to the document.

  6. Save the document.