Dynamic FIX Range Using User Variable and SHIFTSIBLING in PBCS Calc Script

Hi all,

I am currently trying to implement a rolling forecast logic in an Oracle PBCS calc script. The Revenue of the next three months should be calculated differently than the rest of the months until December. Those two different time horizons should therefore be referenced in the FIX statement.

Requirement

I have a User Variable called:

• Actual Period

which contains a month member (e.g. Jan, Feb, Mar, ...).

I want to dynamically calculate:

• from Actual Period
• until Actual Period + 2 months

inside a FIX statement.

Example:

Actual Period	Desired FIX Range
Jan	Jan:Mar
Feb	Feb:Apr
Mar	Mar:May