Subscribe a Dashboard, Document, or Report to a Cache Update

In MicroStrategy Workstation you can create cache subscriptions through Distribution Services. This subscription allows a report or document to be run as quickly as possible using the latest available data without query the data warehouse.

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

Check out the video below to learn more!

1. Open the Workstation window with the Navigation pane in smart mode.

2. In the Navigation pane, inside the Administration group, click next to Subscriptions.

3. Choose an environment and project, then click Select.

4. In Name, enter a descriptive name for the subscription.

5. From the Type drop-down, choose Cache Update.

   

6. To add content to the subscription, click in the Content pane.

7. You can schedule the subscription based on a time or event. From the Schedule drop-down, select a schedule to control how often the subscription occurs. SeeCreate and Edit Schedules for more information about creating a new schedule.

8. Once the schedule is set, you can optionally specify the date when the subscription should stop by selecting the date in Stop After.

9. You can choose to create a cache for MicroStrategy Web/Mobile or Library (for dashboards).

10. Click on the empty field under Generate caches for users or groups to choose the cache subscription recipients.

11. To send a notification when the subscription executes and the cache is updated, select Send notification to user’s email when cache is updated.

12. You can choose to Run the subscription immediately after saving.

13. Click Save.