+ (Union) (MDX)
Performs a set operation that returns a union of two sets, removing duplicate members.
Syntax
Set_Expression + Set_Expression
Parameters
- Set_Expression
A valid Multidimensional Expressions (MDX) expression that returns a set.
Return Value
A set that contains the members of both specified sets.
Remarks
The + (Union) operator is functionally equivalent to the Union (MDX) function.
Examples
The following example demonstrates the use of this operator.
-- This member returns the gross profit margin for each year for North American regions.
SELECT
[Date].[Calendar].[Calendar Year].Members ON 0,
[Sales Territory].[Sales Territory].[Country].[United States].Children +
[Sales Territory].[Sales Territory].[Country].[Canada].Children ON 1
FROM
[Adventure Works]
WHERE
([Measures].[Gross Profit Margin])