@RELATIVE

Returns all members at the specified generation or level that are above or below the specified member in the database outline.

Syntax

@RELATIVE (mbrName, genLevNum | genLevName)
Parameter Description

mbrName

Any valid single member name or member combination, or a function that returns a single member or member combination.

genLevNum

An integer value that defines the number of a generation or level. A positive integer defines a generation number. A value of 0 or a negative integer defines a level number.

genLevName

Generation or level name specification.

Notes

This function returns all members at the specified generation or level that are above or below the specified member in the database outline.

Essbase sorts the generated list of members in ascending order. Using Sample Basic as an example, @RELATIVE(200,0), returns 200-10, 200-20, 200-30, 200-40 (in that order). This order is important to consider when you use the @RELATIVE member set function with certain forecasting and statistical functions.

Example

In the Sample Basic database:

@RELATIVE(Qtr1,3)
@RELATIVE(Qtr1,0)

both return the three members that are at generation 3 (or level 0) and that are below Qtr1 in the Sample Basic outline: Jan, Feb, and Mar (in that order).

@RELATIVE(Profit,-1)

returns the two members that are at level 1 and that are below Profit: Margin and Total Expenses (in that order).