Throughput calculation data discrepancy

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:
image

I 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?

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