Export (0) Print
Expand All

+ (Union) (MDX)

Performs a set operation that returns a union of two sets, removing duplicate members.


Set_Expression + Set_Expression    

Set_Expression

A valid Multidimensional Expressions (MDX) expression that returns a set.

A set that contains the members of both specified sets.

The + (Union) operator is functionally equivalent to the Union (MDX) function.

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])

Community Additions

ADD
Show:
© 2014 Microsoft