Hierarchy

Analysis Services

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.