Returns all members at the specified generation or level that are above or below the specified member in the database outline.
@RELATIVE (mbrName, genLevNum | genLevName)
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. |
This function returns all members at the specified generation or level that are above or below the specified member in the database outline.
Analytic Services 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.
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).
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |