Essbase @NEXT

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.

Syntax

@NEXT (mbrName [, n, rangeList])
Parameter Description
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.

Example

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

See Also

  • @PRIOR
  • @SHIFT
  • @SHIFTMINUS
  • @SHIFTPLUS