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.

Prerequisites

  • To be able to switch to a different MDX cube, the following conditions need to be met:

  • The attributes that are included on the template of the MDX cube report must also be available in the MDX cube that you are switching to. If the MDX cubes are from the same MDX source, then the attributes are shared between the MDX cubes by default. For additional details on the default behavior of sharing attributes between related MDX cubes, see the MDX Cube Reporting Help.

    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 Shared MDX Cube Objects.

To switch the MDX cube for an MDX cube report

  1. In MicroStrategy Developer, log in to a project.

  2. Browse to an MDX cube report, right-click the report, and select Edit. The MDX cube report is opened in the Report Editor.

  3. From the Data menu, point to MDX Cube Options, and select Switch MDX Cube. The Select Destination Object dialog box opens.

  4. Navigate to the MDX cube that is to act 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.

  5. Select the MDX cube and click Open. The process of switching the report to the new MDX cube is started, and once complete, you are returned to the Report Editor.

You can continue to report on the data, and include objects on the report from the new MDX cube that is connected to the report.