Essbase @PRIORS

Returns the nth previous cell member
from mbrName in the rangeList.
@PRIORS provides options to skip #MISSING, zero, or both #MISSING and
zero values. All other dimensions assume the same members as the current member.
@PRIORS works within the designated range.

Syntax

@PRIORS(SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH mbrName[,n, rangeList])
Parameter Description
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 zero values in the rangeList operation.
SKIPBOTH Ignores all #MISSING and zero values in the 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. Using a negative value for n has
the same effect as using the matching positive value in the @NEXTS function. 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.

Example

In this example, Prev Inventory for each month is derived by taking
the Inventory value from the previous month and ignoring #MISSING and
zero values. Because n is not specified,
the default is 1, which provides the next prior member in the range. Also,
because rangeList is not specified, the level 0 members from the dimension
are set as Time used as (Jan,Feb,Mar,…).

"Prev Inventory" = @PRIORS(SKIPBOTH,Inventory);

The following report illustrates this example:

                  Jan      Feb      Mar     Apr     May    Jun
                  ===      ===      ===     ===     ===    ===
 Inventory       1100     #MI     1000     1300      0    1400
 Prev Inventory   #MI    1100     1100     1000   1300    1300

See Also

  • @PRIOR