on 07-17-2020 6:08 AM
Hi Experts
I'm facing issues while trying to bring a stored KF in weeks into days.
Let's say I have the source KF PRODUCTION whose base planning level is WKPRODLOC, and I have a target KF "ZPRODUCTIONDAYS" whose base planning level is DAYPRODLOC.
The desired output is that the same values that PRODUCTION has at weekly buckets (700 FOR WK1) , could be displayed on ZPRODUCTIONDAYS at a daily level (100 each day in W1)
Please advice configuration tips for calculation definition as i'm currently a bit confused on this topic.
Thanks!
Hi
If the stored level is WK and the target is Days, you need an additional KF to bring that down, as the golden rule is that ALL ATTRIBUTES (including the time attributes) that are on the left side = result of the formula must somehow be filled by the right side = input KF
You have a couple of possibilities to achieve, that, maybe you should read the chapter about split factors in the model configuration guide
Yours
Irmi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Irmhild, thanks for your detailed response, a few questions raise from this:
If my attributes are not the same on the left and the right (Left has Days, Right has Weeks) , what needs to be done?
...I assume that a new planning level must be created with matching time profiles (Days as it is the lowest) and the PRODUCTION KF must be assigned to it, however, this may affect the Planning Operator (I might be wrong), what's your take on this?
Additional query:
On your response point "1. ....ZPRODUCTIONDAYS@DAYPRODLOC = PRODUCTION@WKPRODLOC / 7.....But you MUST have add an additional input KF that is on any daily level and has minimum one further attribute in common (e.g. at level DayLocation)"
This additional KF what is it for?
And..the split distribution into daily buckets is not really my concern right now, but how to get values populated into the ZPRODUCTIONDAYS KF, that's where I'm facing the issue currently.
Thanks again
Not sure what else you need, I even provided the calculation formulas.
Sorry I don't have more time to explain how to do basic key figure calculation, I can only provide you the general concept - and that is done
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry but your answer is wrong. When doing exactly as you advised, "the golden rule" is broken.
Interesting that there are conflicting answers between two SAP experts, as your colleague @mkorndoerfer posted on these thread that what I'm trying to do can't be achieved. I prefer more honest and straight forwards answers to be honest.
https://answers.sap.com/questions/128125/time-disaggregation-sap-ibp.html
And sorry if I wasted your time.....I wasn't born an IBP expert , but I still eat daily a lot of humble pie.
Bye!
you MUST not change the planning level of any key figure that is either input or output of TS Supply
And it has no effect as you do not change the standard key figure but only the custom target key figure - unless you have any plans with this, but surely you cannot use that daily KF for the heuristic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
and yes depending on the solution you pick you may need an additional planning level
no impact on any copy operator, that would be an on-the-fly calculation
Maybe you should take the class IBP300, where advanced modelling features are considered, or read the model config guide on the chapters of cross time level key figure calculations
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the suggestion, I've been through the model configuration guide chapter that you mentioned throroughly, however the movement between week to days example is not considered as the sample SAPIBP1 does not considered day level and it would need additional steps (NOT COVERED IN GUIDE) to do it.
I did not mean any Copy Operator, I wrote Planning Operator , I don't think it would be wise to change the base planning level of the KF PRODUCTION because it is a core output of the TS Heuristic.
Please advice a simple 1,2,3 simple steps on how YOU would address this requirement given the shared premises.
as I wrote: the golden rule is that ALL ATTRIBUTES (including the time attributes) that are on the left side = result of the formula must somehow be filled by the right side = input KF, which is why you need the additional KF and which is how to get it down to days
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 | |
3 | |
2 | |
2 | |
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.