Can be used in place of the @SHIFT() function, the @PRIOR() function, or the @NEXT() function to improve performance if the formula meets the following criteria:
The formula is being executed in CELL mode.
The formula has one of the following patterns:
X = Y - @SHIFT(mbrName [,n, rangeList])
or:
X = Y - @PRIOR(mbrName [,n, rangeList])
or:
X = Y - @NEXT(mbrName [,n, rangeList])
If these criteria are met, consider rewriting your formula using @SHIFTMINUS() instead. @SHIFTMINUS() runs the formula in block mode, improving performance.
Syntax
@SHIFTMINUS (mbrName1, mbrName2 [,n, rangeList])
Parameter | Description |
---|---|
mbrName1mbrName2 | Any valid single member name or member combination, or a function that returns a single member or member combination. |
n | Optional signed integer. n must be a numeric value, not a reference, such as a member name. If you are using @SHIFTPLUS to replace the @NEXT function, use 1 as the value for n. If you are using @SHIFTPLUS to replace the @PRIOR function, use -1 as the value for n. Default value is +1. |
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
The following example shows a formula using @SHIFT().
Sales = Loss - @SHIFT(Sales, 1);
Here is the formula using @SHIFTMINUS() to improve performance:
@SHIFTMINUS (Loss, Sales, 1)
See Also