Dissaggregation to Days by Calculation in SAP IBP

[former_member693860]

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!

[Irmi_Kuntze · Accepted solution]

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

1. If you want to divide all values always by 7, you have a formula
   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)
   
2. If you want to split based for example based on working days that your location has, you can have a KF Calendar@DayLoc which has in all working days the number 1, and in all non-working days the number 0
   Then you have a helper KF HCalendar@WKLoc = Calendar@WKLoc and the additional calculation Calendar@WKLoc = SUM(Calendar@DayLoc)
   You then can calculate
   ZPRODUCTIONDAYS@DAYPRODLOC =
   PRODUCTION@WKPRODLOC * Calendar@DayLoc / HCalendar@WKLoc
   
3. You can have a kind of calendar that is not depending on the location and do similar calculation then in option 2, using attribute transformation, but as this seems to be one of the first times you configure cross-level calculations I suggest that would be a bit too advanced for now
   
4. Depending on your detailed requirement, there are more possibilities

Yours

Irmi

[former_member693860 · Accepted solution]

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?

[former_member693860 · Accepted solution]

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

[Irmi_Kuntze]

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

[former_member693860]

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!

[Irmi_Kuntze]

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

[former_member693860]

Yeah , I will not change any key figure that is either input or output of TS Supply

Please advice a simple 1,2,3 simple steps on best way to address this requirement given the shared premises

[Irmi_Kuntze]

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

[former_member693860]

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.

[former_member693860]

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.

[Irmi_Kuntze]

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