KB440564: Get Multi-Table Data Import (MTDI) cube refresh status via command manager in MicroStrategy 10.7 and above

Refresh individual tables and check status of the table refresh is available Strategy 10.7. The following commands have been added for Intelligent Cube management:

• Get the status of a Multi-Table Data Import (MTDI) cube refresh
• Get the status of table refresh within a MTDI cube

 
NOTE:
This command will list the table information only when the intelligent cube is a Multi-Table Data Import (MTDI) 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.
 
List Intelligent Cube Properties Statement
 
Lists all properties from a given intelligent cube within a project.
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.

Example

LIST PROPERTIES FOR INTELLIGENT CUBE  "DATA_IMPORT_SQL_STATEMENT" IN FOLDER "\Public Objects\Reports\Strategy Platform Capabilities\Extended Data Access\Import Data"  FOR PROJECT "Strategy 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.
 
 
Article Reference Number: KB440564
  KB440564