Returns the nth previous cell member
from mbrName in rangeList.
All other dimensions assume the same members as the current member. @PRIOR
works only within the designated range, and with level 0 members.
@PRIOR (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. Using a negative value for n has
the same effect as using the matching positive value in the @NEXT 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 tagged as Time in the database outline.
|rangeList||Optional. A valid member name, 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 tagged as Time.
In this example, Prev Inventory for each month is derived by taking
the Inventory value from the previous month. Since n is
not specified, the default is 1, which provides the next prior member in the
range. Since rangeList is not specified,
the level 0 members from the dimension tagged as Time are used (Jan,Feb,Mar,…).
"Prev Inventory" = @PRIOR(Inventory);
This example produces the following report:
Jan Feb Mar Apr May Jun === === === === === === Inventory 1100 1200 1000 1300 1300 1400 Prev Inventory #MI 1100 1200 1000 1300 1300