@SparseMember

@SPARSEMEMBER returns the first sparse dimension member in a cross dimension.

DTP Type:

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

Syntax:

@SPARSEMEMBER(Members)

Parameter:

Parameter	Description
Members	Design-time prompt, member, or function that returns a list of members

Example:

[SparseMbr]=@SPARSEMEMBER([CD1])

Where:

• [SparseMbr] 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] is "Gross Sales"->"Jan"->"FY14"->"Working"->"California"

In this example, [Sparsembr] returns "FY14", since FY14 is the first sparse member in the cross dimension list.