Analysis Services
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.