Skip to main content

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_OCCURRENCEN'Create Sales Order'] TO FIRST_OCCURRENCEN'Create Delivery'],

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

 

OLAP (identical with single KPI)

<KPI>

CALC_THROUGHPUT(FIRST_OCCURRENCEE'Create Sales Order'] TO FIRST_OCCURRENCEE'Create Delivery'],

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

 

Hi @tomoki.tsune,

 

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

 

Hopefully somebody can help with this.

 

Kind regards,

Jan-peter


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?


Reply