Skip to main content

Solved

353 Topics
joos.buijs
Level 6
joos.buijsLevel 6
asked in General Q&A
Celonis Community Archive available?

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.

11
EBrozio
Level 2
.
Level 3
.14600835Level 3
asked in Process Analysis
Index sheets - Front end

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

13
M
Level 1
thomas.keim
Level 4
thomas.keimLevel 4
asked in Data Ingestion & Infrastructure
PU_COUNT_DISTINCT - No Common parent between tables could be found

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

107
D
Level 2

Badge winners

  • Qualified to Deliver Business Value with Celonis
    verena.schwo12has earned the badge Qualified to Deliver Business Value with Celonis
  • Qualified to Manage Change and Scale Adoption
    verena.schwo12has earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Build Analyses
    hemalatha.d11has earned the badge Qualified to Build Analyses
  • Qualified to Build Views
    hazel.brown12has earned the badge Qualified to Build Views
  • Celonis Certified Data Engineer
    shaik.musth11has earned the badge Celonis Certified Data Engineer
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025