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.
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.
|
This function returns a range of members between two members in the same generation or level.
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] )
[Jan] : [Mar]
returns:
{ [Jan], [Feb], [Mar] }
[Mar] : [Jan]
returns:
{ [Mar], [Feb], [Jan] }
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 |