Product Q&A

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

Hello, I would like to know if there is any way in which when adding data to my excel sheet, the information is also updated within my visualizations in celonis.

Hello All, I have a scenario where i need to calculate the time between one activity and the Previous activity. I have an activity Maintenance Rejected and it can happen once, twice or more than that for a case. Irrespective of the number of occurrences. I should always calculate the time difference between the Maintenance rejected activity and the previous activity. We have only option to take first occurence or last occurence.Is there a possible way to achieve this. Request you to kindly share your expert opinion on this.   Thanks ,Saravanan.G   

Tried using PQLFilter but could not achieve this.

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.

After filtering a bar chart in view, a particular bar broads up, is there any way to keep the size same even after filtering ?

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

Hi Team,  I have a project on which we are supposed to connect Celonis with JIRA.  In help document https://docs.celonis.com/en/jira-connection.html it says we should use "Enter the name of the new Jira Data Connection." but we do not have such connector (see screenshot).  Is there any connector which could be used for JIRA connection? Thanks,Satoshi

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?

Hello everyone,currently I am trying to calculate the KPI for the number that an activity is occuring overall.I tried this formula:COUNT(CASE WHEN Activity_Table.Activity_Column = Selected_Activity THEN 1 ELSE 0 END)Obviously it did not work. It gives me the result of all my activities/rows from the whole table.I actually do not get why it does not work.I am very grateful for helpKind regardsMatthias

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.

Hey Celopeers Community, We have created an Action Flow to send emails out to external customers. The testing works fine for an amount of Emails around 350. The moment we go above the number of 500 Emails, the Action Flow fails (even when the run time is below 40min) or not all Emails are sent out properly.Have any of you had that problem already? It would be great if you could share how you solved it or if you implemented a work around. Thanks in advance.Cheers, Lisa

What is difference between process explorer and variant explorer. How can we analyze process and variant explorer and give solutions to business users

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.

We have form set-up where the user can enter multiple input fields. Ones the form get submitted via a button component we want to tigger an automation, which automates multiple actions. Along the automation there could be multiple reasons why it's failing. Goal is to expose to the user once the form was submitted if the automation was successful or not. If it was not success due to some predefined business criteria e.g. "exceeded a limit" we want to expose this to the end user. What is the best way to do that?

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