PBCS rolling year member

Summary

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

Content

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.