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

KB17713: What information is stored in a report cache in MicroStrategy Intelligence Server 9.x?


Community Admin

• Strategy


This KB article describes what information is stored in report cache .CHE and _INFO.CHE files in MicroStrategy Intelligence Server 9.x.

When Strategy Intelligence Server 9.x creates a report cache, two files are written to disk for the cached report. The file name .che contains the actual data and structure of the cached report. A second file with the filename _info.che is written with the information about the specific cache.
The following information is stored in the _info.che file created by Strategy Intelligence Server 9.x

  1. IDs and Version IDs of security filters
  2. Cache Security ID
  3. ID and Version ID of the Cache (Cache ID assigned to the cached report). It is on a per Project basis.
  4. ID and Name of the report for which the cache is created
  5. Template ID, Template Version ID
  6. Filter ID, Filter Version ID
  7. Total hitting count
  8. Total checking count
  9. Total update count
  10. Cache File size (kb)
  11. Cache Lifetime (ms)
  12. Report Cache Status flags
    • R = Ready
    • P = Processing
    • I = Invalid
    • E = Expired
    • F = Filed
    • L = Loaded
    • D = Dirty
    • U = Updated
  13. Create time
  14. Last update time
  15. Last load time
  16. Cache Expiry time
  17. Last Hit time
  18. Result update time
  19. Cache Type
  20. Inbox message reference count
  21. Report States
  22. Max XML Cache Ref ID
  23. User ID
  24. DB Login ID
  25. DB Connection ID
  26. Base Report Cache ID
  27. User Login
  28. Job ID for Cache Create job

The following information is stored in the .che file created by Strategy Intelligence Server 9.x:

  1. Serialized Report Instance
  2. Report definition ID, Report definition Version ID
  3. Count, IDs, Version IDs and Types of other application objects in the report definition
  4. Cache file name of the report result file
  5. Dirty flag
  6. Waiting list of jobs
  7. Inbox option flag
  8. Report Instance pointer
  9. Serialized Report Instance (in a binary stream)
  10. XML String
  11. Pointer to the Position in the LRU list
  12. Parent cache ID (for a XML cache)

Comment

0 comments

Details

Knowledge Article

Published:

June 7, 2017

Last Updated:

June 7, 2017