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