@DenseMember

@DENSEMEMBER returns the first dense dimension member in a cross dimension.

DTP Type:

@DENSEMEMBER can be assigned to a DTP of type member, members, dimension, dimensions, member range, cross dimension, or string.

Syntax:

@DENSEMEMBER(Members)

Parameter:

Parameter	Description
Members	Design-time prompt, member, or function that returns a cross dimension or member range

Example:

[DenseMbr]=@DENSEMEMBER([CD1])

Where:

• [DenseMbr] is a DTP of type cross dimension that is not a checked prompt.

• [CD1] is a DTP of type cross dimension that is promptable.

• [CD1]="Salaries"->"Jan"->"Working"->"Tennessee"->"G401"

In this example, [Densembr] returns "Salaries", since "Salaries" is the first dense member in the cross dimension list.