Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
PBCS rolling year member — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

PBCS rolling year member

Accepted answer
edited May 18, 2021 10:15AM in Planning 7 comments


Dynamic Calculation of Rolling 12 month period in PBCS as a single Years member for BSO and ASO


I have a years dimension and a period dimension.

I have set up the rolling forecast variables using the form functionality and populated it using business rules. All good.

RF_Per1 = Apr, RF_Per2 = May....RF_Per12 = Mar

RF_Yr1 = FY21, RF_Yr1=FY21... RF_Yr5 = FY22.... RF_Yr5 = FY22

With periods ordered: Aug to Jul, hence the period 5 increment of year as above.

I use the year / period variables in forms and reports to display the populated periods, again all good.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!