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