Welcome to the Celonis Community
Hi,I am looking for a PQL code to solve the following.We have data for multiple dimension over a period of time. I would like to get the data aggregated on one dimension per month.All the data is within one table.|Dim1|Dim2|Dim3| Month | KPI ||----|-----|-----|------|---|| A | X1 | Y1 | Jan-21 | 300 || A | X2 | Y2 | Jan-21 | 200 || A | X3 | Y3 | Jan-21 | 400 || A | X1 | Y1 | Feb-21 | 200 || A | X2 | Y2 | Feb-21 | 100 || A | X3 | Y3 | Feb-21 | 500 || B | X1 | Y1 | Jan-21 | 300 || B | X2 | Y2 | Jan-21 | 200 || B | X3 | Y3 | Jan-21 | 400 || B | X1 | Y1 | Feb-21 | 200 || B | X2 | Y2 | Feb-21 | 300 || B | X3 | Y3 | Feb-21 | 500 | What I would like to get is.jan-21feb-21diff.A900800-100B900100200 I have been trying with the domain table and PU functions but I was not able to make it work.Thank you
Dear All, I remember linking SAP CRM URL to Celonis so from detailed Tab, I can jump to the transaction in URL. I dont find the steps to do that. Can someone help here? Thanks
After viewing the "Thought Leader Panel: Managing Real Organizational Change: The New Center of Excellence on CoE" I wonder: How to manage standardization and quality control when you support the self-service approach for users to create their own analyses? Besides, offering established templates for it.
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
