Returns the ancestor of a member at specified level or distance.
Syntax
| Code Block |
|---|
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.
...
NOT ([Activity].CurrentMember IS [Activity].DefaultMember) |
...
...
Ancestor([Activity].CurrentMember, [Activity].[Class]).Name |
...
