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 MicroStrategy 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.
Note: 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.
Prerequisites
You must have a Web Professional license and the Web Define MDX Cube Reports Web Professional privilege to create a report from a cube source such as Analysis Services, Essbase, or SAP BW. If you are an administrator, see the MicroStrategy System Administration Guide for details on privileges and how to assign them to users.
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 MicroStrategy MDX Cube Reporting Guide.
Log in to a project connected to an MDX cube source.
Click Create Report at the top of the page.
Underneath Choose data source, click 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.
Select an MDX cube.
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. Some MicroStrategy objects on MDX cube reports work differently than on standard MicroStrategy reports, as described in the MDX Cube Reporting Guide.
Click Run Report. The report is executed and displayed in the view selected.
Format the report, if needed.
Click Save As on the toolbar to save the report and close the Report Editor.
Related topics