MicroStrategy ONE
Switching the MDX Cube for an MDX Cube Report
After creating an MDX cube report, you can switch the MDX cube that is used as the source of data for the report. This can be helpful if another MDX cube has other additional or updated attribute information that could be of importance to the report.
The attributes that are included on the template of the MDX cube report must also be available in the MDX cube you are switching to. If the MDX cubes are from the same MDX source, the attributes are shared between the MDX cubes by default, as described in Shared MDX Cube Objects. However, if you have manually mapped the attributes in either of the MDX cubes to other attributes, either in the MDX cube source or in the relational project, the attributes in the two MDX cubes need to be mapped to the same objects to be able to switch between MDX cubes for the report.
The metrics that are included on the template of the MDX cube report must also be available in the MDX cube you are switching to. In addition, you must ensure that the metrics are shared between the two MDX cubes, as described in Sharing metrics between MDX cubes.
To switch the MDX cube for an MDX cube report
- In Developer, log in to a project.
- Browse to an MDX cube report, right-click the report and choose Edit.
- Choose Data > MDX Cube Options > Switch MDX Cube.
-
Navigate to the MDX cube to use as the new source of data for the report.
Only MDX cubes that meet the requirements described in the prerequisites of this procedure are available for selection. If no MDX cubes are available, you cannot switch the MDX cube for the report until you modify the MDX cubes as necessary.
- Select the MDX cube and click Open.