Essbase @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).