Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4430 Topics
MrAj
Level 3
MrAjLevel 3
posted in Data Ingestion & Infrastructure
How to Trigger a Machine Learning Script from a Button in Celonis?

 Hi everyone,I need help figuring out how to execute a Machine Learning script directly from a button in my Celonis app in views (dashboard). I believe I might need to use Action Flows, but I’m unsure about the exact steps to make this work.Here’s what I want to achieve: When a user clicks a button in the Celonis app, it should trigger an ML script. The script could be hosted externally (e.g., a REST API) or executed within Celonis.( atm its not hosted, there is just a file in ipynb format, stored in ml workbench in  analysis. I need guidance on how to set up the Action Flow and link it to the button. Has anyone implemented something similar? If so, could you share the best approach and any potential challenges I should be aware of?Thank you in advance!

200
MrAj
Level 3
amey.punek12
Level 3
amey.punek12Level 3
asked in Process Analysis
Issue with Skills (Manual Selection)

We have created a OLAP table which we have connected to a skill.In the skill we have created Manual Sensor and enabled the manual selection option but it is not working correctly.In the OLAP table we have also added URL in "Allow Data Service Link" 

50
amey.punek12
Level 3
jonas.hess
Level 3
jonas.hessLevel 3
asked in Process Improvement
Anyone familiar with Skills?

Hello,  id like to create a skill which is triggered on every first of the Month. I Created an kpi like this if Left(Today(),2) = ‘01’ then KPI = 1. So my KPI logic is working fine but, i do not found any way to use this kpi as a trigger for a Smart Sensor. I included the KPI into a Record, but when i try to use this record in smart sensor, it does not show me created attribut with my KPI. Did anyone had a similiar Projekt with triggering Smart Sensor at the first of the Month, and could maybe help me? Kind Regards Jonas

140
jonas.hess
Level 3
MrAj
Level 3
MrAjLevel 3
asked in Data Ingestion & Infrastructure
Configuration Management for Process Flow in Celonis by Gui or flat files

Current State:Our Celonis process mining implementation includes configuration settings for process flow and status updates in our data transformation pipeline Currently, only developers can modify these configurations through SQL queries and code changes End users (procurement specialists/buyers) have no way to modify process flow configurations without technical knowledgeRequirement Question: What is the most effective way to enable non-technical end users to update process flow configurations in Celonis without requiring knowledge of SQL, PQL, YAML, or coding?Specifically:What data format should be used for configuration (CSV, Excel, UI form, etc.)? Where should this configuration be stored in the Celonis architecture? How will the configuration files be uploaded/modified by end users? How can we ensure the uploaded configurations are properly integrated with our data transformation steps?The solution should accommodate users with no programming knowledge while maintaining data inte

90
MrAj
Level 3
Bharath
Level 3
BharathLevel 3
asked in Process Analysis
Process flow analysis

PROCESS FLOWNeed some assistance, I have a CaseID, Activity and Timestamp. I need to get all the cases where the activity flow is A to B to C. (NOTE: the activities don't have to be directly followed by) I cannot use MATCH_PROCESS_REGEX or any other commads. I need to used CASE WHEN, AND, ACTIVITY_LEAD etc... to solve this. Please help me out. My approachCASE WHEN "tab"."Activity" = 'A'AND ACTIVITY_LEAD(CASE WHEN "tab"."Activity" = 'A' THEN "tab"."Activity" END) = 'B' AND ACTIVITY_LEAD(CASE WHEN "tab"."Activity" = 'B' THEN "tab"."Activity" END) = 'C'  THEN CaseIDEND

454
Bharath
Level 3
J
Level 2
josh.bozziLevel 2
asked in General Product Q&A
Cropping the Process Explorer using a component filter

The Process Explorer can have its activities cropped via use of the Crop Selection page filter, however when using the formulas CALC_CROP and CALC_CROP_TO_NULL in its component filter, the Process Explorer fails to crop Can the Process Explorer be cropped via component filter? If yes, what is the correct formula / way to do this?

404
Poovarasan
Level 2
.
Level 4
.14600833Level 4
asked in Data Ingestion & Infrastructure
Source und Target with PROCESS_ORDER

Hello everyone,i need a throughput between two consequitive activities and want to implement it via source and target.Die idee wre source(activity_table.activity), target(activity_table.activity, process_order(target)=process_order(source)+1))would it work?Best,Maria

235
sudharani.perum
Level 2
Iori Oshima
Level 3
Iori OshimaLevel 3
asked in Process Management
The difference of the words between Facet and Repository and Attribute

Hi all, I’ve learned the cource of “Celonis Process Management (CPM)”, but I don’t understand meanings some words well. I can understand Category Core Process, Main Process, Support Process Main Process, Sub Process But I can’t understandFacet Repository Attribute (Attribute group) StereotypesI would like to clearfyWhen or Where to use  What is the main concept they are connected to If there are any words which help me understand, feel free to add some words & concepts. Ref01. Welcome to Business Process Management > Learning the vocabulary [12:00] > Repository Objects and Facets [03:00]https://academy.celonis.com/learn/course/symbio-kickstarter/welcome-to-business-process-management/learning-the-vocabulary-1200?client=customer-panorama&page=3&query=facet

422
caspar.jans
Celonaut
ritesh3719
Level 3
ritesh3719Level 3
asked in Process Analysis
Enable/Disable or hide/unhide functionality in Studio View

Is it possible to enable/disable or hide/unhide a button in Celonis Studio Views. Basically i want to enable the button on certain conditions applied in the filter dropdown inputs.

382
ritesh3719
Level 3
koert.kritz11
Level 3
koert.kritz11Level 3
asked in Process Analysis
PAM Event log Error

Hi I, I am configuring my PAM but keep running into these errors.  ErrorSupport Id: faafa039-b13e-47e6-88cd-7e64c7f898e6PQL Error during operation: Events - Count. Repeating the request will always result in error. Fix this by changing the current asset state. If the error persists, please contact support. ErrorThere are event logs in your selection which are no longer available or valid:EL_CUSTOM_OTTPAYMENT__ACTIVITYI created a second eventlog with the required names for my activities and this works when I use it for process explorers and case explorers, but when I try and use it for my PAM I get the error messages. Here are my eventlogs: 

70
koert.kritz11
Level 3
jonas.hess
Level 3
jonas.hessLevel 3
asked in General Product Q&A
See no Records in smart Sensor

RecordsHello, unfortunatly i could not see any Records in my smart sensor, anyone familiar with this Problem? ThxHeSee no Records over here

60
jonas.hess
Level 3
omar.elmou
Level 3
omar.elmouLevel 3
asked in General Product Q&A
Dear Celomates,I would like to add the rework rate as a KPI without using PQL.

I have added an OLAP table with three columns where the Count of activities is compared to the Distinctcount activity for each case key. Please find attached the OLAP table. Besides the OLAP table i would like to show the rework rate as one number by referring to the formula and outcomes of the OLAP table. How can i add a number (without using PQL) where the ration of cases with a YES", as displayed in the OLAP table, is returned as one percentage. Many thanks!

322
Poovarasan
Level 2
david.stefa13
Level 3
david.stefa13Level 3
asked in Process Improvement
Action Flow - Sending an MS Outlook CSV file automatically to each customer and their varied list of contact email_addresses

As part of the MS Outlook email recipient ‘To list’, the number of email recipients varies by customer and can vary from 1 contact to up to 9 contacts. For those familiar with the term ‘Rolodex’, (customers/contact_names/email_address), I want to automatically sequence through the ‘Rolodex table’ and send one email to each identified customer (based on a flag that is set) and TO: each respective contact for that customer (1 to 9 contacts_email_addresses). What is the best way to address the ‘dynamic list’ of email contacts per customer that need to get set up in the MS Outlook module?I have seen the example in the community of using the Group function in the CSV module, but that example was specific to 1 role (1 recipient in the MS Outlook 365) vs a varied list of contact_email_addresses, depending on the customer.

672
david.stefa13
Level 3
andres.naran12
Level 4
andres.naran12Level 4
asked in Data Ingestion & Infrastructure
How to get the timestamp for an specific activity?

Hi community, I have the following challenge that I’m trying to figure out.I need to calculate how many hours were spent on a holiday, since the connection is not through SAP, I cannot use the functions that PQL provides for that.My idea is to get the timestamp related to the last activity that happened on holiday and calculate the throughput time between 9:00 AM and that specific time in order to get how many hours were spent.Example:Activity 1 → Day 1 Activity 2 → Day 2 (holiday) Activity 3 → Day 3 Activity 4 → Day 4In this example let’s suppose activity 2 occurred at 13:00, so in this case I should do the following calculation. 13 - 9 = 4 hours → This is the number of hours that were spent on holiday. Does anyone have a similar experience?

632
andres.naran12
Level 4
tushar.konde
Level 3
tushar.kondeLevel 3
posted in Process Analysis
Filter View data with user login into celonis

I am working on use case where i want to filter the view when user log in into celonis .user has two types one general buyer and second tactical buyer so when general buyer login he should access only general buyer data and when tactical buyer log in he should access only tactical buyer data so i need help to create this filter if its possible how i build it in celonis Thanks in advance

391
janpeter.van.d
Level 8
Sony Shrestha
Level 3
Sony ShresthaLevel 3
asked in Process Analysis
Check if last occurrence of A directly follows B

I am aware of PQL that checks if activity A directly follows B. Can someone help me with PQL to check if first/last occurrence of A directly follows first/last occurrence of B?

311
janpeter.van.d
Level 8
marcin.konop13
Level 3
marcin.konop13Level 3
asked in General Product Q&A
Custom Attribute not available for KPIs

Hi all I have created a simple attribute that calculates a metric I will be averaging out.  And in the table it looks fine. However whenever I try to call it I get an error  Please assist. I presumed as documentation states that those calculated attributes are treated the same as values in a column. KindestMarcin

518
rita.kiss12
Level 4
ritesh3719
Level 3
ritesh3719Level 3
asked in General Product Q&A
How to Apply Role-Based Access Filters in Celonis for Users?

In our team, we have different roles assigned to users, such as Junior Buyer and Tactical Buyer. I want to ensure that when they access Celonis, they only see records relevant to their role.We have a mapping between user and their assigned documents (Purchase Requisitions, Purchase Orders, etc.) in a table. Based on their role, users should see only the documents assigned to them.

371
janpeter.van.d
Level 8
Sony Shrestha
Level 3
Sony ShresthaLevel 3
asked in Process Analysis
Get number of instances of object type O1 which is related to n instances of object type O2

I want to write PQL that gives me number of instances of object type O1 which is related to n instances of object type O2. Ex: Number of Purchase Order which is related to 2 instances of payment. There is no 1:N relation between these table. In this scenario, is it still possible to get number of instances of one object based on how many times it is related to other object type?

162
Sony Shrestha
Level 3
matt.witty13
Level 5
matt.witty13Level 5
asked in Process Intelligence Graph (PI Graph)
Extracting Objects and Events in Python

Hi Celonis Community,I’m trying to get a better understanding of what is in the OCPM Catalog. I’m hoping to extract all the objects and events, their attributes, etc. and build out some documentation in the event I need to adopt the OOTB solutions. There doesn’t seem to be an export button or a way to pull out that information. Has anyone found a way to get this information out of Celonis? Thanks!Matt!

713
manuel.wetze
Level 5
Hafsa
Level 2
HafsaLevel 2
asked in General Product Q&A
celonis Vs camunda

Hello,I want to know why using Celonis and not Camunda for process improvement? I made some research and I found that with Camunda optimize I can get visualisations ..., logs from Camunda execution. So I need to know the ++ of Celonis compared to Camunda in term of improvement results and process optimization and not the approach.Thank you  

450
Hafsa
Level 2
farouk.abdel
Level 2
farouk.abdelLevel 2
asked in Data Ingestion & Infrastructure
CPM4 sizing

what is the celonis sizing guidelines for CPM4?

191
A
Celonaut
P
Level 1
puneet.duaLevel 1
posted in General Product Q&A
Can anyone confirm if we can extract the KPI data in excel format

Can anyone confirm if we can extract the KPI data in excel format

133
bruno.castr
Level 2
maxime.psbpm
Level 3
maxime.psbpmLevel 3
asked in Data Ingestion & Infrastructure
Issue with Many-to-Many (N:N) Relationships in Celonis

Hi everyone,I'm facing an issue with how Celonis handles many-to-many (N:N) relationships. It seems like Celonis treats these relationships as 1:N → 1:N instead of supporting 0:N → 0:N, which leads to missing data when filtering.Example Issue:I have a many-to-many relationship between contracts and assets, modeled with an intermediate table:Contract Asset C1 A2 C2 A1 C3 NULL C4 NULL NULL A3 NULL A4 The issue occurs when I apply a filter like "Asset ≠ A4". Instead of just removing A4, I also lose contracts C3 and C4, which should still be visible since they are not linked to any asset.My Understanding of the Issue:Celonis seems to implicitly treat N:N relationships as 1:N → 1:N, enforcing a strict link between contracts and assets. It does not seem to support a true N:N model, where both sides can have optional (0:N) relationships.Question:Has anyone faced this issue before?Is there a recommended modeling approach to ensure that filtering on assets does not remove u

1425
maxime.psbpm
Level 3
Bharath
Level 3
BharathLevel 3
asked in Process Analysis
OLAP Tables and Tables

I am new to Celonis. I have this dilemma on ‘Why do tables exists when we have OLAP tables’.What is the purpose of two of them existing?I know tables are present only in views while OLAP tables in analysis.What are all the differences or things we can do with tables and OLAP tables seperately? 

563
Bharath
Level 3

Badge Winners

VIEW ALL
Community Code of Conduct