Unanswered Questions

I’ve got a KPI requiring to check whether a user is active in a certain timeframe based on a column in a table. In the event a user is inactive, it will count against the KPI. For example, if a user is active in January and February but not in March, the KPI would calculate to a 67% usage rate. I’ve figured out I can use the TIMELINE_TABLE function to map out when users are inactive.The issue I’m running into is filtering on the timeline table. I wind up getting an error message and I’m not sure how to troubleshoot it after reading through the documentation.When I select a specific user or time period, this error populates. I was using the formula template [ “TIMELINE_TABLE”().’Column Name’ ] for dimensions, but once I select a dimension or the timestamp column, I receive the above error. Any help would be fantastic!

how to get badge after completion

Completed my rising business star course now want to implement those skills I learned to create a mock project which I will add in my linkedin post with the rising business star badge.

Quick one: we recently ported an analysis to a view, and we had an Action Flow set up that exported the analysis as a PDF and sent it to a customer via email. Now that we've moved to a view, is there any way to do the same thing — PDF export of a view, sent via Action Flow?

Hello @all, I am looking for other companies hostet on EU-3 Wish you all a nice day. Kind Regards Jonas

I have been thinking about this for a while, and I feel process mining is useful mainly for establishing end-to-end visibility of a process, especially for people sitting at the top who want to view how the process is behaving. But the people who designed the process and the operations team executing it already know how the process behaves, where the bottlenecks are, and the ins and outs of the process. The PI analyst is usually an outsider who can generate a lot of improvement opportunities from the data, but a lot of these can be theoretical and can be rejected by the operations team because they are simply not possible. In this sense, the PI analyst can sometimes be similar to an uninformed management, because they have the information from the process but not necessarily the context of operating it. Also, every process comes with an agreement to fulfil its instances by the operations team through targets such as SLA and RPH, and the operations team is almost always managing to comp

I have observed that well paid process mining jobs are rare with my level of experience (8+ months+ 6 PI Projects built in ARIS)plus there's hardly any response from the market for this role. Is this profession worth investing time into because so far noone is willing to hire 

Working on Celonis Training on “ Get Data into Celonis”. Now, I am not being able to "Create Data Pools" from "Data" Tab at Celonis Studio.Tried to send a ticket at Celonis “Help Center” but “Submit” button is not activated for me. Anyone can help ? Thanks in Advance.

👋 Hello Celonis Africa Community!We have another learning opportunity to share with you. 🎓For those who are current Celonis customers, the upcoming Celonis PI NextGen Programme is a great opportunity for interns and young professionals to build practical Process Intelligence skills directly with Celonis.The free, half-day training is specifically designed for interns and young professionals with up to 2 years of experience.📅 Thursday, 8 October🕘 09:00–12:30 CET💡 FREEWhat you'll learn:✔ Process Intelligence fundamentals✔ How Process Intelligence powers AI✔ Hands-on experience using the Celonis platformIf you or someone within your organisation fits the criteria, please take advantage of the opportunity and share it with colleagues who could benefit.🔗 Secure your spot and register here:https://wkf.ms/4dCmwdQAnother opportunity to keep growing the next generation of Process Intelligence talent across Africa. 🌍

I have the below two columns. I want to extract the portion of the string matching the value in the ‘Seq’ column. Example, for the first row, the seq value is 400. In BIND column, I want to extract the strings that match the value the 400.Till the semicolon. using PQL. 

Hi! I tried to add a new table to my data model (EORD) linked to EINE vía WERKS, MATNR, SYS_ID, MANDT, EKORG, ESOKZ, LIFNR.If I check this unique key in EINE ( Using: select WERKS,MATNR,SYS_ID,MANDT,EKORG,ESOKZ,LIFNR, count(*) AS Amount FROM ALL_NPM_EINE group by WERKS,MATNR,SYS_ID,MANDT,EKORG,ESOKZ,LIFNR order by Amount DESC ) and there is only one case per combination. So in a 1:N relationship it should work or? (EINE 1 → N EORD)Error Message: Case insensitive duplicated joins detected between tables: [EORD] and [EINE].

Hi! I am currently trying to learn about data analysis field and currently also trying to learn how celonis work.So my Question is currently I am doing the business path course and I would I like some help on what to do after I complete this course and what extra skills should I learn during the starting phase of data analysis learning.

Hi Everyone,I am currently setting up the Duplicate Invoice Checker (Catalog 3) app using the Accounts Payable Catalog (v3.0.1).After enabling the Accounts Payable catalog in Objects & Events, the objects VendorAccountCreditItem and VendorAccountDebitItem were not created (only VendorAccountItem exists). When running the autogenerated job auto_generated_dic_combine_vendor_credit_debit_account_items, I encounter the following error:Relation "1a2b3c4d5e_OCDM.o_celonis_VendorAccountCreditItem" does not exist. Please review your query and try again.Environment Details: Accounts Payable Catalog: Version 3.0.1 App: Duplicate Invoice Checker (Catalog 3 / OCPM) AI Annotations / Signals: Enabled and in "Ready" status Has anyone encountered this issue when migrating or deploying the OCPM version? Is there an updated perspective or script that replaces the VendorAccountCreditItem reference with VendorAccountItem? Any guidance on how to resolve this missing relation would be greatly apprec

Hi guys,does anyone has a template to document a project implementation?We mainly have implemented automations, anybody having experience in that?Thanks a lot.

I asked a similar question some time ago, still looking for an elegant solution:Context:Currently we do all the extraction within one Data pool, that does also contain the OCPM objects and events. Since we start to connect additional systems, we want to use the approach “1 dedicated Data pool per system, 1 common Data pool for all OCPM objects and events data”Problem:I hoped to simply rebuild the existing extractions in a new Data pool and then switch the Data source within the OCPM-transformations to the new Data pool. This works totally fine for custom objects, but for Celonis objects the Data source is read-only:  What is the most “elegant” solution?One approach would be to create a view for each table: view in the old data source pointing to the underlaying table of the new data pool. ...quite a lot of (maintenance) effort and not sure whether this would work.Another approach is to create full overwrites of all transformations. But by this you loose the connection to the official c

Dear Community, we have developed a 3-way-match knowledge model with Celonis to implement our touchless invoice case. - SAP S/4 HANA on-premises with Release 2025 FPS01 and the xSuite invoice processing solution- The document is routed via the OCR server to the xSuite Invoice Monitor, where the header table /WMD/FP_IVHD and the line item table /WMD/FP_IFIVI are populated and a unique record number is assigned; up to this point, there is no entry in the standard SAP tables RSEG or RBKP- A delta load is performed every minute into the Celonis Knowledge Model, and a check is carried out to determine whether a 3-way match exists; if so, an action flow is triggered, a JSON payload is created and sent to the SAP Supplier Invoice API, and the document is posted Problem:The SAP document number and ‘closed’ document status are not synchronised with the xSuite tables, so the document remains in the xSuite Invoice MonitorThe Business Transaction Event is normally triggered via the xSuite applicat

Hi everyone,I'm working with Celonis Machine Learning Workbench (MLWB) and a Knowledge Model as the data source.Current setup:Data is queried from a Knowledge Model into MLWB. A Python/scikit-learn model is trained successfully. Predictions are generated and stored in a pandas DataFrame. The goal is to visualize those prediction results in a Studio View/dashboard.The challenge:I can generate the prediction table in MLWB, but I have not found a way to make the prediction output directly available in Studio.I'm specifically looking for a solution that does not require:Exporting a CSV from MLWB Uploading the CSV into Data Integration Manually creating new data tablesInstead, I'm trying to understand whether there is a more native integration pattern between MLWB and Studio.QuestionsIs it possible to expose a DataFrame or ML prediction output from MLWB directly to a Studio View? Can MLWB prediction results be persisted as a Knowledge Model asset, View asset, or another object that Studio c