on 01-08-2008 11:45 AM
Hi folks,
First happy new year to all of you, lots of success in your project and also in personal life.
I am facing an issue regarding a process of constraint demand. Actually my customer want to put a kind of quota in the forecast calculation on different level of hierarchy, but without breaking the whole solution in place.
There are 2 KF unused in the PB, so I proposed to make the calculation of the forecast in these KF. I named them Quota level 1 and Quota level 2 (level defined the hierarchy)
The calculation of the Forecast is done in the Macrobuilder with 2 macro, running one after the other (not using the algorithmmodel anymore)
The issue is that I don't know how to keep (or save) the fcst calculated at level 2 in the PB, before I run the calculation at level 1, cause there is a disagregation (level 2 depends on level 1). I tried the fix_calc function, but no success. The values I have at level Quota level 2 are wrong because of the calculation at level 1.
Hope this is clear enough,
Thanks for your help.
Regards,
KR
Hi KR,
I have also not understood completely, but from what I could infer from your mail ... it seems you are trying to calculate forecast at Level 2 (lower level) & then Level 1 (higher level).
I wanted to first understand the 'Business Reason' of whatever you are doing ... because I think you may be following the wrong process.
APO-DP will always do "Consistant Planning" so if you calculate forecast at level 2 (which internally would calculate the aggregate for level 1), then I do not know why you would need to calculate level 1, but since you are doing obvioulsy the level 1 calculation would override and disaggregate the new value down to level 2 (losing the past values). If as you run the Macro at Level-2 you Lock/FIX the KF for all CVCs, then the aggregated level-1 is FIXED automatically which would result in our Level-1 run useless.
If you want to retain the Figures calculated at Level-2 and before Level-1, then the only way is to run another Macro in between the 2 Macros (or add steps to first macro) to move the calculation of level-1 to another KF.
I think you need to table down your Design again on the drawing board, reading above on how disaggregation and Aggregation works in APO-DP (cannot be changed) & think thru the design of the Business Process you intend to support.
I hope this helps. GoodLuck.
Regards,
Ambrish Mathur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.