Range Operator (MDX)

MDX range operator (:).

Description

Returns a set made of the members between the both specified members (specified members included).

Both parameters must specify members within the same level of a given dimension. If the first member is NULL then the first member of the level (as specified by the second member) is used. If the second member is NULL then the last member of the level (as specified by the first member) is used.

Examples

member : member

member : NULL

As the second is member is NULL, the last member of the level is used.

In our example, we're returning all the month of the year 2011.

Query

[Time].[Month].[Jan 2011] : NULL

Result

{ 
  [Time].[Calendar].[Month].[Jan 2011], 
  [Time].[Calendar].[Month].[Feb 2011], 
  [Time].[Calendar].[Month].[Mar 2011], 
  [Time].[Calendar].[Month].[Apr 2011], 
  [Time].[Calendar].[Month].[May 2011], 
  [Time].[Calendar].[Month].[Jun 2011], 
  [Time].[Calendar].[Month].[Jul 2011], 
  [Time].[Calendar].[Month].[Aug 2011], 
  [Time].[Calendar].[Month].[Sep 2011], 
  [Time].[Calendar].[Month].[Oct 2011], 
  [Time].[Calendar].[Month].[Nov 2011], 
  [Time].[Calendar].[Month].[Dec 2011]
}

Assertion : Cell Equals

{
[Time].[Month].[Jan 2011],
[Time].[Month].[Feb 2011],
[Time].[Month].[Mar 2011],
[Time].[Month].[Apr 2011],
[Time].[Month].[May 2011],
[Time].[Month].[Jun 2011],
[Time].[Month].[Jul 2011],
[Time].[Month].[Aug 2011],
[Time].[Month].[Sep 2011],
[Time].[Month].[Oct 2011],
[Time].[Month].[Nov 2011],
[Time].[Month].[Dec 2011]
}

NULL : member

As the first is member is NULL, the first member of the level is used.

In our example, we're returning all the month of the year 2010.

Query

NULL : [Time].[Month].[Dec 2010]

Result

{ 
  [Time].[Calendar].[Month].[Jan 2010], 
  [Time].[Calendar].[Month].[Feb 2010], 
  [Time].[Calendar].[Month].[Mar 2010], 
  [Time].[Calendar].[Month].[Apr 2010], 
  [Time].[Calendar].[Month].[May 2010], 
  [Time].[Calendar].[Month].[Jun 2010], 
  [Time].[Calendar].[Month].[Jul 2010], 
  [Time].[Calendar].[Month].[Aug 2010], 
  [Time].[Calendar].[Month].[Sep 2010], 
  [Time].[Calendar].[Month].[Oct 2010], 
  [Time].[Calendar].[Month].[Nov 2010], 
  [Time].[Calendar].[Month].[Dec 2010]
}

Assertion : Cell Equals

{
[Time].[Month].[Jan 2010],
[Time].[Month].[Feb 2010],
[Time].[Month].[Mar 2010],
[Time].[Month].[Apr 2010],
[Time].[Month].[May 2010],
[Time].[Month].[Jun 2010],
[Time].[Month].[Jul 2010],
[Time].[Month].[Aug 2010],
[Time].[Month].[Sep 2010],
[Time].[Month].[Oct 2010],
[Time].[Month].[Nov 2010],
[Time].[Month].[Dec 2010]
}

Special Examples (errors, null, ...)

member(level1) : member(level2)

member : same member

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.