cancel
Showing results for 
Search instead for 
Did you mean: 

Min/MaxAggPCapausage KF data entry @ Month level in TS Optimizer

andy_yeri
Contributor
0 Kudos

Experts:

We've used the Aggregate Constraint Min/MaxAggPCapausage & their non-delivery cost rate KF's to control how much of capacity we need to be apportioned to the "preferred" product group over the others & it works fine. However, this KF being @ weekly level (Plng lvl - Week-Prod-Loc-Res-Src-Agg), doesn't allow us to enter the Min/MaxAggPCapausage values @ a monthly level, that the users would prefer to enter (read 168hrs/week vs 672hrs/month, as an example). Aside from creating a new "Z" key figure to allow users to enter monthly values & later distributing equally across the weeks on to this AggPCapausage KF, would there be another/better option to use?

We are using TS Optimizer

Cheers

Accepted Solutions (0)

Answers (1)

Answers (1)

raghunathpartha
Explorer
0 Kudos

Hello Anand

This is possible only through Data integration Jobs upon file upload at higher time levels. In excel UI , this cannot be possible for aggregated constraint Key-Figures

For eg: 50 Loaded at weekly level got distributed to daily level in MAXAGGTCAPAUSAGE as 7 each

Thanks and Regards

Raghunath Parthasarathy

andy_yeri
Contributor

Thanks Raghu. So, the example you've shown on your screen print is a file upload via data integration @ weekly level & the system distributing it across @ daily level? I will try to load data @ Month level & see