List Intelligent Cube Cache Properties statement

Lists all of the properties for an Intelligent Cube cache.

Copy

LIST [ALL] PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "cube_name" [FOLDER "folder_name"] | GUID cache_guid) FOR PROJECT "project_name";

where:

NAME "cube_name" is the name of the Intelligent Cube, of type string.
FOLDER "folder_name" is the name of the folder containing the Intelligent Cube, of type string.
GUID cache_guid is the GUID of the Intelligent Cube cache, of type GUID.
PROJECT "project_name" is the project from which the cache properties are to be listed, of type string.

Example

Copy

LIST ALL PROPERTIES 
 FOR INTELLIGENT CUBE CACHE GUID 1234567890ABCDEF IN PROJECT "Development 
 Project 5";

CACHE_FILE_NAME: The name of the Intelligent Cube cache file, returned as a string.

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.

HISTORIC_HIT_COUNT: The historic hit count of the Intelligent Cube, returned as an integer.

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.

INTELLIGENT_CUBE_DEF_ID: The ID of the Intelligent Cube definition, returned as a string.

INTELLIGENT_CUBE_REPORT_NAME: The name of the report used for the Intelligent Cube definition, returned as a string.

LANGUAGE_RESULT_SET: A ResultSet listing the languages used for the Intelligent Cube.

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

LAST_UPDATE_JOB: Job ID of the last Intelligent Cube update, returned as an integer.

NO_OF_COLUMNS: Number of columns in the Intelligent Cube, returned as an integer.

NO_OF_ROWS: Number of rows in the Intelligent Cube, returned as an integer.

OPEN_VIEW_COUNT: Number of currently open views on the Intelligent Cube, returned as an integer.

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

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

STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube.