Product Q&A

Hi,I am a beginner in Python. But I have intermediate skill in Celonis Data Engineering / Analysis / Knowledge Model.I would like to start with PyCelonis. Can anybody guide me like where to start and slolwy how to load a file / update a file/copy data and then go to advanced level in Python/ PyCelonis. Can anyone please help me on this?

Hi,is there a way to combine a PU Function with a CALC_CROP Function? CASE WHEN PROCESS # 'Change Requested Delivery Date' THENTO_TIMESTAMP ( PU_FIRST ( "VBAP" , "_CEL_O2C_ACTIVITIES"."CHANGED_TO" , "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" = 'Change Confirmed Delivery Date'), 'YYYYMMDD' )ELSE"VBEP"."EDATU"END This is the formula without CALC_CROP. But doing this, Celonis is looking at the first "Change Confirmed Delivery Date".I would like to look at the first "Change Confirmed Delivery Date" Event after the last "Change Requested Delivery Date" Event.

We have requested (Niels Deckers) a new project so that we can start analyzing a customer journey for our customer. Can you give an update about the status? Our customer is waiting for the results.

I am a manager @deloitte Greece and we are working on an offering for task mining for a bank and would like to propose Celonis. Any partnership doc? Any licensing scheme and reselling model? Thank you

Hi Celopeers Team, I have a profile view with a comment component, I need to creat an Action Flow that sent to the user especific data more de comments that there are. Does anyone know how I can read the data in the comments of an action flow? Thanks 😉

Hi,I'm extracting data from SAP ECC, but when I try to pseudonymize fields from tables I receive an error of aborted operation from SAP system, with log "Error: Error during Hash calculation for value 100"Someone please know why? Thank you!

Hello! Among my data I have records with four possible values in the column Class ('Inactive', 'Proc Manage', 'non-Proc Manage' and '-'). The last option occurs when there is no value for the record inside Class column.  Although without filtering I can see records with all values of Class listed above, trying to filter as in the picture, I can't get them (I receive only Inactive ones, my goal is to get empty ones also). If I want to get for example only those where Class = 'Inactive', it's easy, but what about the requirement to filter only records with no value for Class column? I don't know how to do it in a table, and inside Action Flows filtering as well. My intuitive code inside Action Flow is FILTER "MyTable"."CLASS" IS NULL , but unfortunately, there is no result. Do you have any idea how to solve this issue? I will be grateful for your support.

What are the differences bewteen Celonis EMS and Celonis SNAP+ versions?

Hi guys, is it possible to display a view variable as a column in a table within the same view? The value of the view variable will be updated by a input box in the same view. Thanks in advance.

Hi - pl suggest I can one create documentation of all analysis one have bulit in Celonis. Documentation should include data sources used (incl tables, fields and thier structures), queries/calculations used, preseptation (i.e. OLAP table, matrix, filters)

We want to make an alert within an inputbox that is related to an action (view) that leads to an increased attribute indicating that it has exceeded a maximum number of characters. Do you know how to achieve this?

Ex: 12345 Stage1 Task1 Timestamp12345 Stage1 Task2 Timestamp12345 Stage2 Task1 Timestamp12345 Stage3 Task1 Timestamp12345 Stage1 Task1 Timestamp12345 Stage3 Task2 Timestamp Note: Activity->stage 

Need some guidance no how to create a Process Flow with Multiple level. One at Top level view and 2nd at Granular/Drilldown view. E.g. one Stage can have multiple Tasks and the cardinality between Stage and Task is Many-To-Many. The Processflow should show the Stage-wise flow and if we drilldown the Stage it should show the Task-wise flow.

Is there a possibility of collating data from different data pools so that a dashboard can be built for task mining which will then enable us to see how many users have installed task mining and analyze the captured data which is residing in separate data pools for each teams?

I have two data pools.(A) One data pool extracts P2P data from an SAP system. This connection is shared.(B) The other data pool uses the first data pool as a connection. The tables are synchronized. After extracting the table EINE in A, it is not automatically updated in B (see screenshots).The documentation states that it should be done automatically "If new rows are added to the tables and views of the exported Data Connection, the data will be available automatically in the importing Data Pools" https://docs.celonis.com/en/transfer-data-between-data-pools.htmlIt seems that there is a routine which updates the table in B at a certain moment. But I do not know how to control/trigger this.

Has someone recently built a button that filters the dashboard on TODAY() in Studio (Analysis)? I guess you need to write a variable and link it to a button, but I am struggling to make it work. Thank you.

If YES, please help us on this

Hi All, Can we add display rules to other column on the basis of one column? I have a requirement wherein I need to show background color to entire row.

I have 2 dropdowns contains month and week details.When I select any month from dropdown1 the respective weeks are clickable and rest all are greyed out.Instead of greying out how to hide the week values based on the month selection

Hi, I want to create a table where I show my timestamp in 15 minute intervals, i.e. 9:00, 9:15, 9:30, 9:45 etc. Can anyone assist me with a script? Thank you

Hi,we would like to connect our Jira project to Celonis with API.  we couldn't find a standard connector so we've created a New Extractor with Extractor Builder using REST APIs calls. For autentication we used API token as specified in the documentation. The connetion tests run succesfully but, when we try to Build the response we have this error message:"Cannot get samples from source system: Unable to read the response"  Can anyone help us to solve the problem ? Thanks for you time.Giulia 

Hi, Any one can please help with Conformance Analysis Use Case deployment - approach & benefits.

During Uploading File Import was successful but I am not able to get this step "When you've imported a file or file archive, its contents are available as a table in the Data Pool, which you can use in Data Models. The table has the name you gave it "

Transformation Center - I am trying to write a KPI in Transformation Center to monitor when "EBAN"."MATNR" (Material Number is Missing in Purchase Req) Can anyone provide some guidance

Hi everyone, I am working on a action flow that has a custom webhook(not from celonis) that needs to be ran whenever we press a button, the button is a skill where I send webhook requests to the action flow, the problem is, the module webhook has an interval of 1 minute, which is not ignored when I run the skill, I would like to know if there´s a way to run the skill and have the action flow running as well, without waiting. I need the schedule because I have another action flow running before it.