Skip Navigation
Online help
Creating a report

Creating a report
   - Creating a report from scratch
   - Creating a report from a template
   - Creating an OLAP Cube report
Saving a new report without executing it

Creating a report
Reports that display your business data are the focus and goal of business intelligence. Reports allow you to gather business insight through data analysis. The results displayed in any MicroStrategy report are often a starting point for further investigation.

You can create a report in several ways. For example, you can create a report using a pre-existing template that already includes attributes and metrics in the report definition. If you have the necessary report designer privileges, you can create a report entirely from scratch and choose every object that appears on the template.

You can create a report in several ways. For example, you can create a report using a preexisting template that already includes attributes and metrics in the report definition. If you have the necessary report designer privileges, you can create a report entirely from scratch and choose every object that appears on the template.

For more information, see the following:

Creating a report from scratch
You can create a report entirely from scratch by performing the steps below.

Prerequisites

You must have the necessary report designer privileges to create a report from scratch.

To create a report from scratch:

  1. Click Create Report at the top of the page. A page with several report creation choices is displayed. The View report in Design Mode check box is selected by default. Creating a report in Design Mode allows you to make changes to a report's template or filter without viewing the data.
  2. Click Blank Report to create a new report from scratch. Your blank report opens up in Design Mode.
    Note: The 'Blank Report' here is actually a MicroStrategy object that is available in the Public Objects/Object Templates folder, which is a hidden folder. This object is used by MicroStrategy Web to create a new report.
  3. From Design Mode, use the Object Browser to add objects to the report template. For these steps, see Design Mode.
  4. Do one of the following:
    • To cancel the report creation and return to the Create Report page, click Cancel at the top of the page.
    • To save the report before executing it first, answer all the required prompts with your selections and then click Save Report at the top of the page. By default, MicroStrategy Web saves the report in the My Reports folder, but you have the option to save it in a different folder or create a new folder .
    • To execute the report, click Run Report at the top of the page.

You can also create a new report while viewing a report in View mode by selecting New from the File menu.

Creating a report from a template
When you create a report using a template, you are using a report that already contains objects such as attributes and metrics within its report definition. These objects exist in the report's Report Objects list.

To create a report using a template:

  1. Click Create Report at the top of the page. A page with several report creation choices is displayed. The View report in Design Mode check box is selected by default. Creating a report in Design Mode allows you to make changes to a report's template or filter without viewing the data. See Design Mode for more information.
  2. Select from the list of pre-designed reports (for example, Call Center Analysis). The pre-designed reports are displayed with the template icon next to them.
  3. When you select a pre-designed report, you are prompted to choose filter conditions (attribute qualifications, metric qualifications, or attribute elements) and template components (attributes, metrics, or a template) to be used as the new report definition. Many pre-designed reports contain attributes and metrics in the Report Objects panel you can quickly access and use as building blocks for a new report. To execute the report, click Run Report at the top of the page.
  1. Do one of the following:
    • To cancel the report creation and return to the Create Report page, click Cancel at the top of the page.
    • To save the report before executing it first, answer all the required prompts with your selections and then click Save Report at the top of the page. By default, MicroStrategy Web saves the report in the My Reports folder, but you have the option to save it in a different folder or create a new folder .
    • To execute the report, click Run Report at the top of the page.

You can also create a new report while viewing a report in View mode by selecting New from the File menu.

Creating an OLAP Cube report
Many MicroStrategy customers use SAP BW, Microsoft Analysis Services (Analysis Services) 2000 and 2005, or Hyperion Essbase (Essbase) as well as MicroStrategy for their Business Intelligence (BI) needs. The integration between these two products provides great flexibility for users, takes advantage of what each system can offer, and yields the best BI solutions.

In the MicroStrategy environment, SAP BW, Analysis Services, and Essbase are treated as a data warehouse that holds data to be analyzed. To access the data, the Intelligence Server uses MultiDimensional eXpressions (MDX) to access SAP BW, Analysis Services 2000 and 2005, and Essbase as OLAP cube sources.

For information about importing and mapping OLAP cubes, refer to the MicroStrategy Project Design Guide.

Prerequisites

You must have the necessary Web Professional privilege to create a report from a cube source such as MSAS, Hyperion Essbase, or SAP BW.

To create an OLAP cube report:

  1. Click Create Report at the top of the page.
  2. A page with several report creation choices is displayed. The View report in Design Mode check box is selected by default. Creating a report in Design Mode allows you to make changes to a report's template or filter without viewing the data. See Design Mode for more information.
  3. Click Blank OLAP Cube Report to create a new OLAP cube report. A dialog box opens, prompting you to select an OLAP cube.
  4. Browse through the available Data Sources and Catalogs and select an existing OLAP cube on which to build your report.
  5. Click OK.
  6. From the Object Browser on the left, drag objects from the cube source and drop them onto the report template to define your report.
    Note: All created calculated measures are located in the Compound Metrics folder in the Object Browser.
  7. Click Run Report.


Saving a new report without executing it
To save a new report without executing it first, answer all the required prompts with your selections and then click Save Report at the top of the page. By default, MicroStrategy Web saves the report in the My Reports folder, but you have the option to save it in a different folder or create a new folder.

For more information about saving reports, see Saving reports.