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.
@PRIORS(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 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, Analytic Services uses the level 0 members from the dimension set as Time. |
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
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |