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.
create an MDX cube report in Web, you need to have Web Professional
privileges, including the Web Define MDX Cube Report privilege.
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.
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
||Log in to the project in which
you want to create a report.
||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.
||From the left, click All
Objects, then navigate to the objects you want to place on
||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).
||Add attributes, metrics, filters,
and prompts to your new report, as follows:
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.
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.
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.
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.
||From the left, click MDX
Objects. A list of available MDX cube sources is displayed.
||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.
||Drag and drop the MDX cube metrics
you want to add to the desired location on the grid.
||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.
||To save your new report, from
the Home menu, select Save. The Save As dialog box opens.
||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.