Returns the nth cell value in the
sequence rangeList from the mbrName.
Provides the option to skip #MISSING, zero, or both #MISSING and
zero values. Works within a designated range and retains all other members
identical to the current member.
@NEXTS (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH mbrName[,n,rangeList])
|SKIPNONE||Includes all cells specified in the rangeList operation,
regardless of their content.
|SKIPMISSING||Ignores all #MISSING values in the rangeList operation.|
|SKIPZERO||Ignores all 0 in the rangeList operation.|
|SKIPBOTH||Ignores all #MISSING and 0 values in the rangeList operation.|
|mbrName||Any valid single member name or member combination, or a function that
returns a single member or member combination.
|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.
|rangeList||Optional. A valid member, 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 set as Time.
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 rangeList 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