MicroStrategy ONE

List Document Caches statement

Lists all document caches on an Intelligence Server.

Copy 
LIST [ALL] 
 DOCUMENT CACHES IN PROJECT "project_name";

where:

  • PROJECT "project_name" is the project from which the document 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 DOCUMENT CACHES IN PROJECT "MicroStrategy Tutorial";

ResultSet Columns

DOCUMENT_CACHE_LIST: A ResultSet containing information about a document cache:

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

  • CACHE_FORMAT: The format of the cache, returned as an integer:

    • 1: Excel

    • 2: PDF

    • 3: CSV

    • 4: HTML

    • 5: Plain text

    • 6: XML

    • 7: Flash

    • 8: View

    • 9: Interactive

    • 10: Editable

    • 11: Flash export

    • 12: Flash in MHT

    • 13: Flash in PDF

    • 14: Mobile smartphone

    • 15: Mobile tablet

  • EXPIRATION: Date and time the cache expires, returned as a date/string.

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

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

  • LAST_HIT_TIME: Date the cache was last hit, returned as a date/string.

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

  • REPORT_CACHE:

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

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

      • 1: Ready

      • 2: Processing

      • 4: Invalid

      • 8: Expired

      • 16: Loaded

      • 32: Persisted

      • 64: Info Dirty

      • 128: Result Dirty

      • 256: Converted from report

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