MicroStrategy ONE

List Caching Properties statement

Lists properties for report caching, object caching, element caching, or all caching.

Copy 
LIST [ALL] 
 PROPERTIES FOR [(REPORT | OBJECT | ELEMENT)] CACHING IN [PROJECT] "project_name";

where:

  • REPORT lists only the properties for report and document caching.

  • OBJECT lists only the properties for object caching.

  • ELEMENT lists only the properties for element caching.

  • PROJECT "project_name" is the name of the project for which the caching 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 CACHING IN PROJECT "MicroStrategy 
 Tutorial";

ResultSet Columns

LIST ALL PROPERTIES FOR CACHING IN PROJECT

  • ELEMENT_CACHING: ResultSet containing the properties for element caching in a project.

    • CREATE_CACHES_PER_DBCONNECTION: Whether caches are created for database connections, returned as a boolean value.

    • CREATE_CACHES_PER_DBLOGIN: Whether caches are created for database logins, returned as a boolean value.

    • MAX_RAM_USAGE: The maximum RAM usage for element caching in a project, returned as an integer.

    • MAX_RAM_USAGE_CLIENT: The maximum RAM usage for element caching for a client and project, returned as an integer.

  • OBJECT_CACHING: ResultSet containing the properties for object caching in a project.

    • MAX_RAM_USAGE: Maximum RAM usage for object caching in a project, returned as an integer.

    • MAX_RAM_USAGE_CLIENT: Maximum RAM usage for object caching for a client and project, returned as an integer.

  • REPORT_CACHING: ResultSet containing the properties for report caching in a project.

    • CACHE_EXPIRATION: A value which represents when the cache will expire, such as the value "Never". Returned as a string.

    • CREATE_CACHES_PER_DBCONNECTION: Whether caches are created per database connection, returned as a boolean value.

    • CREATE_CACHES_PER_DBLOGIN: Whether caches are created per database login, returned as a boolean value.

    • CREATE_CACHES_PER_USER: Whether caches are created per user, returned as a boolean value.

    • ENABLED: Whether report caching is enabled, returned as a boolean value.

    • ENABLE_NON_PROMPTED_CACHING: Whether non-prompted caching is enabled, returned as a boolean value.

    • ENABLE_PROMPTED_CACHING: Whether prompted caching is enabled, returned as a boolean value.

    • ENABLE_RWD_CACHING: Whether caching of Report Services documents is enabled, and if so what formats are cached, returned as a string.

    • ENABLE_XML_CACHING: Whether XML caching is enabled, returned as a boolean.

    • FOLDER: Folder path of the project for which the caching properties are to be listed, returned as a string.

    • FORMATTED_DOC_MAX_NO_CACHE: Maximum number of document caches, returned as an integer.

    • FORMATTED_DOC_MAX_RAM_CACHE: Maximum amount of RAM used for document caching, returned as an integer.

    • LOAD_ON_STARTUP: Whether to load the report cache on startup, returned as a boolean value.

    • MAX_NUMBER_OF_CACHES: Maximum number of report caches, returned as an integer.

    • MAX_RAM_USAGE: Maximum amount of RAM used for report caching, returned as an integer.

    • RAM_SWAP_MULTIPLIER: The RAM swap multiplier used for report caching, returned as an integer.

    • RECORD_PROMPT_ANSWERS: Whether to record prompt answers with prompted caches, returned as a boolean.

LIST ALL PROPERTIES FOR OBJECT CACHING IN PROJECT

  • MAX_RAM_USAGE: Maximum RAM usage for object caching in a project, returned as an integer.

  • MAX_RAM_USAGE_CLIENT: Maximum RAM usage for object caching for a client and project, returned as an integer.

LIST ALL PROPERTIES FOR ELEMENT CACHING IN PROJECT

  • CREATE_CACHES_PER_DBCONNECTION: Whether caches are created for database connections, returned as a boolean value.

  • CREATE_CACHES_PER_DBLOGIN: Whether caches are created for database logins, returned as a boolean value.

  • MAX_RAM_USAGE: The maximum RAM usage for element caching in a project, returned as an integer.

  • MAX_RAM_USAGE_CLIENT: The maximum RAM usage for element caching for a client and project, returned as an integer.

LIST ALL PROPERTIES FOR REPORT CACHING IN PROJECT

  • CACHE_EXPIRATION: A value which represents when the cache will expire, such as the value "Never". Returned as a string.

  • CREATE_CACHES_PER_DBCONNECTION: Whether caches are created per database connection, returned as a boolean value.

  • CREATE_CACHES_PER_DBLOGIN: Whether caches are created per database login, returned as a boolean value.

  • CREATE_CACHES_PER_USER: Whether caches are created per user, returned as a boolean value.

  • ENABLED: Whether report caching is enabled, returned as a boolean value.

  • ENABLE_NON_PROMPTED_CACHING: Whether non-prompted caching is enabled, returned as a boolean value.

  • ENABLE_PROMPTED_CACHING: Whether prompted caching is enabled, returned as a boolean value.

  • ENABLE_RWD_CACHING: Whether caching of Report Services documents is enabled, and if so what formats are cached, returned as a string.

  • ENABLE_XML_CACHING: Whether XML caching is enabled, returned as a boolean.

  • FOLDER: Folder path of the project for which the caching properties are to be listed, returned as a string.

  • FORMATTED_DOC_MAX_NO_CACHE: Maximum number of document caches, returned as an integer.

  • FORMATTED_DOC_MAX_RAM_CACHE: Maximum amount of RAM used for document caching, returned as an integer.

  • LOAD_ON_STARTUP: Whether to load the report cache on startup, returned as a boolean value.

  • MAX_NUMBER_OF_CACHES: Maximum number of report caches, returned as an integer.

  • MAX_RAM_USAGE: Maximum amount of RAM used for report caching, returned as an integer.

  • RAM_SWAP_MULTIPLIER: The RAM Swap Multiplier used for report caching, returned as an integer.

  • RECORD_PROMPT_ANSWERS: Whether to record prompt answers with prompted caches, returned as a boolean.