Set Operators
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 |
|---|---|
Returns the difference between two sets, removing duplicate members. This operator is functionally equivalent to the Except function. |
|
Returns the cross product of two sets. This operator is functionally equivalent to the Crossjoin function. |
|
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. |
|
Returns a union of two sets, excluding duplicate members. This operator is functionally equivalent to the Union (MDX) function. |