Forecast release using Fiscal year variant
This scenario comes into picture when
1.
You do not need your forecast numbers to be
released on a Monday and your week definition is not coherent across horizon.
2.
Your week definition is coherent cross
location but do not want to release the forecast on a Monday, while using the
period split profile.
3.
You want to release the forecast to start
of the week and but your week definition is not coherent across location.
Having said that you are already using the FYV
and your requirement is to release the demand on the End of the period that is
“Sunday”.
Following Design will help you address this
requirement without any customization:
1.
You need to have the FYV defined in such a
way that individual periods end a day before where you want to see your
forecast.
i.e.
Normally the week ends for APO on 16th Dec 2012, you should have FYV
with period ending on 15th Dec 2012.
2.
You plan in DP as per normal APO week (i.e.
Monday to Sunday)
3.
Instead of releasing the forecast directly
from DP, take a backup of the forecast figures in a cube.
4.
The backup cube must have Calweek as well
as FYV as periodicity.
5.
Now release the demand from this Infocube
to SNP. While releasing the demand to SNP you have to use the periodicity as
FYV
6.
Once the forecast is released, it will be
released on the first day of the FYV period. That is a Sunday.
Advantage of using above design:
1.
No customizing is required.
2.
Flexibility to define the FYV period hence
flexible to set forecast not only at end of the period but also in the middle
if need be.
3.
Your Forecast in also match the demand in
DP with one week lag.
Let me know your view on this J
No comments:
Post a Comment