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