@PRIOR

The @PRIOR() function 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.

Syntax

@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 from the same dimension. If rangeList is not specified, Hyperion 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   1300

See Also

@NEXT
@SHIFT

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 from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.