Strategy ONE
Updating MDX Cube Structure
Updating the structure of an MDX cube synchronizes the MDX cube definition in the Strategy project with the latest MDX cube model in the MDX cube source. As a result, any addition or deletion of levels is reflected in the MDX cube structure that has been imported.
You can update an MDX cube to point to a different MDX cube from the same MDX cube source. For example, your current MDX cube includes data for the year 2014. A new source of data for 2015 is to be included in Strategy as an MDX cube. You can import this data as a new MDX cube in Strategy. Alternatively, you can update the current MDX cube to point to this new data. This update requires that the data for both MDX cubes is similar in structure so that the definition of the MDX cube in Strategy is maintained. You can use Command Manager to apply this update to an MDX cube, and the scripts required are described in the help for Command Manager Help.
If any MDX cubes have been deleted from the cube source, that information is also updated in Strategy. If any Strategy reports used those MDX cubes, those reports will fail when they are run again.
If you migrate MDX cube reports and other MDX cube objects between multiple projects, all MDX cube updates should be performed in a single project and migrated over to the other projects. For best practices on maintaining MDX cubes between multiple projects, see Maintaining MDX Cubes Between Multiple Projects.
To update an MDX cubes structure
- In Developer, log in to a project that is connected to an MDX cube source. Only one user can edit a project at a time.
-
Choose Schema > MDX Cube Catalog.
If the project connects to more than one MDX cube source, choose an MDX cube source database instance from the Select the Database Instance drop-down list, and then select an MDX cube source database instance and click OK to open the MDX Cube Catalog.
- Choose Cube Selection.
-
In the Selected Cubes pane, right-click an MDX cube and select Update Structure. If a new dimension has been added to a cube, new attributes and metrics are automatically mapped in Strategy and displayed on the Cube Mapping tab to reflect the change.
You can also modify any new MDX cube object mappings to Strategy objects in the Cube Mapping tab.
- Click Save and Close.