[Problem Summary]
Merhnoosh have found an issue with calendar items used as a target for Metrics KPIs.
When you have a calendar item bound to a period (ie daily target), and is used as a target for a metrics KPI, Ampla doesn’t calculate the correct value for the longer periods.
For example you have a calendar item Production_Daily_Target. The value of this target might be different in different days. Now if you use this item as the target for your Production KPI, Ampla calculates the target value for the month by multiplying the value of Production_Daily_Target at the beginning of the month by the number of the days in the month; while the monthly target should be the sum of the Production_Daily_Targe value for each day of the month.
This problem applies to both Ampla 7.2 and 7.3
It is the same way it works at the moment. The only change is not to use only the value of the calendar item at the beginning of the period, instead if the value changes in the middle of the period, Ampla should use the new value.
For example
Production_daily_Target = 1000 box at Jan 1st
Production_daily_Target = 2000 box at Jan 2nd
Production_daily_Target = 500 box at Jan 26th
Production_daily_Target = 3000 box at Jan 27th
Currently the KPI target for the Month of Jan will be 1000x31= 31000
While it should be = 1000 + 24x2000 + 500 + 5x3000
Also it is not just for the month. It applies for any period. In Alrosa they have the value for each hour and they want to calculate the KPI for shift and day.
It is not that complex and no different aggregation required.
Normally when a period is bound to a calendar item it is usually for the totals not the rates. So the aggregation is always the same.
[Workaround]
Add monthly data into Ampla calendar.
[What is the impact to Customer/s]
This does not affect the current contract but will affect their overall satisfaction with Ampla and may affect their decision of using Ampla for their other sites.
