Solved

Today I noticed we moved from the Celonis Community to CeloPeers.com. This needs some getting used to of course. My main question however is if the Celonis Community will be available for archive purposes (e.g. read only), as I found it a valuable resources and it will take time before Celopeers will be at the same level.

Hello All, Anyone knows how to use and what is the benefits of using index sheets on front end analysis? I tried using and seems its scanning open requests but not sure how is it working? Thanks, Kalpesh

Hello,Im looking for an solution for this challenge:We have 3 SAP ERP TablesVTTK (Shipments)VTTP (Shipment Items)LIKP (Deliveries)LIPS (Delivery Items)VTTK is linked 1:N with VTTPVTTP is linked 1:1 with LIKPLIKP is linked 1:N with LIPSI want to count the distinct material numbers per shipment.Count per delivery works fine: PU_COUNT_DISTINCT(LIKP, "LIPS"."MATNR")But I need it per shipment for further calculating KPIs, like this:PU_COUNT_DISTINCT(VTTK, "LIPS"."MATNR")Here I get the following error:No common parent between tables could be found - Please check your schema. The tables VTTK und LIPS do not have a common parent in the schemaWithin the help I found the BIND function. I tought, this can be the solution:PU_COUNT_DISTINCT(VTTK, BIND(LIKP, "LIPS"."MATNR"))But here I get an error in the formula.How can I solve this with a formula und without changing the data schema.Thanks for you helpThomas