@DimUDA

@DIMUDA returns the UDA name if the specified UDA is valid for the dimension.

DTP Type:

@DIMUDA can be assigned to a DTP of type UDA, Member, Dimension, or String.

Syntax:

@UDA(Dimension,UDA)

Parameters:

Parameter	Description
Dimension	Design-time prompt or dimension Click the dimension to display a list of available dimensions.
UDA	If you select a DTP or UDA in the Dimension parameter, then select a UDA from the drop-down list.

Example:

[dimu_mbr2]=@DIMUDA([DIM],[UDA2] [dimu_mbr]=@DIMUDA([DIM],[UDA]

Where:

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

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

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

• [UDA2] is a DTP of type UDA that is a checked prompt.

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

Assume that the following values are input:

• [dim]: "Account"

• [UDA2]: "HSP_LEAPYEAR"

• [UDA]: "Revenue"

In this example, [dimu_mbr2] returns nothing, since "HSP_LEAPYEAR" is not a UDA on "Account," and [dimu_mbr] returns "Revenue."