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

KB19211: How to verify if a report hits cache when run from MicroStrategy Web 9.x when the Cache Monitor in MicroStrategy Desktop 9.x is not available


Community Admin

• Strategy


How to verify if a report hits cache when run from MicroStrategy Web 9.x when the Cache Monitor in MicroStrategy Desktop 9.x is not available

When using Strategy Web 9.x, users executing reports may need to know if the report hit cache or not to verify if the information is up to date.
 
The user will be able to confirm if the report hit cache by locating and verifying the "Last update" timestamp, located at the upper right corner of the report. If the timestamp indicates a time period from before the report finished executing, then this means the report was pulled from cache. If the "Last update" timestamp coincides with the actual time the report finishes executing, then the report did not hit cache, and if configured to create a report cache, it will either have generate a new cache or updated an existing cache.
 
For example:
 
After the execution of the following report, the user can verify the "Last update" timestamp to confirm that it is the same as the actual time when the report finished executing:
 

ka04W000000Oh5nQAC_0EM4400000028Wc.jpeg

Both the timestamp and the machine clock indicate the same time.
 
If a cache exists and the user runs the same report again, the "Last update" timestamp will NOT be the same as the machine's current time when the results come back. It will be an earlier time, which means that the report hit cache:
 

ka04W000000Oh5nQAC_0EM4400000028Wg.jpeg

If the user is able to open and verify the Cache Monitor in Strategy Desktop 9.x, the entries will confirm the aforementioned behavior.
 

ka04W000000Oh5nQAC_0EM4400000028Wa.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

June 5, 2017

Last Updated:

June 5, 2017