DIMENSION
Hierarchy
Description
This function is used to return the hierarchy that contains a specified member, level, or hierarchy.
Syntax
Hierarchy_Expression.Dimension
Member_Expression.Dimension
Level_Expression.Dimension
Return Type
HIERARCHY
Parameters
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression that returns a hierarchy. |
Member_Expression | It is a valid MDX expression that returns a member. |
Level_Expression | It is a valid MDX expression that returns a level. |
Example
Hierarchy_Expression
WITH member measures.x as [Product].[Product Model Lines].Dimension.Name
SELECT measures.x on 0
FROM [AdventureWorksMF] Member_Expression
WITH member measures.x as [Product].[Product Model Lines].[Model].&[HL Road Tire].Dimension.Name
SELECT measures.x on 0
FROM [AdventureWorksMF]Level_Expression
WITH member measures.x as [Product].[Product Model Lines].[Model].Dimension.Name
SELECT measures.x on 0
FROM [AdventureWorksMF]