Returns the nth cell value in the
sequence rangeList from mbrName,
retaining all other members identical to the current member. @NEXT cannot
operate outside the given range.
@NEXT (mbrName [, n, rangeList])
|mbrName||Any valid single member name or member combination, or a function that
returns a single member or member combination.
|n||Optional signed integer. If you do not specify n,
then the default is set to 1, which provides the next member in the range.
Using a negative value for n has the same
effect as using the matching positive value in the @PRIOR function.
|rangeList||Optional. A valid member name, a comma-delimited list of member names,
member set functions, and range functions. If rangeList is
not specified, Essbase uses the level 0 members from
the dimension tagged as Time.
In this example, Next Cash for each month is derived by taking the Cash
value for the following month. Since n is
not specified, the default is 1, which provides the next member in the range.
Since rangeList is not specified, the level
0 members from the dimension tagged as Time are used (Jan,Feb,Mar, …).
"Next Cash" = @NEXT(Cash);
This example produces the following report:
Jan Feb Mar Apr May Jun === === === === === === Cash 100 90 120 110 150 100 Next Cash 90 120 110 150 100 #MI