Product Q&A

Hi all,​I would like to create heatmap (or data to create it) by Celonis. Does anybody know how to do that? my image is in below link and its X-axis is 00:00:00 to 23:59:59(and if I can change it to monthly or yearly is more better) and Y-axis is activity to know when is the activity occurred. ​image sample https://reelyactive.github.io/diy/kibana-heatmap-space-time/ Thank,

Hi Team, A year back i completed certifications on solutonal and implimentational professional.Now my certifications got expired and now i want renew them. But could not find the same. I also wnated to do other certifications based data engineer and business analyst. Could any one help me in getting new link for doing celonis certifications

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 have a complex knowledge model (customized AR knowledge model from the marketplace) which has several KPIs pre-defined. I want to make an action flow using one of these KPIs with the query data module. The issue is that I cannot reference the KPI like KPI("KPI_INVOICE_CALC_PAID_ON_TIME_RATE") in the AF and since the original KPI formula is also referencing other KPIs it is not possible to get the raw code and insert that instead. Is there any workaround to easily use KPIs in action flow that are defined in the knowledge model? Thank you for your help!Balázs

Dear all, is there a way to include the selected filter criteria when exporting data to xlsx or CSV? Thank you and kind regards, Michaela

I am doing Accounts Payable Case Study ( Celonis DB and CASESTUDY schema). It looks like the CPUTM column in BKPF and UTIME column in CDHDR tables are not correct. When I load the activities in Process Explorer, flow goes in all directions. Please help.Data in the CPUTM column in BKPF and UTIME column in CDHDR tables are '11/13/2018'. So the flow seems to be incorrect. Please clarify. Thanks!

I would like to add a column to the OLAP table that lists the number of processes that go through a particular activity and the number of processes that do not go through a particular activity. How do I code a PQL that calculates the number of processes that go through a particular activity A?

how can i apply for Celonis partnership and what are the minimum requirements please?

I would like to count if the same activity occurs more than 2 times, how many times in total did it occur?

How can we use celonis to solve the issue of a user getting access without proper approval leading to security incidents rising

Hi, I just want to confirm from where our clients log in when they view their dashboards? Do they register for C4C or from where to they log in?

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?

I would like to define a custom transition in my Multi Event Log. Currently interleaved and Non-interleaved can be used. But there is a perfect PQL function TRANSIT_COLUMN.My question: how can be Match miner transition set in Studio Process Explorer? 

Have you ever used EKKO as a case table? What is the EKKO's activity table ?

I need to check for a value (eg. 'COMPLETED') of a table column from Celonis transformation. The action flow needs to check for the status of the column like every 15 minutes and once it finds the 'COMPLETED' status, the Celonis action module needs to execute the corresponding data model. Appreciate the ideas/logic.

I would like to create an OLAP table containing the following KPIs.Could you please provide me with the formulas for the following four PQLs? Number of cases passing through a particular activityNumber of cases that do not pass a specific activityThe number of cases coming from a specific activity to a specific activityThe number of cases that go from a specific activity to a specific activity

2. FTE in Cash Payment involved in the process - when I am adding the FTE as per the estimated weekly workload the tool gives an error and on putting a value of FTE much more significant than that there is no error.  What does Simulation duration denote? On adding the Simulation duration of 400 Days, the simulation runs for 800 cases while the total number of cases is only 100. Can you explain this? Please find the attached screenshots for the same.

Hello i'm looking for the replay of the ABB x Celonis Webinar. could you please help Regards

Hello, i trying to check if a item on a delivery note was created manually or by a bot. however my lips table is not retrieving data from deliveries that are not LF (final product) or LR(Returns) leaving out in house transfers that appear on SAP.

My organization is currently using Power BI and some reports are on Power BI and some are on Celonis as well (I know it is not a good idea to use Celonis for only simple reporting purpose). So I am planning to propose …to make PowerBI the face for reporting requirements and Celonis for Use case building (even use case dashboards can also be moved to PowerBI) Before I propose, I wanted to get some confirmation/clarification:1)     Will the data on PowerBI be real time? or PowerBi will again need scheduling data pull?2)    Will PowerBI hold data or it will remain on Celonis cloud only and used by PowerBI directly?3)    If Data is on Celonis cloud, what will be the impact on performance (since data will be queried from Celonis)?

I have to integrate Celonis and BPM tool so that i can do conformance analysis seamlessly . Please advise ?

How to remove filters from button dropdown menu (load entries)? I created a button dropdown menu with load entries. When I select one value in the dropdown menu, there is no option to simply remove the filter and show all the values again.

Is there a simple way of triggering a Python script within an Action Flow?

Hello all, is there a way to install the R package tidyvers in the ML Workbench. I have tried two possibilities which unfortunately run into an error (see screenshots). Thanks for your answers in advance. With kind regards  Christoph In R on ML Workbench In Py on ML Workbench 

Both the functions are used to retrieve rework, what is the difference ?