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_Expression

MDX expression that returns a member.

Level_Expression

MDX expression that specifies the level of the ancestor.

Numeric_Expression

The 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