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