MicroStrategy ONE

List Intelligent Cube Caches statement

Lists all Intelligent Cube caches on an Intelligence Server.

Copy
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

Copy
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