Skip to main content

Product Q&A

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

3147 Topics
mccoole
Level 2
mccooleLevel 2
asked in Celonis Free Plan
Why is Celonis Start for free disabled?

I was wondering why it is not possible to create a free account to be able to preview this solution. Thanks.

10
mccoole
Level 2
jacob.fehli11
Level 2
jacob.fehli11Level 2
posted in Process Analysis
Experiences with Process Adherence Manager

Hi everyone,the company I work at is interested in using the Process Adherence Manager (PAM). We already started setting it up for a first use case. While doing so, we encountered some questions. We would be very happy if some of you could share your experiences with PAM, particularly regarding (but not only limited to) the following questions:How do you handle numerous deviations that might be acceptable in some cases but not in others? Is it better to filter on each variant based on known attributes and break it down by creating multiple PAM instances? Or can it be a solution to create a lot of “allowed deviations”? Is PAM more suitable for complex processes including multiple objects or is it more effective to look at little sub-processes individually? The idea behind this question is that when a large process with deviating variants, the conformance rate tends to be low. Do you have experience if there are any types of processes where PAM is strong at and if there are processes whe

70
jacob.fehli11
Level 2
gauri.pai11
Level 2
gauri.pai11Level 2
asked in Process Analysis
Table missing in new version of views

Hi team,I am working on creating a dashboard out of a table created by TASK(cel Task).I am able to find the table in legacy view but not in new view.Please find attached screenshot of legacy view and new view. Legacy view: New view:Can you please help me in this? Thanks and Regards,Gauri Pai

50
gauri.pai11
Level 2
Hafsa
Level 2
HafsaLevel 2
asked in Process Analysis
Process analysis

Hello,To better analyze the Service Now process (a very complex process with many parallel tasks and loops...) in Celonis, is it preferable to use the pm_project and pm_project_task tables or the sys_audit tables?Thank you,

80
Hafsa
Level 2
leonardo.spina
Level 3
leonardo.spinaLevel 3
asked in General Product Q&A
Daily Average of IDs, daily period is dynamic (depends on Graph)

Hi all,I have a set of IDs/Case Keys that is spread accross 2023-2025. Focusing on 2024, I would like to calculate the daily average based on the Last activity dates.These IDs are divided in products, so when I create an OLAP table in Studio Views, then it takes the IDs per product, for large samples it’s closer to a correct daily average. On the other hand, when the product has 1 or 2 case IDs, then the Daily average is far from correct.Instinctively, I believe I should create a DOMAIN_TABLE but it doesn’t work. I tried using GLOBAL but it is not accepted.Hereby the code i’m using:Originaly:KPI("number_of_cases")/(  MAX (REMAP_TIMESTAMPS (PU_LAST("PROD_CASE_TABLE_DR", "PROD_ACTIVITY_TABLE_DR"."EVENTTIME"), DAYS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY ) ))-MIN (REMAP_TIMESTAMPS (PU_LAST("PROD_CASE_TABLE_DR", "PROD_ACTIVITY_TABLE_DR"."EVENTTIME"), DAYS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY ) ))+1) orKPI("number_of_cases")/(DATEDIFF ( dd, PU_LA

141
leonardo.spina
Level 3
fabian.altendorfer
Level 3
fabian.altendorferLevel 3
asked in Process Analysis
COUNT_TABLE with CASE WHEN

Hi,is it possible to use a COUNT_TABLE together with CASE WHEN to form a KPI? Below Query works for a simple COUNT with “TABLE”.”COLUMN” in THEN, but doesn’t work for COUNT_TABLE. COUNT_TABLE(CASE_WHEN(PROCESS EQUALS XY OR PROCESS EQUALS XZ) THEN "CASES" END) Thanks!

275
Sverre Klein
Level 6
josmi.agnes
Level 2
josmi.agnesLevel 2
asked in General Product Q&A
Multi value search for filtering Views

Hi everyone,With the latest views in Celonis, is there a way to filter multiple values across one or more dimensions in one go?For example, I want to filter all the purchase orders where field vendor name contain any of the following: ‘zxc’,’et’,’corp’ - without having to manually select each value one by one from filter dropdowns.Is there a more efficient way to achieve this instead of configuringdropdowns to select dimensions, input boxes to enter search patterns, and variables?For multiple dimensions, this setup becomes impractical.Thanks in advance!

80
josmi.agnes
Level 2
jan.vajse12
Level 3
jan.vajse12Level 3
asked in General Product Q&A
Package Dependencies - Update of Views

Hello Celopeers,  we would like to start using the Package Dependencies to maintain several package as DEV and one package as PROD. For KMs seems everything working fine with the KM extensions. We want to follow similar approach also in case of Views. Creating a View in DEV package and automatically synchronize the change made here to the PROD package.After some tests, we realized that changes made to View in DEV package are not reflected in the PROD package when updating the dependency.As per following description, we understood that this shoud be possible:By adding a package as a dependency, its Views and Knowledge Models can be reused using this extension mechanism. Does someone has experience with the Dependencies usage on Views and could help us overcome our issue? Thanks a lot.Jan

100
jan.vajse12
Level 3
jan.vajse12
Level 3
jan.vajse12Level 3
asked in General Product Q&A
Shared link opens last user's selection

Hello,our users face regulary the issue that if someone sends them link with a certain selection, what opens is their last selection of the view and not the selection that was shared with them. Is there any known way how to overcome this setup? If you send somebody a selection, this selection should alway show up if the person clicks on the link. Thank you for any advice.Jan

204
jan.vajse12
Level 3
Mst11
Level 3
Mst11Level 3
asked in General Product Q&A
Font size

Hello everyone,Does anybody knows what is happening with the font size of numbers in KPI Cards. Some of them are extremely big and some seem to be normal sized. Thanks a lot!

545
J
Celonaut
alison.macke
Level 2
alison.mackeLevel 2
asked in Process Management
How to change the default font colour in Process Designer Graphic editor

In Process Designer Graphic Editor, the default font colour for new links/text is brown. When I change the default colour it is only saved for the current model. How can I change the global default setting?

81
caspar.jans
Celonaut
markus.golka
Level 2
markus.golkaLevel 2
asked in Process Analysis
Throughput time based on first occurrence and ignore multiple/duplicate same activities

Hello all, I would like to calculate the througput time from activity to next different activity.The Challenge:My process has activities which occurs multiple times with the same name directly one after the other. This is no data issue, the process is designed that way.In case the activity with the same name occurs later in the process again, this should be count as well and not ignored.What is the time to the next activity, which does not have the same name? Process example:Avtivity       TimestampA    01:00 pmB    01:30 pmB    01:45 pmB    02:15 pmC    03:00 pmC    03:20 pmD    03:45 pmE    04:00 pmE    04:50 pmA    05:00 pm Expected Result:Avtivity       DurationA                30minB                1h 30minC                45minD                15minE                10min Does anybody know a solution or a community post, which can help me?

160
markus.golka
Level 2
filipe.mussi
Level 2
filipe.mussiLevel 2
asked in Process Analysis
Error when using filter with Case When

Hello,I'm trying to make the DSO indicator, but I need to get data from several tables and I'm having problems...The DSO formula is made up of two parts, Revenue and Accounts Receivable. I need to calculate each one individually and then divide one by the other.I'll use the example of Accounts Receivable:Quando eu uso os campos de Filtro, com os seguintes filtros, funciona sem problemas:FILTER "o_celonis_SalesOrder"."CompanyCodeText" IN ('CompanyNameZYX');FILTER "o_celonis_SalesOrder"."SalesDocumentType" IN ('XXXX', 'YYYY');FILTER "o_custom_CustomerAccountItem"."BaselineDate" <= {t ${end_date}};FILTER "o_custom_CustomerAccountItem"."ClearingDate" > {t ${end_date}} OR "o_custom_CustomerAccountItem"."ClearingDate" IS NULLHowever, when I try to place the same filters in Case when, to generate the indicator that will be combined with Billing, there is a connection problem between the tables (o_celonis_SalesOrder and o_custom_CustomerAccountItem).sum( CASE WHEN "o_celonis_SalesOrd

410
filipe.mussi
Level 2
PhuongBHN
Level 3
PhuongBHNLevel 3
asked in Data Ingestion & Infrastructure
How to enable the ‘Push data into Celonis’ Data connection option within my Data pool

Hello everyone, I am unable to locate the ‘Push data into Celonis’ Data connection option within my Data pool.Could you guide me on how to enable this feature?!--endfragment>My Celonis  I want the ‘Push data into Celonis’ as the image below 

383
abdulnour.duale11
Celonaut
benjamin.caill
Level 3
benjamin.caillLevel 3
asked in Process Analysis
How to access data from the Activity History Log

Dears, The activity history log component in JAB views allows us to see when augmented attributes and comments were updated.I want to to pull the date when the last action was taken for the object e.g. invoice (either through update of any augmented attribute or by adding a comment). I can’t find a way to achieve this and bring the information in a table. Thanks 

242
benjamin.caill
Level 3
NHARNIS
Level 2
NHARNISLevel 2
asked in General Product Q&A
Using Pu functions instead of Aggregates to be able to Filter KPIs

Hello Celopeers, im new to Celonis and have created a view. There i use a Kpi which drops a lot of zero values. When trying to filter them out i always get the error that aggregated functions can not be used in combination with the FILTER function, and that i should try PU functions. The KPI i'm using is this:SUM( CASE  WHEN round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") = round_day("o_custom_KnotenpunktFuellstand"."Date")  THEN 1  ELSE 0 END)or alternetively this : COUNT(DISTINCTcase when round_day("o_custom_KnotenpunktAuftrag"."AusgangForecast") =round_day("o_custom_KnotenpunktFuellstand"."Date") then  "o_custom_KnotenpunktFuellstand"."KnotenpunktAuftrag_ID"end) is simply want to calculate for each KnotenpunktFuellstand.Date, how many Order.IDs i have where the filter condition is met.So i can have a table where im using the date plus KPI to see, how many outgoing orders i can except for each date. How can i have a row-count, based on a condition formulated as a PU functi

302
NHARNIS
Level 2
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Classiffy

Hi everyone,I have a column with many numbers, and I have uploaded a screenshot as an example. I want to classify them into groups. FYI: I know the maximum, minimum, and median, and I also know the total number of numbers.How can I do that?Thanks in advance! 

9115
matthias.gielk11
Level 3
deeksha.r12
Level 3
deeksha.r12Level 3
asked in General Product Q&A
Accessing and Configuring Scheduled Reports

The reports section is intended for viewing scheduled reports, we do not see any option to configure them. 

151
matthias.gielk11
Level 3
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in Process Analysis
Variant Explorer: Add custom KPIs

Hi all I am wondering how to best add a custom KPI defintion to the Variant Explorer.Mainly I want to add my custom process specific defintion of a througphuttime. Me and my endusers don’t care about the default End2End TPT that Celonis always uses as default but rather the time between two specific activities.Instead of (or at least additionally to) the “Avg TPT” Column in the selection panel I would like to use my Metric “Median CustomProcesstime”.Does anyone know if this panel can be changed? Maybe via YAML?  

130
manuel.wetze
Level 5
emil.vakhi12
Level 3
emil.vakhi12Level 3
asked in Process Analysis
SAP FI-CA model for Accounts Payable

Hi, has anyone created a data model for Accounts Payable using SAP FI-CA data?Could you please advise on its parameters - what do you take as case ID, which additional tables your add, which activities do you extract, etc.?

162
emil.vakhi12
Level 3
Iori Oshima
Level 3
Iori OshimaLevel 3
posted in Process Management
What is the best practice when I describe the process map like TMForum

Dear all, I’d like to describe the process map like TMForum in the Process Designer .Like this : https://www.tmforum.org/certifications-awarded/huawei-digital-crm/business-process-framework/ TMForum eTOMThere are the horizontal part and vertical part.When we use the hierarchical edit alone, it cannot describe so I think that graphic is useful for me to do that. In graphic edition, we can use some diagram like ppt, but this will not be stractured.So I’d like to keep stractured and reuse the process I made as possible as I can. I ask you to advice on which parts should be presented as graphics and which parts should be structured as text. Regards,

182
Iori Oshima
Level 3
michael.kohlm
Level 2
michael.kohlmLevel 2
asked in Process Analysis
Assign Costs, depending on the predecessor

Hello,I am quite new to PQL and I tried to assign costs to spesific activities depending on the predecessor.When B is followed by C, only C should be assigned with certain costs. When A is followed by C, again C should be assigned with costs, but with a different value. The result should look like this:CaseID Time Activity Costs 150488 07:34 A   150488 08:30 B   150488 09:23 C 0,84 150488 09:45 D   150488 10:34 A   150488 11:45 C 1,56 150488 v E     I tried this with the following code: CASE  WHEN "ActivityTable"."Activity" = 'C'   AND MATCH_PROCESS_REGEX (    "ActivityTable"."Activity",    'A' >> 'C'   ) = 1  THEN 1.56 WHEN "ActivityTable"."Activity" = 'C'    AND MATCH_PROCESS_REGEX (    "ActivityTable"."Activity",    'B' >> 'C'    ) = 1   THEN 0.84 ELSE 0END Unfortunately the table looks like that, so it assigns the wrong costs: CaseID Time Activity Costs 150488 07:34 A   150488 08:30 B   150488

10
michael.kohlm
Level 2
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Sorting

Hey People,I need help sorting a coloumn in a table where each item number appears twice with a corresponding "Potential Savings" value. My goal is to sort the "Potential Savings" coloumn in descending order while keeping duplicate Item Numbers together (as shown in the current table). However, when I try to sort "Potential Savings," the duplicate entries get separated.Does anyone know how to sort the table in a way that maintains both the descending order of "Potential Savings" and keeps the duplicate items next to each other?Thanks in advance! Vendor Name Business Unit Item Number Commodity Last Order Date Expected Delivery Days Unit Price Potential Savings Alpha Supplies P18 0410390025 I030 2004-01-29 27 10.45 52.66 Beta Industries P20 0410390025 I030 2004-02-09 0 6.90 0.00 Alpha Supplies P18 0437150201 A110 2004-07-31 40 40.67 69.35 Gamma Solutions P20 0437150201 A110 2004-08-26 50 32.00 0.00 Alpha Supplies

182
Saba
Level 4
MrAj
Level 2
MrAjLevel 2
asked in General Product Q&A
Failed to auto save the View. Please save your changes manually

I'm encountering a persistent error in the View: "Failed to auto save the View. Please save your changes manually." Even when I attempt to save the changes manually, the View does not get saved, and none of the modifications to the UI are being retained. Is anyone getting the same issue? what could be the possible resolution?

181
jonas.hess
Level 3
gauri.pai11
Level 2
gauri.pai11Level 2
asked in General Product Q&A
Involve business user with task - unable to find record in task list

Hi team,I was trying to follow as per below screenshot.But i am not able to find a record in task list although added in knowledge model(Attached screenshot below of task list component and knowledge model respectively)Can someone please guide me on this?Thank you in advance!

163
jonas.hess
Level 3

Badge winners

  • Qualified to Write PQL Queries
    Gabriel Perniahas earned the badge Qualified to Write PQL Queries
  • Value Realization Expert
    Tobias Fehrerhas earned the badge Value Realization Expert
  • Qualified to Create and Deliver Demos
    Tobias Fehrerhas earned the badge Qualified to Create and Deliver Demos
  • Masterclass in Implementation
    diego.zacarhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    roberto.poushas earned the badge Masterclass in Implementation
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Portal arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025