@Member

@MEMBER returns a member, as long as it is a valid member.

DTP Type:

@MEMBER can be assigned to a DTP of type member.

Syntax:

@MEMBER(Member)

Parameter:

Parameter	Description
Member	Design-time prompt, member, or another design-time prompt function

Example:

[Mbr_mr1]=@UNION([MR1],@MEMBER([Member]))

Where:

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

• [@UNION] creates the range of the DTP, MR1, and DTP Member as long as the member entered is a valid member.

• [MR1] is a DTP of type member range that is a checked prompt.

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

Assume that the following values are input:

• [MR1]: Account "Salaries", Scenario "Actual", Entity "Tennessee"

• [Member]: "000", which is a member from the product dimension

In this example, [Mbr_mr1] returns "Salaries","Actual","Tennessee","000"