Creating OLAP cube reports - Microstrategy

OLAP cube reports can be created on Desktop only. Once created, they can be manipulated and executed from the Web as well.

To create an OLAP cube report, you need to be a Desktop Designer with the “Define OLAP cube report” privilege.

Take the following steps to create an OLAP cube report:

  1. On Desktop, select New from the File menu and then select Report. Alternatively, right-click in an empty space in the right panel on Desktop and select Report.
  2. In the New Grid dialog box, select OLAP Cube Report and then click OK. The Select Cube dialog box is displayed.
  3. Select a database instance from the drop-down list for Select OLAP Server.
  4. If cubes have already been imported by an Architect (which is normally the case), they are displayed in their respective catalog structure (a catalog contains an InfoCube and query cubes, if any). If this is the case, click the plus sign (+) next to the catalog name to display itscontent (InfoCube and query cubes), and then select the cube that you want to use for your report.

    You can use the Find dialog box to search for a specific cube that you want to use for your report.

    If you are an Architect with the “Import OLAP Cubes” privilege and if no cubes have been imported, then use the “Retrieve Cubes” option (disabled for those without the privilege) at the bottom of the dialog box to import the cubes from SAP BW.

    You can also use the OLAP Cube Catalog to import cubes, as described in the Importing cubes section.

  5. (Optional) Select the Display technical names check box to show the SAP BW technical names for the cubes.
  6. Click OK to open the Report Editor.
  7. Select attributes and metrics from the Object Browser and put them on the grid.
  8. Create a filter, if needed.
  9. Run the report.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status

Microstrategy Topics