MDX Set Specification

An MDX set specification is a collection of tuples. (For now, you can think of tuples as analogous to Essbase member combinations, with no two members from the same dimension.)

In each tuple of a 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.

In other words, each tuple of a set must have the same dimensionality as the other tuples in the set.

<set> ::= 
        MemberRange ( <member>, <member>  )
      | <member> : <member>
      | { [<tuple> | <set>] [, <tuple> | <set>].. }
      | <set_value_expression>

Table 4-8 Ways To Specify an MDX Set

Item	Description
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 Function Return Values.