Document toolboxDocument toolbox

Ancestor

Owned by Gvido
Last updated: Aug 03, 2022

Returns the ancestor of a member at specified level or distance.

Syntax

Ancestor(<Member_Expression>,<Level>)
Ancestor(<Member_Expression>,<Numeric_Expression>)

Arguments


Member_ExpressionMDX expression that returns a member.
LevelMDX expression specifying a member level of the ancestor.
Numeric_ExpressionA 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