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