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