MicroStrategy ONE

List Report Caches statement

Lists report caches on an Intelligence Server.

Copy 
LIST [ALL] 
 REPORT CACHES [MAXSIZE max_cache_size] 
 [MINSIZE min_cache_size] [TYPE 
 (FOREIGN | HISTORY | MATCHING | XML)] [FOR USER user_login] 
 [FOR PROJECTproject_name];

where:

  • MAXSIZE max_cache_size is the maximum size of caches that are listed, of type integer.

  • MINSIZE min_cache_size is the minimum size of caches that are listed, of type integer.

  • TYPE is the type of report cache to be listed. If omitted, all report caches are listed.

    • FOREIGN lists foreign caches.

    • HISTORY lists History and Matching-History caches.

    • MATCHING lists Matching and Matching-History caches.

    • XML lists MicroStrategy Web XML caches.

  • USER "user_login" is the login name of the user who created the caches, of type string.

  • PROJECT "project_name" is the project from which the report caches are to be listed, of type string.

This statement can only be used with three-tier or four-tier project source names.

Example

Copy 
LIST 
 ALL REPORT CACHES FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

PROJECT: The name of the project, returned as a string.

REPORT_CACHE_LIST: A ResultSet containing a list of report caches.

CACHE_FILE_SIZE: The size of the cache file, in kilobytes, returned as an integer.

HIT_COUNT: The hit count of the cache, returned as an integer.

ID: ID of the report cache, returned as a string.

LAST_HIT_TIME: Timestamp for the last time the cache was hit, returned as a date/string.

REPORT_CACHE: Name of the report cache, returned as a string.

REPORT_ID: GUID of the report that is cached, returned as a string.

STATUS_LIST: A ResultSet listing the statuses of the report cache.

  • CACHE_STATUS: The status of the report cache, returned as an integer:

    • 1: Ready

    • 2: Processing

    • 4: Invalid

    • 8: Expired

    • 16: Loaded

    • 32: Updated

    • 64: Dirty

    • 128: Waiting to remove

    • 256: Filed

    • 512: Dirty

    • 1024: Deleted

    • 2048: XML Cache Dirty

    • 4096: Process Pending

    • 8192: Updating

TYPE: Type of the report cache, returned as a string.