Syntax

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

or

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:

See Also

RelMemberRange