MicroStrategy ONE
Subscribe a Dashboard, or Report to a Cache Update
In MicroStrategy Workstation you can create cache subscriptions through Distribution Services. This subscription allows a reportto be run as quickly as possible using the latest available data without query the data warehouse.
Cache update subscriptions refresh the cache for a 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 to be retrieved more quickly than re-executing the request against the data warehouse.
Check out the video below to learn more!
-
Open the Workstation window with the Navigation pane in smart mode.
-
In the Navigation pane, inside the Administration group, click next to Subscriptions.
-
Choose an environment and project, then click Select.
-
In Name, enter a descriptive name for the subscription.
-
From the Type drop-down, choose Cache Update.
-
To add content to the subscription, click in the Content pane.
-
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.
-
Once the schedule is set, you can optionally specify the date when the subscription should stop by selecting the date in Stop After.
-
You can choose to create a cache for MicroStrategy Web/Mobile or Library (for dashboards).
-
Click on the empty field under Generate caches for users or groups to choose the cache subscription recipients.
-
To send a notification when the subscription executes and the cache is updated, select Send notification to user’s email when cache is updated.
-
You can choose to Run the subscription immediately after saving.
-
Click Save.