MicroStrategy ONE
List Intelligent Cube Caches statement
Lists all Intelligent Cube caches on an Intelligence Server.
LIST [ALL] INTELLIGENT CUBE CACHES
[FOR PROJECT "project_name"];
where:
PROJECT "project_name" is the project from which the caches are to be listed, of type string.
Example
LIST ALL INTELLIGENT
CUBE CACHES IN PROJECT "Development Project 5";
ResultSet Columns
CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer.
CREATOR: User who created the Intelligent Cube cache, returned as a string.
HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer.
ID: ID of the Intelligent Cube cache, returned as a string.
LAST_UPDATED_TIME: Date the Intelligent Cube cache was last updated, returned as a date/string.
NAME: The name of the Intelligent Cube, returned as a string.
STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube.
- 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