Export (0) Print
Expand All

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.

Note Note

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft