We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
17
Views
7
Comments
edited May 18, 2021 10:15AM in Planning 7 comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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