RelMemberRange

Returns a set that is based on the relative position of the specified member in the database outline.

Syntax

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.

Examples

The following examples are based on ASOSamp.Sample.

Example 1

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]}

Example 2

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.

See Also

LastPeriods

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