SHIFT
Basic Overview
Description | Shifts the input node by a given offset amount on any dimension. |
|---|---|
Signature | SHIFT(Node, LevelName, ShiftAmount) |
Parameters | Node: Input node that is shifted, specified using the node name in single quotes (e.g. 'Profit') LevelName: Specifies the level in which the offset is described using the level name in double quotes (e.g. "Year"). The input node is required to have data on this level. Amount: The offset to shift by. This parameter is joined with the Node parameter and will give the proper amount for each entry. This means that the amount cube must match with the levels on the Node parameter. |
Example 1
Input Contracts
Contract Age | Contracts |
|---|---|
1 | 10 |
2 | 20 |
3 | 30 |
Output SHIFT('Contracts', "Contract Age", -1)
Year | Profit |
|---|---|
1 | |
2 | 10 |
3 | 20 |
4 | 30 |
Example 2
Input Contracts
Contract Age | Contract Type | Contracts |
|---|---|---|
1 | A | 10 |
2 | B | 20 |
3 | C | 30 |
Input Shift Node
Contract Type | Amount |
|---|---|
A | -1 |
B | -2 |
C | -3 |
Output SHIFT('Contracts', "Contract Age", 'Shift Node')
Contract Age | Contract Type | Contracts |
|---|---|---|
2 | A | 10 |
4 | B | 20 |
6 | C | 30 |
Example 3
Input Contracts
Contract Age | Contract Type | Contracts |
|---|---|---|
1 | A | 10 |
2 | B | 20 |
3 | C | 30 |
Input Shift Node
Contract Age | Amount |
|---|---|
1 | 1 |
2 | 1 |
3 | 1 |
Output SHIFT('Contracts', "Contract Age", 'Shift Node')
Contract Age | Contract Type | Contracts |
|---|---|---|
0 | A | 10 |
1 | B | 20 |
2 | C | 30 |