You can add metrics from an MDX Cube to a report using the MDX Objects list. The MDX Objects list, 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 list, as follows:
Metrics in the MDX Objects list that are being used on the report are displayed in gray.
Metrics in the MDX Objects list 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 MicroStrategy MDX Cube Reporting Guide.
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 MicroStrategy MDX Cube Reporting Guide.
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 MicroStrategy MDX Cube Reporting Guide.
You must have a MultiSource Option license in order to view and use report objects from the MDX Objects list.
Open the report in Design Mode.
From the left, select MDX Objects. The MDX Objects list is displayed, with a list of MDX cube data sources.
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.
Related topics