Skip to main content
Question

Calculate Throughput Time differs in Single KPI and OLAP Table

  • December 8, 2021
  • 2 replies
  • 7 views

Hi peers,

I try to set up new components using CALC_THROUPUT. The two following components show different results. This is presumably caused because the OLAP tables have multiple lines with single CASE_KEY though the process pattern only occurs once (and it should since we use FIRST_OCCURENCE).

 

It won't change when we use Attribute selection overhead to limit to single KUNNR or give KUNNR in Dimension.

 

Why OLAP returns several line items?

 

Single KPI (Number)

<KPI>

CALC_THROUGHPUT(FIRST_OCCURRENCE['Create Sales Order'] TO FIRST_OCCURRENCE['Create Delivery'],

REMAP_TIMESTAMPS("_CEL_SD_ACTIVITIES"."EVENTTIME", DAYS))

 

OLAP (identical with single KPI)

<KPI>

CALC_THROUGHPUT(FIRST_OCCURRENCE['Create Sales Order'] TO FIRST_OCCURRENCE['Create Delivery'],

REMAP_TIMESTAMPS("_CEL_SD_ACTIVITIES"."EVENTTIME", DAYS))

 

2 replies

janpeter.van.d
Level 12
Forum|alt.badge.img+26

Hi @tomoki.tsune,

 

Good question, unfortunately this one isn't solved in the past..

 

Hopefully somebody can help with this.

 

Kind regards,

Jan-peter


  • Author
  • Level 4
  • December 9, 2021

Hi @janpeter.van.d ,

 

I'm glad that I could have you here. Thank you for indicating me the same troubles that our fellows had.

It seems that the CALC_THROUPUT won't be grouped by the given Dimension at any case, just calculating Lead Time of each process, right?

Do you possibly have any alternative formulas to achieve the same result using different approach?