# Dissaggregation to Days by Calculation in SAP IBP

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!

10|10000 characters needed characters exceeded

### Related questions

Posted on Jul 17 at 05:37 AM

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

10|10000 characters needed characters exceeded

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

• Posted on Jul 17 at 06:54 AM

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

10|10000 characters needed characters exceeded
• Posted on Jul 17 at 06:57 AM

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

10|10000 characters needed characters exceeded
• 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.

• Posted on Jul 17 at 07:25 AM

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

10|10000 characters needed characters exceeded
• 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

• Posted on Jul 17 at 12:27 PM

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