Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Hierarchy

SQL Server 2000

Hierarchy

Returns the hierarchy that contains a specified member or level.

Syntax
Member

«Member».Hierarchy

Returns the hierarchy that contains «Member».

Level

«Level».Hierarchy

Returns the hierarchy that contains «Level».

Example
Member
[January].Hierarchy

This example returns Time.FiscalYear.

Level
[Quarter].Hierarchy

This example returns Time.FiscalYear.

Show:
© 2015 Microsoft