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

@DimMember

@DIMMEMBER returns a member if it is valid for the specified dimension.

DTP Type:

@DIMMEMBER can be assigned to a DTP of type member, members, cross dimension, member range, dimension, or dimensions.

Syntax:

@DIMMEMBER(Dimension,Member)

Parameters:

Parameter Description
Dimension Design-time prompt or dimension
Member Design-time prompt, member, or function drop-down that shows the list of dimensions in the application from which to select

Example:

[DIM_mbr1]=@DIMMEMBER([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"

In this example, [DIM_mbr1] returns "Washington,"since Washington is a member of the Entity dimension.