All eazyBI for Jira eazyBI for Confluence Private eazyBI

Ancestor

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

Syntax

Ancestor(Member_Expression, Level_Expression)
Ancestor(Member_Expression, Numeric_Expression)

Arguments

Member_ExpressionMDX expression that returns a member.
Level_ExpressionMDX expression that specifies the level of the ancestor.
Numeric_ExpressionThe distance between the member and the ancestor.

Examples

The following example returns the issue's epic Epic Status for parent issues and sub-tasks.

CASE WHEN
  NOT ([Issue.Epic].CurrentMember IS [Issue.Epic].DefaultMember)
THEN
  Ancestor(
    [Issue.Epic].CurrentMember, [Issue.Epic].[Epic]
  ).Get('Epic Status')
END