General Product Q&A

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?​

I am trying to find potential use cases on general accounting and bank reconciliation process/intercompany transactions. Any help on this?

I know want o create an Action Flow that sends an individual Email to each Material Manager (Note that there could be over 50). The Email should contain the following information:If a material of the MM has a negative stock or the stock becomes negative in the future the Email should contain this number togehter with the first date date where this happens and the corresponding stock. If this is true for multipe Material numbers they should all be in one Mail. Examples how the Output should look like are also in the Excel-Attachment. To get the first negative values I tried using fomulas analog to this one because it workes in a view but it does not seem to work in the query-node in the action flow. "PU_FIRST (DOMAIN_TABLE("Material Number"),"Stock","Stock"< 0)" Also I havent found a way how to create individual aggregated email for each Material Manager Does somebody have an idea how to solve this?

I am curious to know “how to objectively evaluate Celonis as a solution” for process analytics and process mining. Is there any best practice / a checklist to assess the long-term viability of using Celonis for each new business use case? I am able to create awareness around the basic differentiations between Data Analytics and Process Mining, but I'm not sure what factors to consider to make a quantitative assessment for wider education and evangelization. Expectation management around the solution should be handled with objectively. Seeking some ideas here from the wider users.

Hello, we are going to make a short presentation (approx. 15 min) of Celonis to our executives (including CEO) who have no previous knowledge. The purpose is to give them a general overview of the potential and the benefits of a partnership. So we need a somewhat short presentation (considering the time will be only 15mins) describing the basic functionalities the benefits we will have as a partner and the impact it will have on the end customer. We are already working on a presentation but we have limited time and we don't want to leave something important outside. So is there any existing presentation of Celonis used in such cases. P.S. I don't know if this is the right place for this question, in any case thank you in advance. Best, Thymios

I need to add aaranyi@schema31.it and I need to remove fgiannuzzi@schema31.it ThxS

How is the membership to 'my team' arranged in Celopeers? Background: We have several users in Celopeers, belonging to a Celonis EMS-team, but cannot view cases created by the colleagues.

Hello everyone, are there any advanced use cases (Material management, P2P-Cockpit, whatever, ...) where one can simply see advanced PQL-functions in action? (For free)I am struggling with advanced PQL-Functions (Nested PU-and BIND-Functions, Domain_Tables, ...) and the learning curve is quite harsh without any actual real world help and examples. Especially Material Flow Management. Like e.g. Analysises about current stock, stock evaluation (future arriving orders vs future used material), stock over time (Stock + Arrived orders - Reserved material for production) etc. The idea behind such things is in my head. But the actual functions to combine the data accross multiple tables is still really advanced.  I´d love to see some examples somewhere. I dont know if Celonis provides something like that? I feel like a lot of stuff is kind of behind paywalls (Consulting firms).