Skip to main content

Product Q&A

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

4405 Topics
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: 

60
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

50
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!

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

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

502
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

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

281
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

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

361
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!

483
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  

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

121
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

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

483
Bharath
Level 3
harshini.gampa12
Level 2
harshini.gampa12Level 2
asked in Process Intelligence Graph (PI Graph)
In OCPM, REGEXP_INSTR function is not working

 Hello guys,I have a varchar column in my database and i would like to replace before the values “SU” in vendor table. I try to use the function INSTR but its not working in OCPM.Kindly please let me know  what is the function to be used to remove before values for SU.Few are the examples below : GHYSU10001049331000SU100014329022SU1000003141  

140
harshini.gampa12
Level 2
Bharath
Level 3
BharathLevel 3
asked in Data Ingestion & Infrastructure
PQL For distinct activities in a case, happening at the same time.

I have a table, for CaseIDs (1,2,3...) and some Activities (A,B,C….). The activities might be repeated in a case or they can be unique. and a TimeStamp column corresponding to the caseid and activity. i need to write a query where in a case there are 7 distinct activities and all of them must happen in the same timestamp. kindly help me with this.

100
Bharath
Level 3
llllliz
Level 2
lllllizLevel 2
asked in Data Ingestion & Infrastructure
How to use data pool parameter?

Dear community, I would like to set up a data pool parameter to allow me to switch between test and prod environment? So I would need two global variables for my data jobs:var_data_source: to allow me switch between test schema and prod schema var_table_name: to allow me when creating table to add _test at the end of the table nameI have only found the way to create parameters in EACH data job under transformation and refer to the data pool parameter. Is there a smarter way? I am still using the data integration (not OCPM). Thanks a lot!   

280
llllliz
Level 2
lize.erasm11
Level 3
lize.erasm11Level 3
asked in Data Ingestion & Infrastructure
Adding attributes to a event in a OCPM model

Hi, has anyone found a easy or quick way to add a large list of attributes to a event? 

351
abdulnour.duale11
Celonaut
charan.rajum
Level 2
charan.rajumLevel 2
asked in Process Analysis
setup scale picked based on annotation value of line chart

How to setup scale picked based on annotation value of line chart,I have three annotations lines upperlimit,lower limit and average if the average comes as 95% i want the scale to be displayed from 91,92,93... to 100,I know we can configure manually in component settings but is there any other way ?

80
charan.rajum
Level 2
thomas.keim
Level 4
thomas.keimLevel 4
asked in Data Ingestion & Infrastructure
Check if a Variable (New Views) is null

Hello Community,how can I check if a variable from the new views is NULL? My challenge is to not use an filter in a PU_FUNCTION when the variable is empty.Variable: VAR_CONDITION_FILTERExample Value with multiple selection: ‘Y001’, ‘Y020’, ‘Y300’I want to use the variable in a PU_SUM Filter statement like in this way.PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", CASE WHEN '${var_condition_filter}' IS NOT NULL THEN "FREIGHT"."CONDITION" IN (${var_condition_filter}) END )But this don’t work. Error:A PQL error is preventing this query from executing.Syntax error near [IN] after reading [PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", CASE WHEN '${var_conditon_filter}' IS NOT NULL THEN "FREIGHT"."CONDITION" ] at line 9. Please refer to PQL documentation for available syntax. This here works, but I need the check if the variable is empty to avoid errors and to avoid that users has to select all the possible values.PU_SUM("VTTK", "FREIGHT"."FREIGHT_CONVERTED", "FREIGHT"."CONDITION" IN (${var_c

581
thomas.keim
Level 4
thomas.keim
Level 4
thomas.keimLevel 4
asked in Process Intelligence Graph (PI Graph)
Using Variable in KPI/Attribute Unit possible?

Hello Community,I would like to give my users the option to display an amount (e.g. freight) in any currency. To do this, I use the function CURRENCY_CONVERT_SAP and pass the target currency via a variable. This works perfectly.My problem is the unit: Do you know of or is there a way to use my variable in the unit field so that the selected currency is automatically displayed as the unit?Thank for help, Thomas  

414
thomas.keim
Level 4
Bharath
Level 3
BharathLevel 3
asked in Process Analysis
Views and Analysis

I have some confusion as to why analysis and views exist as separate entity. When both of them serve the same purpose despite the differences in availability of some features.

1272
Bharath
Level 3
andré.tafur
Level 4
andré.tafurLevel 4
posted in Process Intelligence Graph (PI Graph)
Knowledge Hub News?

Hi Celopeers!Anyone knows about Knowledge Hub release? Regards!

462
janpeter.van.d
Level 8

Badge Winners

  • Qualified to Build Views
    amin.harighas earned the badge Qualified to Build Views
  • Value Realization Expert
    tim.winklerhas earned the badge Value Realization Expert
  • Qualified to Manage Implementation Projects
    tim.winklerhas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Get Data Into Celonis
    matilde.pesce11has earned the badge Qualified to Get Data Into Celonis
  • Qualified to Write PQL Queries
    matilde.pesce11has earned the badge Qualified to Write PQL Queries
VIEW ALL
Community Code of Conduct