Preview Feature: Monitor Content Caches
Preview features are early versions of features and are not to be used in a production environment as the core behavior remain subject to change between preview and GA. By selecting to expose preview features in MicroStrategy Workstation, you can access these features and use them as you would any other dossier functionality. The official versions of preview features are included in subsequent releases.
Starting in the MicroStrategy 2021 Update 7 October Monthly Release, you can monitor content caches. Content caches in MicroStrategy are caches created by user executions and are pre-calculated and pre-processed data results for reports, documents, and dossiers. Content caches are stored in MicroStrategy’s Intelligence server memory disk to quickly retrieve data rather than re-executing reports or dossiers against the warehouse. Caching is a useful strategy your administrator can use to reduce demands on the database and improve the speed of MicroStrategy's reporting performance. However, cached data is not always the most up-to-date, because it has not been run through the data source since the cache was created.
Content caches can be created either with cache update subscriptions or manual executions by the user.
A report cache is a data store within MicroStrategy that holds information recently requested from the data source that appears on a report. A cache is created when a report is executed for the first time and the request is submitted to the database to gather the latest data. The report's results are then cached, or stored, in MicroStrategy. Generally, frequently requested reports are cached because future requests for the same reports return data faster if the report has been cached. The execution time is quicker because cached reports do not need to run against the data source. In a cache, results from your data source are stored and can be used by new job requests that require the same data.
You can get new data for a report that has been cached, by deleting the report's cache before you execute the report. Deleting the report's cache forces the report to be executed through the data source again, thus returning the most recent data from the data source. You must have administrative privileges to delete a report cache.
A document cache is cached data of a document that has already been executed. When the document is executed again, the system accesses the cache to display the data, rather than execute the SQL against the warehouse to render the data. Enable document caching to generate a cache the first time you execute a document. 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.
A dossier cache is cached data of a dossier that has already been executed. When a dossier is executed against a data source for the first time, it generates a cache. For every other execution of the dossier, the cache renders data immediately since it is fetched from the cached data.
An other cache is a cache introduced in Workstation that displays report and document caches executed as datasets for dossiers in MicroStrategy Library.
Open the Workstation window.
In the Navigation pane, under Administration, click Monitors.
In the left pane, click Caches.
Right-click a cache to view its details, load/unload it from memory, or delete it.