MicroStrategy ONE

Using hierarchies on MDX cube reports

You can include hierarchies of an MDX cube on the template of an MDX cube report. Templates define the columns of data and data formatting displayed on reports and MDX cube reports. Hierarchies can be added to report templates using the same techniques to add attributes to a report template. At report run-time, any hierarchies included on an MDX cube report display the attributes that are part of that hierarchy.

For examples and an explanation of how attributes are displayed for hierarchies in MDX cube reports, see the MDX Cube Reporting Help.

Be aware of the following when using hierarchies on MDX cube reports:

  • Only the default report display forms for each attribute are shown when attributes are displayed as part of a hierarchy on a report. To modify the attribute forms that are displayed for each attribute when displayed as part of a hierarchy, you must modify the report display forms for the attributes using the Attribute Editor. For details on defining report display forms, see the Project Design Help.

  • Attributes displayed as part of a hierarchy on a report act as one unit on the grid or graph. This means that all attributes displayed as a hierarchy are pivoted or moved together. However, you can sort each attribute of a hierarchy individually by using the advanced sorting options for a report.

  • Hierarchies must display attributes sequentially from the highest level attribute down to the lowest level defined for the hierarchy. This means that to see the lowest level attribute for a hierarchy displayed on the report, the hierarchy must display every attribute for the hierarchy. To see lower level attributes in the hierarchy without displaying the higher level attributes, add the attributes to the report one-by-one rather than including the hierarchy on the report.

  • In SAP BW systems, dimensions can include multiple hierarchies for data display purposes. In MicroStrategy, only one hierarchy per dimension can be represented on an MDX cube report. Refer to the MDX Cube Reporting Help for further explanation of this requirement.

  • You can drill on hierarchies included on your MDX cube reports using most of the standard techniques available for drilling on attributes on reports. For more information and best practices on drilling on hierarchies, see Drilling on hierarchies on MDX cube reports.