Refresh Cube statement

Refreshes the tables in an Intelligent Cube.

REFRESH TABLES [ ([REPLACE | UPDATEANDADD | UPDATE | ADD] |TBID <table_id> [REPLACE | UPDATEANDADD | UPDATE | ADD] [,<table_id> [REPLACE | UPDATEANDADD | UPDATE | ADD] ...] | TBNAME "<table_name>" [REPLACE | UPDATEANDADD | UPDATE | ADD] [, "<table_name>" [REPLACE | UPDATEANDADD | UPDATE | ADD] ...])] IN INTELLIGENT CUBE ("<cube_name>" IN FOLDER "<location_path>" | GUID <intelligent_cube_guid>) FOR PROJECT "<project_name>";

where:

• REPLACE: the refresh policy is Replacing existing data
• UPDATEANDADD: the refresh policy is Update existing data and add new data
• UPDATE: the refresh policy is Update existing data
• ADD: the refresh policy is Add new data
• table_id: is the guid of a table
• table_name: is the name of a table
• 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.

Example

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