User-Defined Hierarchies - Create

Applies to: SQL Server Analysis Services Azure Analysis Services Power BI Premium

SQL Server Analysis Services lets you create user-defined hierarchies. A hierarchy is a collection of levels based on attributes. For example, a time hierarchy might contain the Year, Quarter, Month, Week, and Day levels. In some hierarchies, each member attribute uniquely implies the member attribute above it. This is sometimes referred to as a natural hierarchy. A hierarchy can be used by end users to browse cube data. Define hierarchies by using the Hierarchies pane of Dimension Designer in SQL Server Data Tools.

When you create a user-defined hierarchy, the hierarchy might become ragged. A ragged hierarchy is where the logical parent member of at least one member is not in the level immediately above the member. If you have a ragged hierarchy, there are settings that control whether the missing members are visible and how to display the missing members. For more information, see Ragged Hierarchies.

See Also

User Hierarchy Properties
Level Properties - user hierarchies
Parent-Child Dimensions