Export (0) Print
Expand All

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

- (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.

Community Additions

ADD
Show:
© 2014 Microsoft