@NEXTS
The @NEXTS calculation function for Essbase returns a cell value at a given next distance from a member name within a range, with options to ignore empty values.
Returns the nth cell value from mbrName, in the sequence XrangeList. Provides the option to skip #MISSING
, zero, or both. Works within a designated range, and retains all other members identical to the current member.
Syntax
@NEXTS (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH mbrName[,n,XrangeList])
Parameters
- SKIPNONE
-
Includes all cells specified in the sequence, regardless of their content.
- SKIPMISSING
-
Ignores all
#MISSING
values in the sequence. - SKIPZERO
-
Ignores all 0 values in the sequence.
- SKIPBOTH
-
Ignores all
#MISSING
and 0 values in the sequence. - mbrName
-
Any valid single member name, or a function that returns a single member.
- n
-
Optional signed integer. Using a negative value for n has the same effect as using the matching positive value in @PRIORS. If you do not specify n, then a default value of 1 is assumed, which returns the next prior member from the lowest level of the dimension set as Time in the database outline.
- XrangeList
-
Optional parameter specifying a sequential range of members. If a range is not specified, Essbase uses the level 0 members from the dimension tagged as Time.
Can be a valid member name, a comma-delimited list of member names, cross dimensional members, or a return value from a member set function or range function (including @XRANGE).
For more information about rangeList and XrangeList, see Range List Parameters.
Example
In this example, Next Cash for each month is derived by taking the Cash value for the following month and ignoring both #MISSING
and zero values. Because n is not specified, the default is 1, which provides the next member in the range. Also, because XrangeList is not specified, the level 0 members from the dimension set as Time are used (Jan,Feb,Mar, ...).
"Next Cash" = @NEXTS(SKIPBOTH, Cash);
The following report illustrates the above example:
Jan Feb Mar Apr May Jun
=== === === === === ===
Cash 1100 #MI 1000 1300 0 1400
Next Cash 1000 1000 1300 1400 1400 #MI
The following example assumes a Year dimension is added to Sample Basic.
FIX(East)
"Next Cash" = @NEXTS(SKIPNONE, Sales, 1, @XRANGE("2011"->"Sep", "2012"->"Mar"));
ENDFIX;
The above calculation is performed across the following multidimensional range specified by XrangeList:
2011->Sep
2011->Oct
2011->Nov
2011->Dec
2012->Jan
2012->Feb
2012->Mar