Solved

Over the Join Functionality documentation page (Join functionality (celonis.com)), when we get an 'No Common Table' error message - a detailed explanation along with the join path is explained. As I am new to the Celonis world, I wonder how to use the mentioned path to achieve the corresponding result.  Thanks in advance.

Hi everyone,we are currently restructuring our data architecture in Celonis. For each process area (P2P, AP, AR), we have separate data pools where we extract, transform, and load the respective data models.In the AP area, we already use a dedicated Central Extraction Pool, which only handles the extraction of raw tables. The actual AP data pool then receives these extracted tables and performs the transformations.Now, we want to extend this concept gradually to other areas. For example, we plan to stop extracting the CDPOS table in the Purchasing Pool and instead consume it from the Central Pool. This step-by-step migration should help us reduce redundancy and improve maintainability.However, I have a specific question regarding this setup: If I start consuming tables from the Central Pool in the Purchasing Pool (e.g., CDPOS), what happens to other tables like EKKO, which are still being extracted directly in the Purchasing Pool?Will my transformations in the Purchasing Pool use the l

Hi all,I have a question relating to “hygiene” in data pools.In my organisation we use manual data ingestion and upload files into our data pools. Over time, a large number of files and tables was added and created. I’d like to do a bit of house-keeping and remove obsolete/ unused files. How can I do that? I have analyst access.I look forward to hearing from you. Thanks.Kind regards,Vladimir

Hi everyone, We have several ABC Classifications that we need to implement in Celonis and I’m simply curious:Why is the ABC classification resulting in a 1, 2, 3 ranking? I’m ending up having to convert to string and remap the values for each classification so that it makes sense for the users and while it’s not a huge issue, I think it would be easier if the function just resulted in A, B, C directly. Is it for efficiency by using integers?  Or does this allow for some further analysis that I’m not seeing at the moment maybe? Best regards,Benjamin

Hello everyone, 👋I’m building an overlay view to show case details, using number as a variable.Currently, the overlay view has a predefined filter like this:FILTER "sc_req_item"."number" = '${number}'; However, I’d like to make the overlay more dynamic — for example, use another variable ${case_table} to replace "sc_req_item" (or even "sc_req_item"."number") so that the same detail view can work for multiple case types, such as Requests, Request Items, and Tasks. Has anyone successfully used a variable for table or column names in a FILTER statement (or found another way to make one detail page work dynamically across multiple case tables)?Any insights or workarounds would be really appreciated! 🙏 Thanks!BR,Xiangxiang

Hello everyone, I’m trying to use Action Flow to trigger chained data jobs, meaning job A is executed, once it’s done job B is executed, once it’s done job C is executed. Ideally, I would like to launch Data Model Schedule from Action Flow, but I’m only able to launch data jobs and load data model. What I’ve done so far is: 1. Creating json file with all my jobs ID (A,B,C) - Parse Json Module2. Creating a POST request using API Celonis Key, to access data pool and launch jobs, load data model -    HTTP Make a request Module3. Using Iterator module to repeat step 2 for all job IDThe issue I’m facing is, job A need to be completed before launching job B and same for job B and C (this is what I’m calling chained data jobs). Configuring a Sleep in the iterator loop greater than the running time of my jobs is working, but not optimized. My question is: Do you know if there is a way to trigger chained data jobs in Action Flow, meaning triggering Data Model Schedule or launching several jobs

Hi everyone I have a challenge that I’m trying to figure out related to pycelonis.I’m currently trying to get the component values from a view using pycelonis. Unfortunately, I couldn’t find any information inside the documentation that can help me with this.It seems that the documentation only explains how to work with analysis or knowledge models. Does anyone know how to work with components of a view inside pycelonis?Best wishes!

Hi allI have a very basic question – sorry for that, I’m quite new to PQL and I cannot apply the information available online (or did not find it).I have two tables incident_CASE with column CASE_ID (1-side) and workorder_CASE with column WORKORDER_ID (n-side) (1 incident can have 1 or more workorder).How can I count the following:Number of incidents with exactly 1 workorder Number of incidents with 2 or more workorder Many thanks for your supportBestroger

Hi together, I'm working with legacy views and can't manage to pass the value of an augmented attribute of type date to a variable to use it as parameter for KPIs. The record containing the augmented attribute  - id: CM_MONTHS    identifier:      id: id      displayName: Id      pql: '"CM_MONTHS"."MONTH"'    attributes: []    newAttributes: []    augmentedAttributes:      - id: late_creation_deadline_date        displayName: "Late Creation: deadline date"        possibleValues: []        columnType: DATE        format: "%Y-%m-%d"        housekeeping: false        type: AUGMENTED_ATTRIBUTE    flags: []    priorities: []    triggers: []    businessRules: []    type: RECORD    origin: PACKAGE The component to update the augmented attribute  type: table  settings:    data:      columns:        - id: 3486adcd-a996-49a5-97e0-af17da07e9af          field: CM_MONTHS.MONTH          order: 100        - id: 10c08937-649f-48a0-88fe-929d3107e824          field: CM_MONTHS.AUGMENTED_late_creation_dead

Hi Team, I’m working on input dropdown where my timestamp should be convert into daily,weekly,monthly and if it is daily I need 8 hrs , for weekly 40 hrs and monthly 173 hrs in one single dropdown. How I can achieve it. Regards,Ajith Naidu.

Hi team, I want to know more change the default display of columns within the Case Explorer component of Studio Views, after having added two more attributes.Best regards, Leonardo

Hi Everyone, In year 2022, I have gone through two certifications Implementation professional and solution professional, today when I tried to find these two certification I am not able to see it not training track and not in section called certification, in certification section only two certificates are shown, Data Analyst and Data Engineer. can someone please help to understand what is exactly have happened

Hello,I’m an independent consultant specializing in process optimization and based in the Netherlands. I often help clients adopt and integrate new tools to improve efficiency and am very interested in Celonis.I’m curious if there are opportunities for independent consultants like me to partner with Celonis. Specifically, I’d like to know if the partner program supports using the platform with clients and possibly providing training on the software.Could someone provide more details about the possibilities and requirements for such a collaboration?Thanks in advance!

Is it possible to use a KPI in a text box like in Legacy Views? I currently use this to display the last data refresh date of the use case in Legacy Views, but this option isn't available in New Views. Has anyone tried using any other component ?

There is a case I want to solve, see below. I have a solution I would apply if I had classical programming language + RDBMS, but I'm not sure how to implement this in celonis or whether there is another solution. Could you please help? The case I want to solve is sending email notifications to users via action flow in case there are missing invoice receipts.For each missing invoice receipt there is a notification type that can be chosen with their own subjects, body text, etc., for instance:If the date1 >= today + 7 days then group 1.If the date1 >= today + 14days then group 2.If the due date >= today - 7 days then group 3. One possible solution would be to keep the history of the sent emails in some table and join it to the missing invoice receipts data to filter out the emails for each new iteration of sending - so that we don't send some letters twice if we already sent them.E.g. if we had sent the email of type for invoice receipt no. 12345 yesterday, we don't

I'm encountering a persistent error in the View: "Failed to auto save the View. Please save your changes manually." Even when I attempt to save the changes manually, the View does not get saved, and none of the modifications to the UI are being retained. Is anyone getting the same issue? what could be the possible resolution?

Hi,is it possible to use a COUNT_TABLE together with CASE WHEN to form a KPI? Below Query works for a simple COUNT with “TABLE”.”COLUMN” in THEN, but doesn’t work for COUNT_TABLE. COUNT_TABLE(CASE_WHEN(PROCESS EQUALS XY OR PROCESS EQUALS XZ) THEN "CASES" END) Thanks!

Hello Celopeers, im new to Celonis and have created a view. There i use a Kpi which drops a lot of zero values. When trying to filter them out i always get the error that aggregated functions can not be used in combination with the FILTER function, and that i should try PU functions. The KPI i'm using is this:SUM( CASE  WHEN round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") = round_day("o_custom_KnotenpunktFuellstand"."Date")  THEN 1  ELSE 0 END)or alternetively this : COUNT(DISTINCTcase when round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") =round_day("o_custom_KnotenpunktFuellstand"."Date") then  "o_custom_KnotenpunktFuellstand"."KnotenpunktAuftrag_ID"end) is simply want to calculate for each KnotenpunktFuellstand.Date, how many Order.IDs i have where the filter condition is met.So i can have a table where im using the date plus KPI to see, how many outgoing orders i can except for each date. How can i have a row-count, based on a condition formulated as a PU functi

I am new to Celonis. I have this dilemma on ‘Why do tables exists when we have OLAP tables’.What is the purpose of two of them existing?I know tables are present only in views while OLAP tables in analysis.What are all the differences or things we can do with tables and OLAP tables seperately? 

Hello Community,I would like to give my users the option to display an amount (e.g. freight) in any currency. To do this, I use the function CURRENCY_CONVERT_SAP and pass the target currency via a variable. This works perfectly.My problem is the unit: Do you know of or is there a way to use my variable in the unit field so that the selected currency is automatically displayed as the unit?Thank for help, Thomas  

I have some confusion as to why analysis and views exist as separate entity. When both of them serve the same purpose despite the differences in availability of some features.

Hello everyone,I hope you can help me understand the difference between the two PQL functions CASE WHEN and STATIC CASE WHEN.I can't find the difference using the documentation, and unfortunately, I couldn't find any content about it in the forum either. I would really appreciate your help and hope someone can explain it.Thank you for your support!Best regards,Robert

Hi all,I’m a beginner of Celonis. I belong to process office department, I’m in charge of CPM.I’ve done the 5 learning contents “Celonis Process Management (CPM)”. What should I learn next effectively?It seems that there are the cource which is “Your journey”, so I think this is effective for me.

Hi Team, Has anyone built solution for Tax reconciliation analysis based on General Ledgers for Indirect Tax. We are trying to automate tax reconciliation which will have analysis basis documents types, credit, debits for each GL account. Any suggestion on the SAP tables, logic are welcome.