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