Introduction to MDX - Professional SQL Server Analysis Services 2005 with MDX - page 119

(Male,2005),(Female,2003),(Female,2004),(Female,2005)} the comma char-
acter is not only used to form tuples but also to form the set of tuples.
The colon character is used to define a range of members within a set. The
members within a set are ordered based on the key or the name of the mem-
ber, whichever is specified while creating the set. The colon character is used
between two non-consecutive members in a set to indicate inclusion of all the
members between them, based on the ordering. For example, if you have the
following set
{[Customer].[Country].[Australia],
[Customer].[Country].[Canada],
[Customer].[Country].[France],
[Customer].[Country].[Germany],
[Customer].[Country].[United Kingdom],
[Customer].[Country].[United States]}
The following MDX expression
{[Customer].[Country].[Canada] :
[Customer].[Country].[United Kingdom]}
results in the following set
{[Customer].[Country].[Canada],
[Customer].[Country].[France],
[Customer].[Country].[Germany],
[Customer].[Country].[United Kingdom]}