@Union
@UNION
returns the combination of members used in multiple design-time prompts.
DTP Type:
@UNION
can be assigned to a DTP of type member range or cross dimension.
Syntax:
@UNION(Argument1,Argument2)
Parameters:
Parameter | Description |
---|---|
Argument1 |
Design-time prompt, function, or members |
Argument2 |
Design-time prompt, function, or members |
Example:
[UnionMR]=@UNION([MR1],[MR2])
Where:
-
[UnionMR]
is a DTP of type member range that is not a checked prompt. -
[MR1]
is a DTP of type member range that is a checked prompt. -
[MR2]
is a DTP of type member range that is a checked prompt.
Assume that the input for MR1
and MR2
is:
-
[MR1]
: "50350",@Relative("Q1", 0),"California","Tennessee" -
[MR2]
: "Apr","Washington", "Tennessee"
In this example, UnionMR
returns:
"50350",@Relative ("Q1", 0),"Apr","California","Tennessee","Washington"