Product Q&A

I would like to know how is the Celonis certification exam structured. Are there multiple choice question, case studies etc? Are these centered around the courses we undergo on the Celonis Academy or do they test knowledge application based on the course?

Hi Celopeers, Currently, we are facing the challenge of being able to extract metadata from excel, word, PPT files in order to mine the general activities performed in these applications and include them in an eventlog, for example the activities: open document, update document. For the moment we do not want to go to the level of detail of knowing what was done specifically in the document (which would mean a task mining use case). With this premise, I would like to ask you if you have had a similar case and what would be the best method to extract this metadata and generate the eventlog? Thanks everyone! -------------------------------------------------------------------------- Actualmente, estamos enfrentando el reto de poder extraer los metadatos de archivos excel, word, PPT para poder minar las actividades generales que se realizan en estas aplicaciones e incluirlas en un eventlog, por ejemplo las actividades: abrir documento, actualizar documento. Por el momento no queremos llegar

Hello everyone. We are trying to connect to the Microsoft Power Automate module in the Action Flows. However it is giving us the following error: "AASDTS900971: No reply address provided.".  We have followed the instruction in this link https://docs.celonis.com/en/microsoft-power-automate--action-flows-.html but I keeps giving us the same error. I have google the error a it says that the problem is the redirect URL. We are using the following URL: "https://auth.redirect.celonis.cloud/oauth/cb/microsoft-smtp-imap” and when we try to access the url it gives us the following:  Does anyone know how to solve this problem?Thank you

If we are using DOMAIN_TABLE in an analysis, the external filters applied (Load script/Sheet level/Component Level) may not work properly in all cases. I could see such cases when DOMAIN_TABLE used, external filters will not work properly. Any thoughts on this or my approach is not correct? Can someone comment on this

Is this function only for activity tables? If so, is there another function I can use to update tables in my data pool?

Hi all, Is there a Sandbox for the EMS system that can be accessed for Partners for understanding more how the system works. And if there is training as *how to use* the EMS system would also nice.  Thx

Can anyone help me with the code for creating CLI profile?

Senior Process Mining Value EngineerGrundfos Location: Zagreb (HR), Indjija (SRB), Bjerringbro (DK), Budapest (HU) (Hybrid or Remote)Description: The role of a process mining value engineer is to identify process improvement and automation opportunities by using process mining techniques, tools and technology. (Check out the full description following the link) Apply here

One of our user has been facing an issue where she can export the data using "export data" option whereas when she selects "export cases" it shows as generated and finished but download doesn't start. Any particular reason for this? Note: In this scenario, the size of the data being retrieved is very small compared to cases from an OLAP table and i have found that her system has only 2gb of storage left. The cases export is roughly 30mb of size(based on the extraction done from my end).

In the training "Add Chart Layers and Context in Views Example" they use the rule mark to add "average of sales by state". I am looking to do the same in one of my views. I would like to be able to add the Median of a KPI to a chart of mine.  What does the PQL for this KPI in the example look like? I get errors of nested aggregation when I try to take the median of my KPI. 

Hello, I have a view that has 2084 rows, but when I use it in a Data Model, load the DM and check the details, it says 5772 rows were loaded. As a result, Analysis based on this DM is showing me incorrect data that does not even exist in the DB view. Is this a bug or what is the problem???

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 ?