This topic has not yet been rated - Rate this topic

+ (Union) (MDX)

SQL Server 2005

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


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

Reference

MDX Operator Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD