General Product Q&A

Hi , We have a requirement where we want Celonis to automatically pick a XLSX file from a folder, upload the file , create a table and execute a data Job. IS this possible ? How do we accomplish this ?

Hi expert, I have a question about delta load. I know if I use data connection, for example SAP to Celonis, then we can use delta load option. However, in manual data connection pattern, download data from one to upload to celonis, do we have any option to delta data load? If yes, could you guys let me know where I can find technical document of that? Thanks, 

Hi expert,​This is just simple question, does any body know how to add sequential nuber to OLAP table?​Col1 col2 col3 ...1 aaa bbb2 ccc ddd3 eee ffff4 ggg hhhh↑this one.​This is good for discussion because I can say "line #1 and 3 is something wrong.​..."  best regareds,​​

I get an error when I upload a flat file. How can I know in what field is the error ? Execution failed:Data Upload execution 2b523778-12cd-4ed7-bb98-2669b13b079f has failed. Column type error=false. java.lang.RuntimeException: Failed to parse text in CSV. Details omitted. Exception class: java.lang.RuntimeException caused by Failed to parse text in CSV. Details omitted. Exception class: java.lang.RuntimeException. Celonis Support ID: 04902b27-52ef-4b7b-b153-b099c37868fe

I had already integrated a data model in one room. Now I wanted to integrate a new data model. Therefore, I deleted the old data model and inserted the new one. However, the old and not the new data model is still displayed in the studios.

Hi expert,​now I'm creating internal training contents and stucked how to explain what is case table in simple words.I know what is it and how it works but I cannot explain difference between case table and transaction data. Can I say case table is a part of transaction data and case table is just what you wants to see in your analysis board, or is there something add?

Hi, when I try to use "try celonis" in resources, it doesn't recognize my email. How can I get access?

For exmaple: There is a dropdown selection which includes different vendors. I want to create an column chart of the first 5 vendors if no selection of a specific vendor is used. On the other hand if a vendor is selected in a dropdown menu i want to display only that vendor in the said column chart.  Thank you!

So, I'm trying to implement a filter that changes depending on the input of the user. A button dropdown was included to collect the input of the user, said button contains three options which change the value of a dynamic variable, the possible values for this variable are 0, 1 and 2. Lastly, I wish to filter a component depending on the value of said variable. I tried implementing a load script as follows: FILTER DATEDIFF(mm, VBAK.ERDAT, VBAK.MBDAT) CASE WHEN <%=variable%> = 1 THEN >60 WHEN <%=variable%> = 2 THEN <=60 ELSE ENDThis solution does not work. Any help?

Hi, does anyone know the table requirements for an O2C process in TradeCloud? Thank you.

Hello - is anyone aware of a glossary of key terms that Celonis has published? Something that we can share with people who are new to the technology.

I would like to dynamically change the value of Load Script (Analysis settings) using variables. Switching the filter on/off according to one's choice. But, i am not able to achieve it. According to the documentation, variables are not accessible in Load Script. Can anyone suggest how to achieve this.? https://docs.celonis.com/en/load-scripts.html

Dear Sir/Madam, Currently, I'm using the trial account of Celonis Process Mining and Celonis Task Mining. And I'm installing "Celonis Task Mining" and "Celonis Task Mining - Configuration Editor" on my laptop also. I have some questions:s How I can check the information on my trial license? And how long can I use this software on my laptop? Thanks so much.

Our approach was to link BSEG to the VBRK table in the data model through MANDT and VBELN, but we are unsure about this being the best practice. Any recommendations?

Is it possible to trigger an Action Flow as soon as a data model has finished loading? If not is this feature planned because this would be helpful for a lot of use cases.

I wanted to get the extraction logs (like date, info, message). And I wanted to get this data through an API (Pycelonis) so I can post it elsewhere.

I want to create an OLAP Table or a histogram that shows on the distribution Axis/column the case count per linked attribute and on the Occurence Axis/KPI column the number of distinct attributes that are linked to that specific case count. See the attached OLAP Table as example:I want to create a new table that shows in a first column the second column of the attached OLAP Table. In a second column the new OLAP Table should show the occurences of each distinct number of column two from the attached OLAP table. I indicated with the red numbers on the right the occurence count i expect to be seen in the new OLAP Table (in the new OLAP Table the number 11,040 would only be displayed once in the first column and in the second column would be a 2 because two different vendors are linked to that specific case count).  Can you help me? Thanks in advance.

how to password reset

Is there any online training content available on SAP tables? Please recommend a good online course.

Eg: for a column "NAME" one of the value is "HELLO-WELCOMETO-CELONIS" I want this to be split to 3 columns..Intro: HELLOGreeting: WELCOMETOTool: CELONIS​As 3 different columnsCHARINDEX giving error that this function does not support. ​

I have a violation raised in the conformance overview while the violation raised is normally mapped in the process model should not be raised in the process overview. How can I solve this issue ?

Observations:Same sheet takes different time to load for different peopleSame sheet takes different time to load for the same person at different time of the dayInitial hits to the sheet take longer time to load and subsequent hits to the same sheet load faster

Hi,  is it possible ot replace empty cells with dashes (-) in a csv file generated from an Action Flow which is based on Celonis Data? I found a template for Action Flows to generate and csv File with a appropriate format (see below). Unfortunately my data from celonis contains empty values, which bothers me in the csv since they appear empty. I would like to replace them with dashes(-).  Thank you for your help and best regards,Jurgen 

How much time does it take to the support team to change the email account?

Is it possible to capture at what time the delta load started or ends in a table? If yes please help with the approach