MicroStrategy ONE

List Intelligent Cube Properties Statement

Lists all properties from a given intelligent cube within a project.

Copy 
LIST [ALL] PROPERTIES FOR INTELLIGENT CUBE ("<cube_name>" IN FOLDER "<location_path>" | GUID <intelligent_cube_guid>)[(TBID <table_id> [ <table_id> ...] | TBNAME "<table_name>" [, "<table_name>" ...])] FOR PROJECT "<project_name>";

where:

  • cube_name is the name of the intelligent cube whose properties are to be listed, of type string, between double quotes.
  • location_path is the folder where the intelligent cube resides, of type string, between double quotes.
  • intelligent_cube_guid is the GUID of the Intelligent Cube, of type GUID.
  • project_name is the name of the project, of type string, between double quotes.
  • table_id: is the GUID of a table
  • table_name: is the name of a table.

This command will list the table information only when the intelligent cube is a super cube. This command can get the correct cube status and table status only when the cube is being refreshed or published in the same session between Command Manager and Intelligence Server as this command's.

Example

Copy 
LIST PROPERTIES FOR INTELLIGENT CUBE  "DATA_IMPORT_SQL_STATEMENT" IN FOLDER "\Public Objects\Reports\MicroStrategy Platform Capabilities\Extended Data Access\Import Data"  FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

NAME: is the name of the intelligent cube, returned as a string.

PATH: is the folder where the intelligent cube resides, returned as a string.

GUID: is the GUID of the intelligent cube, returned as a string.

INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value.

HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value.

ICUBE_STATUS: shows the status of the intelligent cube, returned as a string value

SCHEMA_CANDIDATE_TABLE_LIST: is a ResultSet of the tables in the intelligent cube:

  • NAME: the name of the table, returned as a string.
  • GUID: the GUID of the table, returned as a string.
  • DATA_IMPORT_TYPE: the source type of the table, returned as a string.
  • TABLE_REFRESH_STATUS: shows the status of the table, returned as a string.
  • TABLE_REFRESH_POLICY: shows the refresh policy, returned as a string.