General Product Q&A

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).

Using action flow can we directly get the data from data pool without using data model

I see the word custom process in Celonis Academy, what is a custom process? For example, is importing the add-on SAP into Celonis a custom process?

Hi Celopeers, Can anyone help with a filter function to select all cases in a 12 month period leading up to a specific date? So like all cases in the 12 months to 30th April 2023?

I want to create an ABAP report to extract data, where do I start?

XES file upload in Celonis Free Plan doesn't load. File upload works, but the step 2 (configure-activity-columns) doesn't load the screen. Data set I'm trying to use is: https://data.4tu.nl/articles/_/12716513/1 I have set the limit of the space to 20Gb, so this should be enough.

Hi. In views, when designing a benchmark tab, I want to link both the PE and KPI lists to the chosen dimension.I select a dimension in a first dropdown (eg. Company Code) , then select the different company codes I'm trying to compare (in a different pair of dropdowns), but these components (Process Explorer, KPIs, etc..) do not update. In analysis I'd need to create a component filter, but how to proceed working on views?

Is there any best way to identify unused tables and fields from knowledge Models/ Data Models

I am trying to combine multiple KPIs into a CSV, but it doesn't seem to work.Each KPI has different filter so I'm using several Celonis modules to separately get those KPIs. Please refer to the screenshot below. I had the following two problems:(1) The third Celonis module appears to be running repeatedly many times. So I had to stop the Action Flow manually.(2) The CSV file also has a very large number of rows than expected. Multiple rows of the same Company appear. Originally, one company with one row is expected.  Is there any method to combine multiple KPIs with different filters into a CSV?Should I use Iterator/Aggregator to combine those modules? Yours,Chen

What do I have to do to copy the data pool?

I want to create a filter of an ELSE inside my condition. The   ELSE 'Área Não Aderente'. Below script. I want to bring only the data from this ELSE, which would be the opposite of my condition below.  CASE WHEN       ("EKKO"."BSART" LIKE 'Y%' OR "EKKO"."BSART" LIKE 'PE' OR ("EKKO"."BSART" LIKE 'Z%' AND "EKKO"."BSART" NOT IN ('ZCG','ZPM', 'ZCAT')))    AND     ("EKKO"."EKGRP" LIKE 'I%' OR "EKKO"."EKGRP" IN_LIKE ('%1I','%2I','%3I','%4I','%5I','%6I','%7I','%8I','%9I') OR "EKKO"."EKGRP" LIKE 'A%' OR "EKKO"."EKGRP" LIKE '01A')        THEN -- Pedido por Área     CASE WHEN         PU_COUNT("EKKO", "EKPO"."MATNR", "EKPO"."MATNR" IN_LIKE (

I need to filter documents by taking the current month. Ex.: Filter documents from the year 2023 taking the month of MAY(Current)