MicroStrategy ONE

List Report Cache Properties statement

Lists all of the properties for a report cache.

Copy 
LIST [ALL] PROPERTIES FOR REPORT 
 CACHE ("cache_name" 
 [FOLDER "location_path"] 
 | GUID cache_guid) IN PROJECT 
 "project_name";

where:

  • REPORT CACHE "cache_name" is the name of the report cache for which its properties are to be listed, of type string.

  • FOLDER "location_path" is the location of the report cache, of type string.

  • REPORT CACHE GUID cache_guid is the GUID of the report cache, of type GUID.

  • PROJECT "project_name" is the project from which the report cache properties 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 PROPERTIES 
 FOR REPORT CACHE "Top 10 Reports" IN PROJECT "Enterprise 
 Manager";

ResultSet Columns

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

CREATION_TIME: Date the report cache was created, returned as a date/string.

EXPIRATION: Expiration date of the report cache, returned as a date/string.

FOLDER: The folder path of the report, returned as a string.

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

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

LAST_HIT_TIME: Date of the last report cache hit, returned as a date/string.

LAST_LOAD_TIME: Date the report cache was last loaded, returned as a date/string.

LAST_UPDATED_TIME: Date the report cache was last updated, returned as a date/string.

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

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

REPORT_ID: ID of the report, 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: The type of the report cache, returned as a string.

WAITING_LIST: The waiting list of the report cache, returned as a string.