MDX Set Specification

A set is a collection of tuples. In each tuple of the set, members must represent the same dimensions as do the members of other tuples of the set. Additionally, the dimensions must be represented in the same order.

<set> ::= 
        MemberRange ( <member>, <member>  )
      | <member> : <member>
      | { [<tuple> | <set>] [, <tuple> | <set>].. }
      | <set_value_expression>
ItemDescription
MemberRange (<member>, <member>)A set can be a range of members, specified using the MemberRange function.
<member> : <member>Alternate syntax that has the same effect as the MemberRange function.
{[<tuple> | <set>] [, <tuple> | <set>].. }Unless it is returned by a function, a set must be enclosed in curly braces { }. A set can be one or more tuples, or it can be made up of other sets.

All tuples in a set must have the same dimensionality.

<set_value_expression>Output from any function that returns a set. As an alternative to creating sets member-by-member or tuple-by-tuple, you can use a function that returns a set. For a list of functions that return sets, see MDX Functions.