Returns either the prior or next nth cell value in the sequence rangeList from mbrName, retaining all other members identical to the current member.
The direction of @SHIFT is wholly based on n, with positive n values producing an effect equivalent to @NEXT and negative values of n producing an equivalent effect to @PRIOR.
Syntax
@SHIFT (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 a positive value in the @PRIOR function. n must be a numeric value, not a reference, such as a member name. |
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. |
Notes
@SHIFT is provided as a more appropriate, self-documenting name than @NEXT or @PRIOR when the value for n is a variable and may change from positive to negative, depending on the database state when the call occurs (that is, when the usage is likely to be NEXT and/or PRIOR).
Example
In this example, Prev Asset for each month is derived by taking the Asset value from the previous month because -1 is specified as the n parameter. Next Avl Asset for each month is derived by taking the Asset value from two months following the current month because 2 is specified as the n parameter. Since rangeList is not specified for either formula, the level 0 members from the dimension tagged as Time are used.
"Prev Asset" = @SHIFT(Asset,-1); "Next Avl Asset" = @SHIFT(Asset,2);
This example produces the following report:
Jan Feb Mar Apr May Jun
=== === === === === ===
Asset 100 110 105 120 115 125
Prev Asset #MI 100 110 105 120 115
Next Avl Asset 105 120 115 125 #MI #MISee Also