Hello all, 

I’m currently working on combining various cycle times (e.g. from PO Item creation to Goods Receipt, or from Goods Receipt to Invoice Receipt) with key figures from my Case Table in a single OLAP table.

To achieve this, I’ve tested two different approaches:

1. Cycle Time Calculation Based on the Activity Table: This method allows me to control which occurrence to consider — for example, in cases of multiple GRNs for the same PO line, I can choose to include only the first one. The formula delivers the expected results. However, I’m unable to combine this approach with other key figures from my Case Table (e.g. Company Code, PO Item Count, etc.) in the same OLAP table. Additionally, if the cycle time is negative (e.g. GRN before PO Item creation), the formula returns “–” instead of the actual negative value.

    

   AVG(CALC_THROUGHPUT (

   FIRST_OCCURRENCE [ 'Create Purchase Order Item']

   TO FIRST_OCCURRENCE [ 'Record Goods Receipt' ] ,

   REMAP_TIMESTAMPS ("_CEL_EKPO_ACTIVITIES"."EVENTTIME" , Days )

   ))

2. Cycle Time Calculation Based on SAP Table Timestamps: This approach allows me to pull all relevant fields via BIND and PU to the Case Table level, enabling a unified OLAP table that includes all key figures. However, I cannot ensure that only the first occurrence is considered. In cases of multiple GRNs, the cycle time is calculated for each GRN and then averaged. I’ve also noticed that in some cases — e.g. when SAP shows 20 GRNs — the formula only recognizes 10 or 15, possibly due to limitations in the BIND and PU chain.

   
   AVG(DAYS_BETWEEN (BIND("BKPF",PU_FIRST("RBKP", BIND("RSEG","EKPO"."CREATIONDATE"))),

   BIND("BKPF",PU_FIRST("RBKP", BIND("RSEG", PU_FIRST("EKPO","MSEG"."BUDAT_MKPF"))))))

Does anyone have a solution or workaround for this scenario?
Any suggestions would be greatly appreciated.

Thanks in advance 🤜🤛