Dear all,

I am encountering curious changes of results depending on the number of KPIs and Filters. I put an identifier in EKKO-VERKF for differentiating process patterns. Each pattern goes through maximum four, minimum two process flows. In other words, one CASE_ID contains from two to four activities.

Here is the problem: the result changes after you add another KPIS, namely M04 disappears, from M01 to M03 gains/loses a few. I am wondering why one KPI affects the others, or rather if I write this code wrongly.

Best regards,

[kpis]

CASE

WHEN SUBSTRING(EKKO.VERKF, 3, 3) = M01

THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[a] TO FIRST_OCCURRENCE[b],

REMAP_TIMESTAMPS(ACTIVITIES.EVENTTIME, HOURS)) - 7*24

WHEN SUBSTRING(EKKO.VERKF, 3, 3) = M02

THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[a] TO FIRST_OCCURRENCE[b],

REMAP_TIMESTAMPS(ACTIVITIES.EVENTTIME, HOURS)) - 14*24

WHEN SUBSTRING(EKKO.VERKF, 3, 3) = M03

THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[a] TO FIRST_OCCURRENCE[b],

REMAP_TIMESTAMPS(ACTIVITIES.EVENTTIME, HOURS)) - 21*24

WHEN SUBSTRING(EKKO.VERKF, 3, 3) = M04

THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[a] TO FIRST_OCCURRENCE[b],

REMAP_TIMESTAMPS(ACTIVITIES.EVENTTIME, HOURS))

ELSE 0

END