General Product Q&A

Hi all, I'd like to show something supplimentaly stable data via OLAP table that is not tied with my data model, for example last year sales, can I upload manually? or I must create data with number component? I just want to temporary upload my Excel data to OLAP table to compare with my celonis dash board in one screen.

I am using the function DATEDIFF in the dashboard in order to retreive the time elapsed between the creation of an order and the MAX time in the system.To to this I store this last datetime in a variable, and I use it between quotes in the DATEDIFF function. I can't use this workaround in Action Flow, hence it's giving me the following error: The operation failed with an error. 400: Wrong arguments for DATEDIFF: The aggregation function MAX cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs. I've tried to store it as variable using the Set Variable tool, but differently from the analysis it doesn't directly retreive the value of the formula (in order to avoid the error above), but instead he just puts the formula inside the query data where I have the DATEDIFF. How can I work this out? Thanks

I saw an Evenlog automerge switch default setting off when I was in Process Data Models to link tables. What is this switch for? What happens if I switch it on? Please advise. Thank you!

Hi everyone, is there a problem with the Sandbox at the moment? If I execute my SQL-Script in the data job, I receive an error message due the tables are not loaded in the schema explorer.  Does anyone have the same issue or any advice? 

Hi, I have a project on which we are supposed to connect Celonis with JIRA with API. In resource section /help/display/CIBC/Jira+Connection it says we should use "Enter the name of the new Jira Data Connection." but we do not have such connector (see screenshot). So, I suppose we need to use Extractor Builder where we can build Extractor for REST APIs calls.I received JIRA url and private key but am not sure how to proceed. When I choose authentication method OAuth2, it requests for client ID and client secret,when I choose API key, I paste URL and private key, but got error message:"Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Request failed with response code: 404 response body: Oops, you've found a dead link. - JIRA" Is there something I am missing in extractor (some other authentication used for private key?) or is there any conne

Hi, is there a free trial version for Celonis EMS to install locally rather than a cloud instance of Celonis EMS ?

Error:onnection test failed, please check the Data Connection's configuration and ensure that the system is running: Unexpected error when creating database connection: Cannot create PoolableConnectionFactory (Login failed for user 'Training_CelonisDataEngnieer'. ClientConnectionId:d8366093-8a42-4b38-a7a0-043660558f92)

We are trying to use a treemap which has a color mapping that uses a classification PQL instead of the case's quantity.  Has anyone faced this challenge? Is there a way to modify the color based on a classification? In advance, I appreciate your kindly help.    

Hello,  Recently I wanted to present some data in a form of interactive map generated in Python and include that into html site. I had an idea that if I cannot insert that as any other component, I could try to use Iframe to just place that in the business view.  I've tried to do with my own private domain and it look promising, however much better would be just running local webserver in ML workbench and seeing that.  Here's the code snippet used from internet: I've also check if the site is really accessible in the ML workbench with Curl tool - I can see whole html code. Unfortunately when inserting that URL as src in Iframe component I can't get any data: 

Hi expert,​I have a question about Celonis Analytics and View in what case I'm better to use view.I have already understand below post and understand basic difference however I don't think there is dicisive difference between each other... Does anybody explain what business case I need to use view and analytics properly? ​https://www.celopeers.com/s/question/0D50700000GC71TCAT/what-is-the-basic-difference-between-view-and-analysis-in-studio?language=en_US Thanks in advance,

About process maning

Hi Celopeers, Any brief notes on below would help. ITSM Process - AI/ML based Solutions for :- 1. Multihops / Reassignments. 2. Overall Queue Management ( Rework Inside Teams ). 3. Any other plethora of use cases involving AI/ML :).

I know, this question seems odd at first. I finished modelling and I have big transparency on the process now. I can start analysing using the dashboard. Its just - where to begin?Do I check for Cases, that are not happy path?Do I start improving the happy path runtime by looking for bottlenecks?Should I check which variables influence the propability for the instance to flow in the happy path? I know - generally Process Mining seems to be about discovery. Howevery I want to spend my time efficiently, so I am looking for best Practices, frameworks etc. Am happy for responses and ideas. :-) 

Greetings,is it possible to display parallel processes from 2 event logs in one process explorer in a analysis? Similar to how it works with transitions in the View.

Hi All, Im doing the Get Data into EMS training and I could not find the 'Accounts Payable on SAP' Connector in Marketplace. I tried downloading the Get Data into EMS - P2P instead however status says "Extractor not reachable". Hope you can help. TY

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?