Hierarchies

There are two kinds of hierarchies in SSAS Multidimensional: user hierarchies and attribute hierarchies. Each attribute creates a single-level hierarchy that can be used in the designer/browser with a combination of other attributes to create a multilevel hierarchy. A user hierarchy is a predefined multilevel hierarchy that provide easier access for the end user in the frontend. One of the most important benefits of hierarchies is the ability to drill down and drill up in many MDX client tools such as Excel and PerformancePoint.