@NEXT

The @NEXT() function 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])

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 from the same dimension. If rangeList is not specified, Hyperion 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

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 from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.