TS Optimizer error while running at monthly Level

[AyanBishnu]

I want to run the TS optimizer in monthly bucket. I am not using time profile aggregation since Aggregate constraint is not supported while we use time profile aggregation. So I have changed the Base PL for all input and output KFs from technical weeks to a monthly bucket. Now all KFs including the AGG KFs are at a monthly level and I have even setup the optimizer to run at monthly bucket. But when I am trying to execute the optimizer it is failing with the error "Time periods of operator and aggr. constr. key figures are not identical." In the log I am seeing that optimizer is calling the techincal weeks for the horizon.

Kindly suggest what to do to resolve this.

capture.png

error.txt

error.txt

[mkorndoerfer · Accepted solution]

Hi Ayan,

As documented in KBA 2611028 - IBP Error- Time periods of operator and aggr. constr. key figures are not identical, this error occurs if time profile level of any aggregated key figure (e.g. MINAGGPRODUCTION, MINAGGDEMAND) is different than time level at which operator is run.

Therefore, please review all aggregated key figures to make sure they're all on monthly level. The full list can be found here.

Best regards,
Matheus

[AyanBishnu · Accepted solution]

Hi Matheus

In all we have 12 AGG KF for TS optimizer. Below are the AGG KF for which I have changed the Base PL from CALWK to MONTH

KF Techncial Name From Base PL To Base PL MINAGGDEMANDDS CALWKPRODLOCCUSTAGG MTHPRODLOCCUSTAGG MAXAGGDEMANDDS CALWKPRODLOCCUSTAGG MTHPRODLOCCUSTAGG MINAGGTRANSPORTDS CALWKPRODLOCTOLOCAGG MTHPRODLOCTOLOCAGG MAXAGGTRANSPORTDS CALWKPRODLOCTOLOCAGG MTHPRODLOCTOLOCAGG MINAGGDEMAND CALWKPRODLOCCUSTAGG MTHPRODLOCCUSTAGG MAXAGGDEMAND CALWKPRODLOCCUSTAGG MTHPRODLOCCUSTAGG MINAGGTRANSPORT CALWKPRODLOCLOCFRAGG MTHPRODLOCLOCFRAGG MAXAGGTRANSPORT CALWKPRODLOCLOCFRAGG MTHPRODLOCLOCFRAGG MINAGGPCAPAUSAGE CALWKPRODLOCRESSRCAGG MTHPRODLOCRESSRCAGG MAXAGGPCAPAUSAGE CALWKPRODLOCRESSRCAGG MTHPRODLOCRESSRCAGG MINAGGTCAPAUSAGE CALWKPRODLOCLOCFRRESAGG MTHPRODLOCLOCFRRESAGG MAXAGGTCAPAUSAGE CALWKPRODLOCLOCFRRESAGG MTHPRODLOCLOCFRRESAGG

The new planning levels are created by copying the respective calweek planning level and then changing the time profile to months. The only thing that i haven't done is I haven't changed the planning level for input KFs that are having customer at Base PL, because we dont have customer in our planning scope and we are using INDEPENDENTDEMAND KF as input which is also changed to monthly level.

Do I need to change the Base PL for customer related input KF's as well to get rid of this error ?

[mkorndoerfer · Accepted solution]

Hi Ayan,

Yes, you must always keep all supply key figures on the same base planning level granularity, regardless if the key figures are used or not. Therefore, please review the base pl for customer related key figures and let us know.

Best regards,
Matheus

[AyanBishnu · Accepted solution]

Hi Matheus

I did the needful and the it is working fine now. Thanks a lot for the guidance