1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Using Components to Design Business Rules and Templates
  3. DTP Assignment Components
  4. Using Design-Time Prompt Functions in DTP Assignment Components
  5. @IsAncest

@IsAncest

@ISANCEST returns true if the specified ancestor member is an ancestor of the child member.

DTP Type:

@ISANCEST can be assigned to a DTP of type boolean.

Syntax:

@ISANCEST(Ancestor Member/Child Member)

Parameters:

Parameter Description
Ancestor Member Design-time prompt of type member
Child Member Design-time prompt of type member

Example 1:

[True_False]=@ISANCEST([Anc_Mbr],[mbr])

Where:

  • [True_False] is a DTP of type boolean that is not a checked prompt.

  • [Prt_Mbr] is a promptable DTP of type member type.

  • [Mbr] is a promptable DTP of type member type.

Assume the following:

  • The input for [Anc_Mbr] is "Q1".

  • The input for [Mbr1] is "Apr".

In this example, [True_False] returns false.