Schedule a Cache Update

You can subscribe an individual report or document to a cache update. This subscription allows the report or document to be run as quickly as possible using the latest available data, without having to query the data warehouse.

This subscription is a good candidate for event-triggered schedules.

About Cache Update Subscriptions

Cache update subscriptions refresh the cache for the specified report, subset report, or document. A cache is a pre-calculated and pre-processed result set that is stored in memory on the Intelligence Server machine and on disk, and enables the report or document to be retrieved more quickly than re-executing the request against the data warehouse.

Your system contains a set of standard weekly and monthly reports. These reports should be cached because they are frequently accessed. Certain tables in the database are refreshed weekly, and other tables are refreshed monthly. Whenever these tables are updated, the appropriate caches should be refreshed.

To Subscribe a Report or Document to a Cache Update

Do one of the following:
- For a report cache update, click the name of the report to run it.
- For a document cache update, edit the document in Design Mode or Editable Mode.
  - To edit a document in Design Mode, from a folder, right-click the document and select Edit. If the document is open in Presentation Mode, click the menu icon on the right, and select Edit.
  - To edit a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable.
From the Home menu, point to Subscribe to, and select Cache Update.
In the Name field, type the name of the subscription. The default name is the name of the report/document and the date and time the subscription is created.
From the Schedule drop-down, select a schedule to control how often the subscription occurs. You can create new schedules in the MicroStrategy Developer Schedule Manager. For steps, see the Scheduling Jobs and Administrative Tasks chapter in the System Administration Help.
By default, you are the recipient for the subscription. To add additional recipients or to remove yourself from the subscription, click To. Select the users and groups that you want to receive the subscription and click OK.
From the Delivery Format drop-down, select the delivery format from the following options:
- HTML
- HTML5
- Excel
- PDF
- Plain Text (report only)
- CSV (report only)
To use the valid caches for the datasets in the document, select the Use valid dataset caches checkbox. (Document only)
To execute the report or document immediately when the subscription is saved, select the Run subscription immediately checkbox.
To end the subscription on a specific date, expand Advanced Options, select the Do not deliver after checkbox, and select the date from the drop-down calendar.
To send a notification when the subscription executes and the cache is updated, select the Send notification to email address checkbox. Then from the To drop-down, select the email address. If the email address is not in the list, click Send to new address to specify a new email address.
Click OK.
To verify that you are subscribed to the report or document, click the MicroStrategy icon , and select My Subscriptions. A list of the items to which you are subscribed appears.

Schedule a Cache Update

About Cache Update Subscriptions

To Subscribe a Report or Document to a Cache Update

Related Topics