MemberRange

Using the order of members existing in an Essbase database outline, the MDX MemberRange function returns a range of members inclusive of and between two members in the same generation or level.

Syntax

MemberRange ( member1, member2 [,layertype] [, hierarchy ] )

member1:member2

Parameters

member1: The beginning point of the member range.
member2: The endpoint of the member range.
layertype: GENERATION or LEVEL. Available only with function-style MemberRange() syntax. If omitted or if operator-style member:member syntax is used, the range of members returned is inclusive of and between two specified members of the same generation. If MemberRange(member, member, LEVEL) is used, the range of members returned is inclusive of and between two specified members of the same level.
hierarchy: Optional. A specific hierarchy within the time dimension.

Notes

If the two input members are not from the same generation or level, the result is an empty set.
If the two input members are not from the same dimension, an error is returned.
The order of the output resembles the order of the input. See Example 2.
If the hierarchy argument is passed, member1 and member2 should belong to the same hierarchy. Otherwise, an empty set is returned.
When multiple hierarchies are enabled, this function returns NULL when the range begins in one hierarchy and terminates in another hierarchy.

Example

Example 1 (MemberRange)

The following set:

{ [Year].[Qtr1], [Year].[Qtr2], [Year].[Qtr3], [Year].[Qtr4] }

is returned by both of the following examples:

MemberRange ( [Year].[Qtr1], [Year].[Qtr4] )

( [Year].[Qtr1] : [Year].[Qtr4] )

Example 2 (MemberRange)

[Jan] : [Mar]

returns:

{ [Jan], [Feb], [Mar] }

[Mar] : [Jan]

returns:

{ [Mar], [Feb], [Jan] }

Example 3 (MemberRange)

The following query

SELECT
 {[Measures].[Sales], [Measures].[Profit]}
ON COLUMNS,
 MemberRange([Year].[Feb], [Year].[Nov])
ON ROWS
FROM Sample.Basic

returns the grid:

Table 4-112 Output Grid from MDX Example

(axis)	Sales	Profit
Feb	32069	8346
Mar	32213	8333
Apr	32917	8644
May	33674	8929
Jun	35088	9534
Jul	36134	9878
Aug	36008	9545
Sep	33073	8489
Oct	32828	8653
Nov	31971	8367