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

@Plandim

@PLANDIM returns the dimension name if it exists in the database of an application.

DTP Type:

@PLANDIM can be assigned to a DTP of type member or dimension. @PLANDIM works if only one value is used for the second parameter

Syntax:

@PLANDMIN(Database Name,Dimension)

Parameters:

Parameter Description
Database Name Design-time prompt or text
Dimension Design-time prompt, dimension, or text

Example:

[PDIM_mbr]=@PLANDIM([PlTy],[Dim])

Where:

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

  • [PlTy] is a DTP of type string that is a checked prompt.

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

Assume that the following values are input:

  • [PlTy]: "Plan1"

  • Dim: "Product"

In this example, [PDIM_mbr] returns "Product," because Product is a valid dimension in "Plan1".