MicroStrategy ONE
Shared MDX Cube Objects
The data and objects that are shared in your MDX cube source are also shared as attributes in MicroStrategy projects. This maintains a consistent experience across all related MDX cubes imported into MicroStrategy.
For example, you import Cube1 and Cube2 into MicroStrategy. Both MDX cubes share data for year and category. In MicroStrategy, year data is mapped to an attribute named Year, and category data is mapped to an attribute named Category. If you change the name of the Year attribute in Cube1, this change is also reflected in Cube2. If you change the name of the Category attribute in Cube2, this change is also reflected in Cube1.
Attributes that are shared by multiple MDX cubes can have an effect on how and when attributes are imported for an MDX cube. For information on how these shared attributes can affect import behavior, see Shared attribute effects on import behavior.
Sharing metrics between MDX cubes
By default, each MDX cube creates its own metric objects to support the integration of the data into MicroStrategy. However, you can manually map metrics for multiple MDX cubes to the same metric so that they share a single metric. Sharing metrics between MDX cubes is required if you want to allow MDX cube reports to be able to switch the MDX cube that is used as the source of its data, as described in Switching the MDX Cube for an MDX Cube Report.
At least two MDX cubes must be imported into your MicroStrategy project. These MDX cubes must have data that can be mapped to the same metric.
To share metrics between MDX cubes
- 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
- In the Physical View column, choose Measures to view the metrics for the MDX cube.
- Right-click a metric and choose Map.
- Navigate to a different MDX cube that has similar metric data. Select the metric and click Open.
- Once all relevant metrics are shared, from the MDX Cube Editor, click Save and Close.