MicroStrategy ONE

Alter MDX cube statement

Changes the external MDX cube or catalog that a MicroStrategy MDX cube points to.

The newly referenced external cube must have the same dimensions, hierarchies, levels, measures, and all their corresponding properties as the previously referenced cube. For example, you can use this command when the only difference between the old and new external cubes is the year, and you want to change the MicroStrategy MDX cube to point to the cube with the new year's information.

Copy 
ALTER MDXCUBE (CUBEMDXNAME "mdx_cube_name" 
 | CATALOGMDXNAME "mdx_catalog_name" | CUBEMDXNAME "mdx_cube_name" CATALOGMDXNAME "mdx_catalog_name") FOR CUBEID mdx_cube_guid PROJECT "project_name";

where:

  • CUBEMDXNAME "mdx_cube_name" is the new name of the external MDX cube that this MicroStrategy MDX cube will point to, of type string.

  • CATALOGMDXNAME "mdx_catalog_name" is the new catalog name in the external MDX cube that the MicroStrategy MDX cube will point to, of type string.

  • CUBEID mdx_cube_guid is the object ID of the MicroStrategy MDX cube you are changing.

  • PROJECT "project_name" is the name of the project storing the MicroStrategy MDX cube you are changing, of type string.

After changing the cube with this statement, update the MDX cube structure so the changes take effect. For steps, see the MicroStrategy MDX Cube Reporting Guide.

Example

Copy 
ALTER MDXCUBE CUBEMDXNAME "SALESREC" CATALOGMDXNAME 
 "YEAR2015" FOR CUBEID CC32BB644531649C4A59C8861DEE1CEB PROJECT 
 "MicroStrategy Tutorial";