Product Q&A

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 

Hi All,  I have an interesting requirement, where i need to find the data type of the column (table field) in PQL.  Ex : Implementation is done in Views and knowledge model:  Case_Key = 400100200300,400A00200400Variable ${CK} = Case_Key  Requirement ==> Case when ${CK}= String then ${CK} else to_String(${CK}) END Any insights on this would be much appreciated. TIA!

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?

How often you are facing issues with Celonis Action Engine usecases like AP Invoice Duplicate Checker, When user is clicking on action button screen is getting blurred without any error and action is not getting performed.

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 All,   I want to use pycelonis to get all version of data pool (including Draft if present) The below code does not not show data pool version    data_pool = celonis.pools.find("XXXXXXXXXXXXXXXX) print (data_pool)  Output: <Pool, id XXXXXXXXXXXXXXXX, name 000_Extraction (000_CELONIS_DATA)>   Is there any way i could get the data pool versions? 

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

Dear Experts , is there a way to selectively give users to only specific Space and packages but disabling others ?

Please, is there possibility to move activity node to another position ? I have layout under flow diagram and I want to place node directly at the point of resource.

Hallo,I would like to query data stored within the Transformation Center.How are the table names i have to query? Is there a list of those somewhere available? KRAlex

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?

Dear Experts , I used smart sensor and create task functionality to create 3 Skill objects. Initially before running this duplicated task name as "Missclassified Assets" in all the 3 skills and hence in Inbox task appears same , even though contents are different. Now i have updated the task name by changing it inside task settings , but still its not getting updated. Kindly help me with your advise ? Attached reference snapshot for you

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

HI Community, is there a way to migrate Analysis from CPM4.6 to the IBC without pycelonis (at least without pulling from the environment)? The problem is, that we do not have a way to connect to the OnPremis Environment via python. So it would be nice if there was a way to use e.g. a Transport-File (.ctp) which can be uploaded to the IBC, or at least used with pycelonis from an external server? Help would be greatly appreciated. Thank you Best Max

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.