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.
Syntax
@PRIOR (mbrName [, n, rangeList])
| Parameter | Description |
|---|---|
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. |
Example
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 1300See Also