Skip to Content

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • 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

    Add a comment
    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

    Add a comment
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • 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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.