@DimMember
@DIMMEMBER
returns a member if it is valid for the specified dimension.
DTP Type:
@DIMMEMBER
can be assigned to a DTP of type member, members, cross dimension, member range, dimension, or dimensions.
Syntax:
@DIMMEMBER(Dimension,Member)
Parameters:
Parameter | Description |
---|---|
Dimension |
Design-time prompt or dimension |
Member |
Design-time prompt, member, or function drop-down that shows the list of dimensions in the application from which to select |
Example:
[DIM_mbr1]=@DIMMEMBER([DIM],[Member])
Where:
-
[DIM_mbr1]
is a DTP of type member that is not a checked prompt. -
[DIM]
is a DTP of type dimension that is a checked prompt. -
[Member]
is a DTP of type member that is a checked prompt. -
[Dim]
="Entity" -
[Member]
="Washington"
In this example, [DIM_mbr1]
returns "Washington,"since Washington is a member of the Entity dimension.