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