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:
© 2014 Microsoft