SHIFT

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.

Contract Age

Contracts

1

10

2

20

3

30

Year

Profit

1

2

10

3

20

4

30

1

A

10

2

B

20

3

C

30

A

-1

B

-2

C

-3

2

A

10

4

B

20

6

C

30

1

A

10

2

B

20

3

C

30

1

1

2

1

3

1

0

A

10

1

B

20

2

C

30