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