@DimName

@DIMNAME returns the name of a dimension if it is valid for the database.

DTP Type:

@DIMNAME can be assigned to a DTP of type dimension.

Syntax:

@DIMNAME(Dimension)

Parameter:

Parameter Description
Dimension Design-time prompt, dimension, or typed in text.

Click the dimension to display a list of available dimensions.

Example:

[DIMN_Product]=@DIMNAME(["Product"])

Where:

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

  • "Product" is typed in the function.

If "Product" is a valid dimension name for this plan type, then [DIMN_Product] returns "Product".

If "Product" is not a valid dimension for this plan type, then [DIMN_Product] returns "empty".