How to Create 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 Help.

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 How to Create 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.

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 Help.
   • 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 How to Create a Filter within a Report: Embedded Filters. For steps to create a stand-alone filter and then add it to the report, see Introduction to 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.
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 Help.
9. Click the 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.

Related Topics

How to Create a Report

How to Create MDX Cube Reports

How to Create a Report That Accesses an Intelligent Cube

How to Add Objects from the MDX Objects Panel