In our DP Planning Book, we have two data views Months and Weeks.
The issue that we are facing for few SKUs is that the numbers don't match between MONTHS and WEEKS data view.
In MONTHS view
Months Key Fig A
In Weeks view
WEEKS Key Fig A
Now the two views do not really add up right. So when I check my same SKU in the TECHNICAL periods in the planning book, I see the following.
In Technical Period
TECH PER Key Fig A
So I found that wherever the week splits in two months, there is a very high number which makes the Month's value out of wack. This continues till the end of forecast horizon for all weeks.
One thing to be noted here is that the value in Key Fig A is copied from another Key Figure and that KF looks good.
As I am working to resolve this issue, I wanted to know if anyone has came across the same issue. Any thoughts/suggestions are also welcomed.
what is the time based disaggregation set for KF A? is it P or K and based on another KF
I dont understand this part:
What is your planning process? someone puts in data for the month and does someone change it in the weekly view after that
Can you please try this
0 the values in the months March to June, Save it and reenter the monthly view values and see what happens?