General Product Q&A

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)

Hi, I need to create a table with the infos related to activities linked to a given activity.It's like a Process Explorer but in table form, where the user selects an activity and the table provides infos (name and other columns) related to the activities linked to the selected one. Is there a PQL statement that allows me to do so?

For Power BI, I've failed to find any information about how to do it.

How can we get access to Training Analytics Tab in Celonis?

How can I schedule a Action Flow?

In the Celonis Academy training environment, there is no configuration screen for scheduling event triggers. Is it possible to check in the training environment?

@Vildan Aslan​ @emre.karad​ 

Hello Celopeers, I have built KPI dashboards and doing some analysis on process explorer. Manually going through analysis. Heard Process AI will automatically detects deviations and find root causes.  Need to deep drive. if any one knows the link from learning portal pls suggest.   

I have multiple values (20 of them) for example orders which I need to insert into filter, but after entering and confirming it, the filter is not applied. I tried to even change format in excel to number before, but still not working.

hi all, Now I'm trying to update data connector and dashboard to latest version.(I found some difference between my celonis version and latest O2C asset.) In one time upload case, do I need to create celonis at first: I mean, add data connector, upload data and add dashboard? or do we have a way to add something patch to my old celonis environment? Thanks and regards, 

Basics of Process Mining

Hello, I have an activity "OCH_Activities". "Source_Queue_TXT" and "OCH_Activities". "Target_Queue_TXT".I want if source and target are the same, that I get the value 1 for example.I have already tried COUNT( CASE WHEN "OCH_Activities". "Source_Queue_TXT" = "OCH_Activities". "Target_Queue_TXT" THEN 1 ELSE 0 END)but this does not compare the two activities. What would be the correct approach here.Thanks

I have a category table, table2 and Activity tablerelation is category(N) - table2(1) - Activity(N)in a bar chart, I want to show group from category table and count of activities for each group. I’m getting no common table error while configuring a component.how to fix this for a relationship N:1:N 

I’m using Knowledge models & Views for this requirement.I’m trying to create use the option as shown in the attached image file.I’m able to add onClick to the Kpi list component in view,but not understanding how this can be used to update a different component.Thank you

Hi all, I am looking into the possibility of loading data permissions from tables.But reading the documentation (here), I have a couple of questions. Do I need to first load an excel spreadsheet with my permissions in the data model, to create a "permission table", is that correct ? How does it work when you manage the data access using groups ? Instead of a column with emails, I just have a column with the group names ? Regarding the unlimited access, you just need to create a column called "unlimited" with the value Yes/No, is that correct ? Over time, if I update the data permissions (new, delete, or update), do I just need to re-upload my file in the data model to refresh the data permissions ? or do I need to do something extra ? Any experience you could share would be much appreaciated. Thanks 

In an OLAP Table, I have as Dimension a tracking number to UPS. Is it possible to add a Link from each row of the OLAP Table that would take me to the UPS site and track that specific Tracker ID?

I would like to write KPIs back to a SQL server. Currently we only have 13 months of data in Celonis and it would be helpful to compare current KPIs with older ones. Is it possible to write back to a SQL server and if so what methods have you used to do this?

According to requirement we have tried special character to identify but unable to add ' and % in celonis. The syntax which we have used is CASE WHEN("TABLE NAME"."COLUMN NAME") IN_LIKE ('!','@','#','$','^','*','(',')','- ','_','+','=','{','}','[',']','|','/',':',';','"','<','>',',','.','?') THEN 'CLEANSE' ELSE 'PERFECT' when we are adding ' and % two characters output is getting changed. For identifying the correct email address we have got this syntax IF(match_regex($email, '[a-zA-Z0-9_\\-]+@([a-zA-Z0-9_\\-]+\\.)+(com|org|edu|nz|au)', null))but its not working.

HiDear Experts, I want filtering about Case Erruption Ratio (Case/Global Case) like thisratio = count("table"."ID")/global(count("table"."ID") ​so I'm use component filter FILTER ( count("table"."ID")/global(count("table"."ID") ) > 0.01 ​but celonis say "COUNT(DISTINCT "Pizza_Event_Pizzeria_Event"."_CASE_KEY") /global (COUNT(DISTINCT "Pizza_Event_Pizzeria_Event"."_CASE_KEY"))"​To solve it, I tried to count the number of Caseids and Globals (caseids) with pu_count, pu_count_distinct but it didn't work. Can you tell me how to do it?​