MicroStrategy ONE
Creating an MDX cube report
You can create an MDX cube report using an imported MDX cube as the data source. MDX cube reports can be created in either MicroStrategy Developer or Web.
The steps below show how to create an MDX cube report that reports directly on an MDX cube. You also have the following alternatives for creating reports on MDX cube data:
-
If you have an OLAP Services license, you can report on MDX cubes by creating Intelligent Cube reports that connect to Intelligent Cubes containing MDX cube data. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes.
-
If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. For steps to create a report with these analysis capabilities, see Including MDX cube data in standard reports.
Prerequisites:
-
To create an MDX cube report in MicroStrategy Developer, you need to have Developer Designer privileges, including the Define MDX Cube Report privilege.
-
To create an MDX cube report in MicroStrategy 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 project designer. For more information on importing MDX cubes into MicroStrategy, see Importing MDX cubes in the MDX Cube Reporting Help .
-
You should have some experience and knowledge of designing MicroStrategy reports, as described in the Basic Reporting Help and the Advanced Reporting Help.
To create an MDX cube report
-
In MicroStrategy Developer, from the File menu, point to New, and then select Report. The New Grid dialog box opens.
-
On the MDX Sources tab, select a database instance connected to an MDX cube source and click OK. The Select Cube dialog box opens.
-
Select the MDX cube to report and analyze data on in one of the following ways, depending on whether the MDX cube has already been imported or not:
-
If MDX cubes have already been imported by an architect, they are displayed in their respective catalog structures. Click the plus sign (+) next to the catalog name to display its contents, and then select the imported cube to use for your report.
-
If the MDX cube that you want to report on has not been imported yet, click Retrieve cubes. Select the MDX cube from the list of MDX cubes from the selected database instance. If you select an MDX cube that has not been imported yet, it is imported into MicroStrategy before the report is created. You must have the "Import MDX Cube" privilege to perform this action.
-
You can later switch the MDX cube for your report if necessary, as described in Switching the MDX cube for an MDX cube report.
You can also use the Find dialog box to search for a specific MDX cube to use for your report.
-
-
Click OK to open the Report Editor.
-
Select attributes, metrics, prompts, hierarchies, and other objects as required from the Object Browser and put them on the report template, as for a standard report. Some MicroStrategy objects on MDX cube reports work differently than on standard MicroStrategy reports, as described in the sections listed below:
-
Create a filter, if needed. Filters on MDX cube reports work differently than on standard MicroStrategy reports, as described in Using filters in MDX cube reports.
-
From the Data menu, select Run Report. The report is executed and displayed in the view selected.
From the View menu, you can change the view to Grid View, Graph View, Grid Graph View, or MDX View.
-
Format the report, if needed.
If you have an OLAP Services license you can use OLAP Services features such as view filters, derived metrics, and dynamic aggregation. If you are using MicroStrategy Web to create and view the MDX cube report, you can also use the OLAP Services feature derived elements to analyze the data. -
From the toolbar, select Save and close to save the report and close the Report Editor.