Share via

Create User-Defined Hierarchies

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 (SSDT). 

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.


For more information about performance issues related to the design and configuration of user-defined hierarchies, see the SQL Server 2005 Analysis Services Performance Guide.

See Also


User Hierarchy Properties

Level Properties

Parent-Child Dimensions