Welcome to the Celonis Community
Hi all,I would like to know wheather celonis data job task have following features or not. 1. Code history feature to compare old to new code.2. Export all SQL on data job task, if #1 doesn't exist I'd like to store my SQL on my local.Thanks and regards :)
For example to calculate the share of items for each region. If I have an OLAP with all regions, I need to have the total number of items divided by the items for the region, but I want to have the total number dynamic to not update the total number manually.So the same output over all rows. Does someone knows how to do it?
Imagine an activity table like this: Case 1 - Activity A - 1PMCase 1 - Activity B - 2PMCase 1 - Activity C - 3PMCase 1 - Activity D - 4 PM I want to aggregate on another column. I am using OLAP Table and my KPI is: Name: count of cases when Activity C happens < 2 hours from Activity B Formula:SUM(CASE WHENHOURS_BETWEEN(PU_FIRST(Cases,Eventtime,Activity=Activity B),PU_FIRST(Cases,Eventtime,Activity=Activity C)) < 2THEN 1ELSE 0END) When I run this against a list of all cases, I get the right answer 1, but when I aggregate it, I'm getting 4. I thought this would only evaluate once per case... is that incorrect? Thanks,Matt
Sum(CASE WHEN "ActivityTable"."Activity" = 'something' THEN 1.0 ELSE NULL END) gives me the count when there is an entry "something" in the table.My challange is following: I need to count Distinct Case_ID, whenever "something" happens. It can happen more than 1 time for an Case_ID, so i need a PQL statement like:CASE WHEN "ActivityTable"."Activity" = 'something' THEN count (Distinct(Case_ID) ELSE NULL END, which is ofcourse not working like this. Ideas and solutions are welcome. Thanks a lot
Hi all,I'd like to know where can I find prerequisites to use celoinis template in market place, which SAP table is required to use it, for example.should I need to check all SQLs or data connections to know it or do we have something Excel list to know it?
Hi all,I have a problem about how to write PQL, please check following conditions and please let me know how to write it.My process flow like thisProcess start(some activities here)work startwork start of A taskwork start of B taskwork start of C task(some activities here)Process endand what I concern is #3 workstart, that has some branch and it might be in no particular order and combination is exist, so it might move 3-1 to 3-3 or 3-2 to 3-1, and I would like to get firstest work start time of work start. So I think it might be work if I can filter in specific activity name, then sort the date ascending and select distinct of its value but I don't know how to do it in PQL. Can anybody let me know how to do it?
Hi Expert, Does anybody know how to export data model technical document as same as dashboard? I just would like to share how to connecting SAP add-on table to business side but there I don't found any connection export way other than json. (business side don't know tech except SAP so I need something natural language one is better.) Do we have something way to export data model?
Dear Celopeer Hi. I would like to build a Concur Connection and extract data via the Concur API, but I couldn't find a Concur Connector (I think there used to be one, as described in this document SAP Concur Connection [Extractor Builder] (celonis.com)).Does anyone know how to connect to Concur via API?
Trying to find a transformation tasks where a particular table is used, right now going through each and every task its very time consuming effort.
Hi everyone,I am pretty new to Action Flows and currently I am trying to trigger an Action Flow by clicking a button in one of my analyses. Is this technically even possible? I couldn't find any fitting trigger modules in my Action FLow instance. Thanks in advanceFynn
How to calculate automation rate in PQL?
How to find number of rework activities with PQL?
Lets imagine I have a line graph. My KPI is order count. My dimension is the months of the year whose data comes from Table A's column B. So my dimension is ROUND_MONTH("A"."B") Which filter I need to add to see only the last month?
I'm trying to upload a file on Celonis, but i'm not being able to and when I try, the following message appears: I don't understand. What are the illegal characters in the target? Why can't I upload the file?
Have you ever used EKKO as a case table? What is the EKKO's activity table ?
Both the functions are used to retrieve rework, what is the difference ?
Hello, I'm attempting to create a data connection via .xlsx file on my computer. I created a space and then made the data pool connection alias. However, once i select "Connect to Data Source" and successfully connect my data, it does not proceed to make the connection. Can you please help and or instruct me on the correct method to complete the next steps? (See images below) Once I selected Esc, the remains equivalent to image one, any help is greatly appreciated. Thanks!!
How to change the activity order?
Hello, I am using the Query Data module in an Action Flow. The output of the various date fields appears as below - instead of a regular date format like YYYY-MM-DD. How can I change the output of the column in Query Data?
What does dotted line means in the Process explorer?
Dear Experts , We wanted to understand the possibility of integrating Celonis EMS platform with third party BPM application like ARIS Connect to transfer discovered BPMN model from Celonis EMS to ARIS BPM application. Thanks in Advance. Regards,Navalan Veerapandian
Hi team, Is there a way to make Pareto charts in Analysis or Views ?It does not appear to be off the shelf, just wondering if someone managed to build one. It is a quite comon tool used in the process improvement field. Thanks
What is the difference between an eventlog and digital footprint?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
