Product Q&A

P2P - Process and Data Mining ExpertABB Location: flexible globally Description: The ABB Way Finance Transformation Program (FTP) is a business-led program that will help to underpin the new ABB Way operating model and the decentralization agenda. In this role you will be responsible for translating business requirements into the appropriate data/process mining solution. (Check out the full description following the link) Apply here

Is it possible to go back continuously one year from the current date in the StartDate parameter. So that only the past year is in the system?

I created an action flow converting celonis data into a CSV file.  By using the Material no. column the action flow is converting this column not in right format. --> Material no. is displayed in the wrong way.The material numbers are starting with a 0.  This is how the CSV file looks like. How can I fix this issue?

Our company has a 'Blocked Invoices - Action View' built out that includes filter options such as vendor, block reason, etc.  If a business user has 98 vendors, what options are available for saving personal filters such as book marks used in analyses? This business user also needs access to all vendors for visibility and to allow them to back up other team members if they are absent; therefore, a backend filter is not feasible.

Hello, I have a problem when uploading a csv file (activity table). After selecting the file only 1 column is returned when oonfiguring the data schema. However i was expecting multilple columns. Please find attached the c file and a screenshot. Thanks!

I have a question regarding PyCelonis 2.0.0. It looks like any means to access data (from a datamodel) and use it with a data frame were removed from the package. Is my assumption correct? If so, how would you implement something like an "invoice duplication" app with Python in the ML Workbench if it is impossible to get the data? Thanks

There is a method to push data into the datamodel, but i could not find any that can access it.Please let me know if anymore details are needed.Thank you 

Hello together, i am trying to connect Smartsheet with Celonis. I already have a Client ID and Client Secret for Smartsheet but everytime I try to connect both, Celonis/Smartsheets opens a new tab showing an error saying Redirect URI ist missing or wrong. Does anyone know what to fill out in the Developer Settings of Smartsheets in the field APP URL & APP redirect URL ?  I have filled in an APP URL (something like https.//xyz.celonis.cloud/package-manager/ui/studio/ui/assets/xxxyyy-11-123) and an APP redirect URL (https://app.smartsheet.com/b/autorize?form.....) and every other mixture of URLs but nothing seems to work out. I have also reviewed various Celonis / Smartsheet Docs but found no answer until now. Thanks in advance

I am a beginner and doing the process mining course from Celonis academy. I have successfully create a data pool and corresponding data model. It is showing that data model is successfully loaded too but when I try to do analysis, and create a new data model variable, it does not show in the drop downs. I have attached the screen shots below

Any innovative research or point of view or use cases that are beyond P2P , O2C or any traditional use case.

Which Algorithm does Celonis use for Process Discovery and Conformance Checking?

Dear all, I started new DCP project from this month. I installed Process connector and Analyses from App store then modified some of Vertica SQL in transformation, and PQL in the analysis. After some changes, I found that I am not confident which code I modified. Referring to SAP ABAP or Java or some other languages, we normally can use version control tools, like Git, Subversion, that can manage who and when code is committed, which part of code was changed (before/after). In Celonis Project how to manage source code version ? Do you have your best practices ? Best regards, Kazuhiko

How can I calculate the Share of Product Type for each Delivery Number? In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of result.

How to enable Action flow to execute the skill only if we have records from query data?

Hello togheter,  currenty im trying to set up an action flow which is triggered by new Data in an Action Engine. I read that this can be done via a Skill. The Action Flow starts by using a custom webhook and then quering data from Celonis. For the skill, i first set up an Action Engine Sensor and secondly an "Execute Action Flow" command. Within the Action Engine i filtered the data for the data im looking.  Currently I am facing the problem that if I delete all manual inputs in the 2 commands of the skill the skill seems to trigger the action flow but the custom webhook component within the action flow doesnt receive any data. Based on this if I want to put data into the webhook it will be done manually, which is not the point of the aciton engine.  So my question is: how can i set up all these components that the skill, based on new data in an action engine, only triggers a action flow without trying to provide data to the action flow? Is that possible? Thank you very much!

Hi, would you recommend any specific course related to the Studio for an end user? The ones I saw are recommended for development matters.

download user list as .csv  invite new users

How to change color in Chart based on category in Celonis Views? I wanted to understand if it is possible to change color in Chart (Celonis Views) based on category, this is what I am looking for In the following image let's consider activities as the category, my requirement is that all category should be displayed the same color, i.e. Format Book should be yellow in both the cases, Edit draft should be orange, etc. Change in Y axis should not change the color scheme  I can achieve this in a KPI , by using the Custom Object option, however is there something similar for Charts or any alternative solution for the same ?

¿Como puedo cambiar la cuenta de customer a cuenta de partner? o ¿Como puedo eliminar la cuenta?

Successfully completed project. My client wants to understand how one can delete customer data permanently from celonis tool. My company has used C4C license to complete the project. ​Could any one share me standard process followed by Celonis to delete customer data permanently? If any documents on this pls share. ​If we want to delete manually once they give approval to delete is there any method. ​Thanks in advance​

Team - We have one Celonis prod environment and would like to set up Development, Testing, production structure for multiple business areas(5-6 business areas). Do we have any methodology, document etc.

I've set up a weekday calander in Process Data Models that consist only of the working days (Monday-Friday, all day). Unfortunately in the Process Explorer, Case Explorer etc. the througput times aren't adjusted. Do I have to set up additional things?

Hi, all.I've followed all the steps to copy (pull+push) data between two teams that are detailed in the documentation in pycelonis: https://celonis.github.io/pycelonis/1.7.6/tutorials/api_tutorial The transfer of data is ok but when I process the data model in the target team I get the next error: The load failed: Load failed. Error Message: Timestamp column ["_CEL_SF_CASE_ACTIVITIES"."EVENTTIME"] of activity table ["_CEL_SF_CASE_ACTIVITIES"] must be of type DATE, but got [INT]. It seems that the "push" loads the eventtime data as INT type instead of date time type.An example: the time stamp 15/11/2022 12:02:00 of the source tabla is loaded as 1668681300000000 in the target table. I've checked the source data when extracted in the pandas dataframe before uploading it ot the target table and it's OK.I've checked the data once loaded and it's NOT OK. Any help?? Thanks!   

Regular expressions use ^ as the starting metacharacter and $ as the ending metacharacter, but Celonis doesn't support end-of-line metacharacters. What are end-of-line metacharacters?

I've looked in the documentation library but it didn't show me the options I'm looking for. I found the option underneath the 'Configure' button which allows me to change the ascending or descending order.  If anyone knows more please let me know :) Else I'll make it work with the descending order changes. Thanks in advance for your time. 😀