General Product Q&A

The following PQL formula is the default for PQL KPI's. Am I correct in understanding that the following only calculates processes that start with a specific activity and cannot be calculated if the flow of a specific activity is included in the middle of a process? KPI("Ratio", PROCESS EQUALS START '' TO ANY TO '' END ) 

Please modify this code,  FILTER MATCH_ACTIVITIES ( "finalResult_0_01"."ACTIVITY" , NODE ['<%=display_code_1%>'] ) = 1; so that it also works with variables similar to display_code_1. I tried  FILTER TO_STRING(MATCH_ACTIVITIES ( "finalResult_0_01"."ACTIVITY" , NODE ['<%=display_code_1%>'] )) LIKE '1%';  this code and also some contains, regex_like etc but Celonis EMS does not recoginze both function. Thank you 

How to identify open invoices from BSEG table in SAP ?

Dear everyone, I want to transfer an analysis into a view. In the analysis I use the formula DIstrinct "MD04"."MATNR" to get all distinct Material Numbers as they can show up multiple times in the table columns. I now wanted to do the same in the view, but get the follwing error:Does anyone know how to solve this? Thank you very much for your time and help! Best Ole

Hi, I have a question related to some quality of life changes in UI.We have two Celonis environments PROD and QA. I know that I can see the env in which I am by looking at URL, but I would like to have some more visual ability to distinguish between the two. Is it possible to change the navigation bar (I believe that what it is called - see the image below) to a different color? Or to make some other change to parts of UI that are always visible in order to have that visual difference at a glance of an eye?Thank you,Karol

Hi, We have two Celonis environments - PROD and QA. The latter one was used at the beginning for some tests of initial implementation of the tool and was left unused for a while now. As a result there is some old useless junk in it.I would like to replicate what we have in PROD (not the data itself as there is not enough space in QA, but the entire Data integration part including ETLs and data models, Studio part with knowledge models, views, analysis and all KPI) to QA so that it could serve its correct purpose.Is it possible to do it in an automated way? Thanks,Karol

Celonis does not seem to have any out of the box user load testing solution. How do we test for future increase in users accessing the use cases? Can we user Apache JMeter or LoadNinja for load testing? Would there be any network security or data security concerns?

Hello, For an analysis I have a KPI with cases per quarter. I also want to have an additional KPI that accumulates the data over time. As the dimension is also time-related, I don't know how to really approach this as the data always seems to be separated per quarter. Any tips how to do this? Thank you!

how can we integrate celonis with SuccessFactors

I have been trying to explore the Business Miner app. I am using the Accounts Payable process with AP case study data model provided in the Celonis Academy. The KPIs like OTP rate, DPO etc. are disabled. Please let us know how we could get these pre-built KPIs enabled within the Business miner against each process, so that we can explore the options. Attached snap for reference.

Hi,before starting to build a real data conncetion to a data source I just wanted to test how to build a data model with flat data so I tried to upload all necessary tables for the P2P process manually. The upload is working but I am not able to configure the files. What can be the problem?

Hi All, Is it possible to deploy the Celonis - process mining in such a way that the data does not leave the client premises. If yes then How?

I want to create a pie chart on the Celonis dashboard that counts the number of values in the columns I have added to the OLAPTable. how do I set the DEMENTION and KPI respectively?

Hello all, im trying to compare the sales between last week and the weekly average of the last 6 weeks in several materials. For this I wrote the following code for the kpi:(material is set as dimension)(there is a component filter that limits the data to the last 6 weeks as well)round ( ( ( 7 * SUM ( "VBAP"."NTGEW" ) / 43 ) / 1000 ) - ( ( SUM ( Case When "VBAP"."ERDAT" > ADD_DAYS ( TODAY ( ) , - 9 ) THEN "VBAP"."NTGEW" else 0 end ) ) / 1000 ) , 2) However, in the OLAP I only want to see the materials where this difference is positive so I tried to do a filter where:FILTER "Material" IN (CASE WHEN "DIfference code above" > 0 THEN MATERIAL ELSE NULL END) But I get an error message saying that I cannot use the SUM aggregator in Filter. Does anyone know how to solve this ?

I need to take the first 8 values of a column to obtain the creation DATE. Then I need to take the remaining values for the TIME. I will then cast them as Date and Time for creating the EVENTTIME. The code below should have worked, but since it is a FLOAT data type I receive an error message on the Output. Code:SELECT ERSDA,ERSDA_TMSTP,SUBSTRING(ERSDA_TMSTP,0,8) AS "INFO1", SUBSTRING(ERSDA_TMSTP,9,4) AS "INFO2" FROM MCH1  Output:Execution error: ERROR: Function catalog.substring(float, int, int) does not exist, or permission is denied for catalog.substring(float, int, int)

How to convert KPI value to constant? Also, this constant should be insensitive to filters.

Hello , I would like to implement a KPI showing the relationship within the element of a dimension (B) for each fixed element of a first dimension A and display it as shown below: A | B | B (again) | KPI X | 2001|  2002 | 5 X | 2001| 2003 | 2 X | 2002| 2001 | 100 X | 2002| 2003 | 2..... Y | 2001| 2002 | 50 Y | 2001| 2003 | 25 Y | 2002| 2002 | 20 Y | 2002|  2003 | 25 ...The aim is to be able to determine for each dimension in A, and a given fixed dimension in B, which other dimension within B is very different in terms of KPI value. Any idea about how to inplement something like this using PQL? Thanks for your help 

Hello everyone,  I am stumbling accross layout problem right now when working with tables in Celonis. I wanted to make a Pivot-table but I need to update the Layouts to see the full name infront... Normal tables have this: While Pivot-tables don´t have any Layoutoptions:  What am I not seeing? This is quite disappointing since I feel like that should be implemented. I need it in this case, since the text is long, and the same until the very end of the text which is not readable. Same for all the other columns who could be way smaller for my taste.  Any way to fix that or does Celonis not support this? If there is no way to do it, can I somehow make Celonis aware of this issue? It seems like something minor, but it should be implemented simply due to the fact that normal tables have it. Thanks!   

what all pre_built connectors available in celonis? Is there SAP Success Factor pre-built connector available in celonis? if not how can we connect with celonis

I am currently creating a Best Practice Celonis EMS with Analyses/Views from different teams. Since I haven't found a way to export loaded data models (data models that already contain the specific data) all my Analyses throw errors.  Exporting Data Pools is possible. I already did that. The problem is that I cannot re-run the Data Jobs in the Data Pool to create a new loaded Data Model because I don't have access to the previously used source data. Any help is appreciated! P.S.: I am also a little bit familiar with the Celonis Data API. Maybe Pycelonis offers some functionalities?

I'd like to better understand the actual manual work involved by executing a certain activity. In my company, there are activities that are executed as "batch jobs". This means that we can execute the same activity across several line items. In this case, even though it only required one manual execution, it's counted as one across several line items adding up to several "manual" activities. To find a better estimate of the actual manual effort for each activity, I'd like to group them by user name, event time, and activity name.  Can anyone help me crack this nut? Thank you in advance for your help!

Hello everyone. I am looking for anyone who might have achieved integration between Celonis and ServiceNow. The documentation provided - in my view - is not clear. What I have achieved so far:Created a user - basic authenticationCreated a custom roleAdded the rest_service, soap_query, custom role to the userCreated the ACL for the sys_db_object and incident table (filtering on the assignment group) and attached the custom role.Successfully connected between celonis and ServiceNow However, I receive the following error message when a full load is executed:  Any insights or help as to what is missing? FYI - i am no Celonis administrator - anything Celonis related tasks, I have someone within my team that is executing those Celonis tasks. Thank you.

 Hey guys, I would like to transform the access user in Celonis (user.celonis@outlook.com) into just the name. Example: User Celonis I looked in the PQL documentation but I couldn't find it.I looked in the PQL documentation but I couldn't find it.

Is there any way to download PDF report on views? ( Action Flow or Skill)