Skip to Content
avatar image
Former Member

Issue with saving data after macro calculation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 11, 2008 at 09:07 PM

    Have not understood the issue completely. However if the requirement is to lock key figures you can always try to lock by setting the logic around attribute of the key figure row to Fixed Value.

    Logic around fixed cells

    make note of the solution given in the thread carefully and I am guessing you should have the answer.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2008 at 07:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded