Introduction to Hierarchy Reporting

Hierarchy reports allow users to present data in a hierarchical structure within a grid. Both balanced and unbalanced hierarchies may be represented in a hierarchy report, although unbalanced hierarchies benefit the most from hierarchy reporting features. Users can also filter and sort hierarchies.

MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. A normal attribute represents a single hierarchy level (for example, Month). A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). A hierarchical attribute can be placed on a grid, filtered, and sorted, much like a normal attribute. If a hierarchy is imported as a single hierarchical attribute, then the entire hierarchy can be placed on a report at once, and operations like filtering and sorting can be performed respecting the hierarchy. If a hierarchy is imported as multiple normal attributes to represent each hierarchy level, then each level can be placed on a report separately, and filters can be created based on specific levels.

Supported Data Sources

Many data sources support hierarchy reporting, including the following:

  • Microsoft Analysis Services
  • Oracle Essbase
  • SAP NetWeaver BW
  • IBM Cognos TM1

The following areas of Workstation do not support hierarchy reporting:

  • Multiple datasets for one dossier
  • Replacing datasets in a dossier
  • Downloading a dossier
  • Drilling on attributes
  • Calculation on attributes
  • Creating advanced filters on the Advanced Filter Editor

Related Topics

How to Import Hierarchical Attributes

How to Expand and Collapse a Hierarchy

How to Sort Hierarchy Reports

How to Create a Hierarchical Attribute Filter for a Chapter

How to Create a Hierarchical Attribute Filter for a Visualization

How to Group Hierarchical Attribute Elements

How to Create Derived Metrics in Hierarchy Reports Using MDX Expressions

How to Create Calculated Members in Hierarchy Reports Using MDX Expressions

How to Set User-Defined Calculation Order and Formatting for a Calculated Member

How to Create a Threshold on a Hierarchical Attribute

How to Create Multiple Hierarchical Attribute Element Groups