Returns the ancestor of a member at specified level or distance.
Syntax
Ancestor(<Member_Expression>,<Level>)
Ancestor(<Member_Expression>,<Numeric_Expression>)
Arguments
|
Member_Expression |
MDX expression that returns a member. |
|---|---|
|
Level |
MDX expression specifying a member level of the ancestor. |
|
Numeric_Expression |
A number to specify a distance between the member and the ancestor. |
Examples
Following example returns Activity class name for Activities and Activity Types.
CASE WHEN
NOT ([Activity].CurrentMember IS [Activity].DefaultMember)
THEN
Ancestor([Activity].CurrentMember, [Activity].[Class]).Name
END