Creating a report using both project and MDX cube data

You can create reports that use both attributes, metrics, and other report objects from a MicroStrategy project, and metrics from an MDX cube.

An MDX cube is a set of data retrieved from an MDX cube source. MDX cube sources can be imported into MicroStrategy and mapped to various objects to allow queries, reporting, and analysis on the data. For a detailed explanation of MDX cubes, including steps to connect to an MDX cube source and integrate MDX cubes into MicroStrategy, see the MDX Cube Reporting Guide.

Prerequisites

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 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 MDX Cube Reporting Guide.

To create a report using both report objects from a MicroStrategy project and MDX cube data

1 Log in to the project in which you want to create a report.
2 Click Create on any page, point to New Report, and select Blank Report.

You can also select an existing template on which to build your new report. For steps to use an existing template to create a new report, see Creating a report based on an existing template.

3 From the left, click All Objects, then navigate to the objects you want to place on the report.
* The location in which you begin browsing for objects is defined in the Report Options dialog box in MicroStrategy Developer. For more information on the Report Options dialog box, see the MicroStrategy Developer help (formerly the MicroStrategy Desktop help).
4 Add attributes, metrics, filters, and prompts to your new report, as follows:
To add an attribute to the report, drag and drop the attribute from the All Objects pane onto the report. Attributes are generally placed on the rows of a report. The attribute must be mapped to data for the MDX cube you plan to report on. For steps to map MDX cube columns to project attributes, see the MDX Cube Reporting Guide.
To add a metric to the report, drag and drop the metric from the All Objects pane onto the report. Metrics are generally placed on the columns of a report.
A filter screens data in your data source to determine whether the data should be included in or excluded from the calculations of the report results. You can create and add a stand-alone filter to a report, or create a filter directly in the report. For steps to create a filter directly within the report, see Creating a filter within a report: Embedded filters. For steps to create a stand-alone filter and then add it to the report, see About filters to determine the type of filter to create and links to steps for creating your filter.
A prompt is a question the system presents to a user when a report is executed. You can add a prompt to a report to determine what data is displayed on the report based on how the user answers the question. To add a prompt to the report, drag and drop the prompt from the All Objects pane onto the report. You need to know what the type of prompt when deciding where and how to add it to a report. For example, Object prompts are most commonly placed directly on a report, but can also be placed in the condition part of a metric's definition in the Metric Editor, depending on the type of object in the Object prompt. For a table listing where to place different types of prompts, see Adding a prompt to a report.
5 From the left, click MDX Objects. A list of available MDX cube sources is displayed.
6 Click on the links for the MDX cube sources to navigate to an MDX cube, then click the Metrics folder to view the metrics for an MDX cube.
7 Drag and drop the MDX cube metrics you want to add to the desired location on the grid.
8 Format the report as desired. For steps to format a report, see the Advanced Reporting Guide.
9 Click the Run Report icon Run Report icon at the top of the page. You can view the report in Grid, Graph, or Grid and Graph view. If you want to move objects or format the report differently, return to Design Mode and make your changes.
10 To save your new report, from the Home menu, select Save. The Save As dialog box opens.
11 Navigate to the location in which you want to save your report, then type a name and description for the report in the Name and Description fields and click OK. Your report is saved.

Related topics

Creating a report
Creating MDX cube reports
Creating a report that accesses an Intelligent Cube
Adding objects from the MDX Objects list