How to Add Objects from the MDX Objects Panel

You can add metrics from an MDX Cube to a report using the MDX Objects panel. The MDX Objects panel, which is a part of the Object Browser, displays a list of all the MDX cube sources to which you have access to. Metrics within an MDX cube are displayed in the MDX Objects panel, as follows:

Metrics in the MDX Objects panel that are being used on the report are displayed in gray.
Metrics in the MDX Objects panel that are not currently being used on the report are displayed in black.

For a detailed explanation of MDX cube sources, including steps to connect to an MDX cube source and integrate MDX cubes into MicroStrategy, see the MDX Cube Reporting Help

To create an MDX cube report in Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report privilege.

At least one MDX cube must be imported into your MicroStrategy project. Importing MDX cubes is often handled by a MicroStrategy architect. For more information on importing MDX cubes into MicroStrategy, see the MDX Cube Reporting Help.

To include MDX cube data in standard reports, you must map MDX cube columns for each project attribute you plan to include in the reports. For example, if a report includes the project attributes Year, Region, and Category, you must map MDX cube columns to these three attributes. For steps to map MDX cube columns to project attributes, see the MDX Cube Reporting Help.

To Add an Object Displayed in the MDX Objects Panel to a Report

Open the report in Design Mode.
From the left, select MDX Objects.
Click on the links for the MDX cube sources to navigate to an MDX cube. Within an MDX cube, click on the Metrics folder to view the metrics for an MDX cube.
Drag and drop the MDX cube metrics you want to add to the desired location on the grid.

How to Add Objects from the MDX Objects Panel

To Add an Object Displayed in the MDX Objects Panel to a Report

Related Topics