EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB20539: How to leave a report cache valid while running a job to update the cache in MicroStrategy Developer 9.4.x-10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


Following data loads, some MicroStrategy administrators elect to run scheduled jobs to update report caches. In certain scenarios it is desirable to have the old cache remain valid with old data until the update job completes rather than have no data while the update job runs. This is particularly true with long-running reports.

Following data loads, some Strategy administrators elect to run scheduled jobs to update report caches. Under normal report executions or history list executions, the existing report cache will be invalidated as soon as the schedule request is submitted - preventing any cache hit while the report runs against the warehouse. In certain scenarios it is desirable to have the old cache remain valid with old data until the update job completes rather than have no data while the update job runs. This is particularly true with long-running reports.
 
To accommodate these scenarios, Strategy has the 'Cache Update' subscription type in Strategy Developer. When scheduling a report in Developer, users have the option to choose the 'Cache Update' option when right mouse clicking on a report.

ka02R000000kX1xQAE_0EM440000002J4D.png

 
When the Cache Update scheduled job executes, any existing caches will remain valid until the job successfully returns from the warehouse, at which point the cache is updated.


Comment

0 comments

Details

Knowledge Article

Published:

April 11, 2017

Last Updated:

April 11, 2017