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. @PlanDimMember

@PlanDimMember

@PLANDIMMEMBER returns a member if the member is valid for the specified dimension in the specified plan type.

DTP Type:

@PLANDIMMEMBER can be assigned to a DTP of type member.

Syntax:

@PLANDIMMEMBER(plan type,dimension,member)

Parameters:

Parameter Description
plan type Design-time prompt that returns the type of plan
dimension Design-time prompt that returns the dimension name
member Design-time prompt that returns the member name

Example 1:

[DIM_mbr1]=@ PLANDIMMEMBER("Plan1",[DIM],[Member])

Where:

  • [DIM_mbr1] is a DTP of type member that is not a checked prompt.

  • [DIM] is a DTP of type dimension that is a checked prompt.

  • [Member] is a DTP of type member that is a checked prompt.

  • [Dim]="Entity"

  • [Member]="Washington"