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