Skip to main content

Dear Community,

I am creating an OLAP table and a throughput time chart in my dashboard. When i compare the 2 results against each other I receive different results. Does anyone understand why this is happening?

My OLAP dimension is company code. And KPI is: AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Scan] TO LAST_OCCURRENCE[Posting invoice document], REMAP_TIMESTAMPS(ACTIVITIES.EventTime, HOURS)))

This gives me a result of 405 hours

My throughput time chart is:

https://aws1.discourse-cdn.com/business6/uploads/celonis4/original/2X/0/097afc8d39a394f34b308b3345b1502286b6216c.pngI am using first occurrence of scan and last occurrence of posting invoice document in both scenarios and have selected 1 company code.

Does anyone understand what is causing this output difference?

Thanks,

Anna

Hi Anna,
do you have set a calendar in your data model?
image2309825 54.7 KB
This calendar is taken into account in the throughput time component. So in order to replicate it in an OLAP table, you need to use something like
AVG (CALC_THROUGHPUT( FIRST_OCCURRENCE [ 'Scan' ] TO LAST_OCCURRENCE [ 'Posting invoice document' ],
REMAP_TIMESTAMPS ( "ACTIVITIES"."EVENTTIME", HOURS,
MONDAY 09:00 - 17:00
TUESDAY 09:00 - 17:00
WEDNESDAY 09:00 - 17:00
THURSDAY 09:00 - 17:00
FRIDAY 09:00 - 17:00)
))

I hope that solves the issue.
Cheers
David

Hi Anna,

 

were you able to solve this? Another guess could be that you have component filters applied which results in different values for the two components. That usually the first thing to check when you have discrepancies in results.

 

Best

Kevin


Reply