Creating MDX cube reports
Many companies have stored data that is specifically structured for
query, reporting, and analysis, known as a data warehouse, and they also
have data stored in an MDX cube source such as SAP Business Intelligence
Warehouse (SAP BW), Microsoft® Analysis Services (Analysis Services),
or Hyperion® Essbase®. MicroStrategy's Intelligence Server uses MultiDimensional
eXpressions (MDX) to concurrently access both the MDX cube source and
the data warehouse effectively. For complete details on how MicroStrategy
interacts with these 3rd party data sources, see the MDX Cube Reporting Guide.
The procedure below shows you how to create an MDX cube report, which
is a standard MicroStrategy report that draws its data from one of the
data sources described above.
||After you create an MDX
cube report using your SAP BW data, you can treat the MDX cube report
the same as standard MicroStrategy reports. This means that you can use
the MDX cube reports as datasets in Report Services documents.
create a report from a cube source such as Analysis Services, Essbase,
or SAP BW, you must have the Web
Professional privilege called Web Define MDX Cube Reports. If you
are an administrator, see the System Administration Guide
for details on privileges and how to assign them to users.
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 create an MDX cube report
||Log in to a project connected
to an MDX cube source.
||Click Create on any page, point to New Report, and select MDX Cube
Report. The Select MDX Cube dialog box opens.
||Click an MDX cube source. Catalogs
available for the MDX cube source are displayed.
||Click a catalog. MDX cubes available
in the catalog are displayed.
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. Some MicroStrategy objects on
MDX cube reports work differently than on standard MicroStrategy reports,
as described in the MDX Cube Reporting Guide.
Report. The report is executed and displayed in the view selected.
||Format the report, if needed.
||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.