Share via

Set Operators

  • Article

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

Reference

MDX Function Reference (MDX)

MDX Operator Reference (MDX)

Concepts

Operators (MDX Syntax)