Returns a set that is based on the relative position of the specified member in the database outline.
RelMemberRange ( member, prevcount, nextcount, [,layertype] )
member | An input member in the set you want to return. |
prevcount | The number of members in the same layer specified by layertype prior to member to include in the return set. |
nextcount | The number of members in the same layer specified by layertype following member to include in the return set. |
layertype | GENERATION or LEVEL. If omitted, the default is GENERATION. Defines whether the set to be returned is based the same generation or on the same level as member. |
The following examples are based on ASOSamp.Sample.
SELECT RelMemberRange ([PORTLAND - OR],1,2) ON COLUMNS FROM asosamp.sample
This query returns the set:
{[PHOENIX - OR],[PORTLAND - OR],[POWERS - OR],[PRAIRIE CITY - OR]}
RelMemberRange(Apr, 5, 0)
returns the set {Jan, Feb, Mar, Apr}
. Note that the output set has only four members.
RelMemberRange(Apr, 5, 10)
returns the set {Jan, Feb, Mar, Apr, May ...,Dec}
. Note that the output set has only
four previous members and seven next members of Apr.
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |