Product Q&A

Is it possible to connect multiple sources into one process ,with different type of sources (ARIBA +SAP ECC , Success factor + SAP ECC, MS-SQL + SAP ECC) ?

I know it might seem simple question but i am struggling with uploading BPMN file for my conformance sheet. can anybody tell where and how to upload it ?

I would like to have the green start where the blue stop (Stacked graph)- how can I do that? 

I want to know who is my Partner Manager Urgently: Thanks gabriel.cifuentes@cliptecnologia.com

Hi,  I wanted to implement the open target quantity in celonis. Therefore I used the RUNNING_TOTAL function to add up the quantities as shown in the screenshot. After, I wanted to subtract the RUNNING_TOTAL from the target quantity, the code for this looks like that: "CONTRACT_INFO"."KTMNG" - RUNNING_TOTAL("EKPO"."MENGE") That constantly gives me the following error:  The running aggregation function RUNNING_TOTAL cannot be used together with a dimension function input. Please check that there are no moving aggregations and dimensions used together as function inputs. Even if I try to use e.g. AVG(), SUM(), LAST() in front of "CONTRACT_INFO"."KTMNG" , it's not working. Only if I use RUNNING_TOTAL() in front of "CONTRACT_INFO"."KTMNG" it's working, but obviously this is giving me wrong results. Thanks for your help.

I have add the action send an email for the enhanced view for a table but when i select the button to execute the action it is giving me a pop up. Any way to resolve it

In extraction I want to change data type of a column from text to timestamp. Format of data is 2022-10-27 07:27:19.01 +00:00. Now I want to change it to timestamp and enter format for it in extractions. What format will be accepted there. 

Can i change my name after completing training track and get certificate with the changed name?

@Sophia Stephenson​ @Brian Dees​ 

Hi Everyone, I'm trying to create a dropdown in legacy views, it should work as filter if I select value from the dropdown and it should update the variables too.

Schedule transformations for individual perspectives for object-centric process mining (2024-05-07) This is a Limited Availability functionality. Instead of running the complete OCPM data job to create objects and events for all your enabled processes, you can now set up schedules to run the transformations for one perspective at a time (or more than one if you want). This feature is currently in Limited Availability - if you'd like to try it out now, open a Service Desk ticket to request it. We're planning to have it in General Availability soon. When you run the OCPM data job through a schedule where you've selected perspectives, we'll identify all the objects and events that are part of those perspectives. Then we’ll run only the transformations that are needed to create those objects and events from your source system data. You can create dedicated schedules for the Celonis-supplied perspectives for the Celonis catalog processes, and also for your custom perspective

Hi team, I am working on creating a profile view, for which the identifier in record is required. As DISTINCT and usage of two tables is restricted while creating an identifier, I am using PU_FIRST and using same table and column in target and source.  I am able to make records unique, but I am facing problem when I am adding KPIs for this profile view dimension. It looks like it is showing duplicates. Can someone please let me know why this approach is not right and any alternative solution for the same ?

I registered a few days ago for c4c and have not heard anything since. Just to be sure, how long does it normally take until I have been vetted? (I still have enough to do in the Academy but it would be nice to know a timeframe) Thx Mark

 Hello, Actually I have passed 3 out of 4 sections in my first attempt itself but I failed in one section which is Section 2: Process Mining Fundamentals. For this section I failed in my first 2 attempts. So now I want to give it try but I am unable to. So, the instruction say that we have 4 attempts in total. First two and then 2 days cool-off and again last 2 attempts. So now it's been more than 2 days since my last 2 failed attempts but still I haven't got my last 2 attempts, it's saying 0 attempt left.

Hello, Actually I have passed 3 out of 4 sections in my first attempt itself but I failed in one section which is Section 2: Process Mining Fundamentals. For this section I failed in my first 2 attempts. So now I want to give it try but I am unable to. So, the instruction say that we have 4 attempts in total. First two and then 2 days cool-off and again last 2 attempts. So now it's been more than 2 days since my last 2 failed attempts but still I haven't got my last 2 attempts, it's saying 0 attempt left. So please help me with this.

I did not use my attempts but it is showing 0 attempts remaining What should i do?

Hi all, I'm trying to calculate throughput time between and "activity" and "today" timestamps by excluding Sunday. First, I tried it with using DATEDIFF function like that: DATEDIFF (HH, PU_LAST ("cases", "activities"."event_time" ), MINUTE_NOW()) But in this version, I cannot exclude Sunday as you can see.   Once I tried to do it with CALC_THROUGHPUT function as below: CALC_THROUGHPUT ( FIRST_OCCURRENCE [ 'Order placed' ] TO CASE_END , REMAP_TIMESTAMPS ( "activities"."event_time" , HOURS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY ) ) ) Now, I can only calculate the time until last event timestamps, not until now since I cannot use any DateTime_constant (TODAY, MINUTE_NOW, etc.) in this formula . Do you have any suggestions/solutions for such cases? Many thanks in advance for the answers :)

Hi! i want to integrate a dynamic pareto front to scatter plots in my analysis. I want to integrate the pareto front point as red points into the plot. The optimals could change depending on the actual filters of the dashboard. Do you know how to do this?

Your business user needs to investigate how the cases are flowing into undesired activities, in other words, see the predecessor activities. Which of these options would you choose to meet their needs?

Task mining data configuration failures I've recently started learning on the Celonis Academy courses and I'm stuck on the Task Mining sandbox.There is an error in the data configuration, it keeps failing:Uploading paquets from my machine seems to go fine:Yet it is impossible to analyse the recorded and uploaded task mining data, I'm guessing because the data configuration failed?It has been over two hours since my test tasks were recorded and uploaded. Does anyone know what is failing here and how to fix this?

I have read the documentation on the Run ML Notebook Component but I don't know how to publish the results of the notebook back to the Analysis UI. Is there any link to documentation that shows how to publish the results back on the Analysis? Do I need to use pycelonis or other python library?

Good evening,I have consulted the documentation on OnPremise Celonis Extractor Server (https://docs.celonis.com/en/on-premise-extractors.html), but as far as I can see there is guidance only for SAP and servers with JDBC.I would like to implement Celonis Extractor Server directly on a SQL Server without JDBC endpoints, is this possible?Where can I find a guide or documentation?Thanks

Now i want to have this number for Change Price as a single KPI number, my idea was to use the count table for the kpi and a Component filter with 'FILTER PROCESS EQUALS 'Change Price''. But it shows me a much larger number. Can pls anyone help me. Thanks in advance, king regards Louis

This means I want to calculate the throughput from A OR B OR C OR D to X. Is there any way of doing this?