MemberRange

Using the order of members existing in a database outline, returns a range of members inclusive of and between two specified members of the same generation or level.

Syntax

MemberRange ( member1, member2 [,layertype] )

OR

member1:member2

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.

Description

This function returns a range of members between two members in the same generation or level.

Notes

Examples

Example 1

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

[Jan] : [Mar]

returns:

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

returns:

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

Example 3

The following query

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

returns the grid:

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

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com