Set Operators

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

In Multidimensional Expressions (MDX), set operators perform operations on members or sets, and return a set. You often use set operators as an alternate to several set functions in MDX expressions.

MDX supports the set operators listed in the following table.

Operator Description
- (Except) Returns the difference between two sets, removing duplicate members.

This operator is functionally equivalent to the Except function.
* (Crossjoin) Returns the cross product of two sets.

This operator is functionally equivalent to the Crossjoin function.
: (Range) Returns a naturally ordered set, with the two specified members as endpoints and all members between the two specified members included as members of the set.
+ (Union) Returns a union of two sets, excluding duplicate members.

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

See Also

MDX Function Reference (MDX)
MDX Operator Reference (MDX)
Operators (MDX Syntax)