Skip to main content

Product Q&A

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

4385 Topics
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  

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

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

442
janpeter.van.d
Level 8
ritesh3719
Level 3
ritesh3719Level 3
asked in Process Analysis
Adding a checkbox or a button against each record in view table dashboard which will set the value of the column of that table in a variable.

I want to add a button or a checkbox against each record in a table component in view studio. This button or checkbox will dynamically set the value of a column in variable which will be used for filtering purpose in another view in same package. 

232
ritesh3719
Level 3
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Filter Date in PU

Hi,How can i filter it to show the values from last year?PU_LAST("o_celonis_MaterialMasterPlant", "O_celonis_PurchaseOrderItem"."NetUnitPrice")Thanks!

291
abhishek.chatu14
Level 7
Saba
Level 4
SabaLevel 4
asked in General Product Q&A
Merge or Combine

Hello Everyone,In my View, some numbers appear twice — one row contains lead time and price for version A, and the other row contains lead time and price for version B.So for a specific number, you either see data for version A or version B, but I want to combine them into a single row for that number.Here’s an example of how my data looks now:Number Lead Time A Lead Time B Price A Price B 12345 28 - 10.88 - 12345 - 7 - 6.94 And this is what I want to get:Number Lead Time A Lead Time B Price A Price B 12345 28 7 10.88 6.94 Is there a way to do this?Thanks a lot!

1087
abhishek.chatu14
Level 7
sharon.josep13
Level 2
sharon.josep13Level 2
asked in General Product Q&A
Edit Extensions in Open PO Management App

Hi, I want to edit the Extensions in the Open PO Management App but I am getting the following error message:Runtime variable ErrorThe variable Cannot read property 'PO_NUMBER' of null. Please make sure that this variable is defined.Which step am I missing? I tried to add PO_NUMBER as a View Variable and as a Runtime Variable.Thanks and best regards,Sharon

90
sharon.josep13
Level 2
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Duplicate

Is there a way to remove duplicate values in a coloumn ? 

221
Sverre Klein
Level 6
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in Data Ingestion & Infrastructure
To get Count of Activities in Process Explorer

Hi Team, I am trying to write a pql query to extract value of activity count between two activities one of them is either process start or process end.Like I highlighted the value in the screenshot. please let me know, how to achieve it. Regards,Ajith Naidu.

252
Sverre Klein
Level 6
Saba
Level 4
SabaLevel 4
asked in Process Analysis
Compare

Hi,Is there a way to compare the value of the 2 row and return the one that is smaller and then sum all the smaller values together ?Sampleid 1 = 5id 2 = 20id 3 = 7sum = 5+20+7 = 32

80
Saba
Level 4
robert.ledig
Level 2
robert.ledigLevel 2
asked in Process Analysis
Difference between CASE WHEN and STATIC CASE WHEN and when to use it?

Hello everyone,I hope you can help me understand the difference between the two PQL functions CASE WHEN and STATIC CASE WHEN.I can't find the difference using the documentation, and unfortunately, I couldn't find any content about it in the forum either. I would really appreciate your help and hope someone can explain it.Thank you for your support!Best regards,Robert

532
robert.ledig
Level 2
omar.elmou
Level 3
omar.elmouLevel 3
posted in Process Analysis
How to make selections

Hi fellow Celonis user,For some reason i cant make use of selections ( at the top). In the screenshot below you can see that this option is not available. Also i can't change this in the general settings. Hope someone can help out. Thanks!  

424
omar.elmou
Level 3
Iori Oshima
Level 3
Iori OshimaLevel 3
asked in Process Management
How to activate the process in Process Navigator?

Hi all, I’d like to confirm the common release process.I’m a article, and I’ve released the sub process but I couldn’t activate the process in Process Navigator. I’ve alredy checked the Permitted set and there is no permission set. What are common issues?I can’t click in Process Navigator  

91
Iori Oshima
Level 3
antonio.figue
Level 2
antonio.figueLevel 2
asked in Process Analysis
Create and send automated PDF reports from Views

Hi, I currently have a dashboard in Studio Analysis for which I built an Action Flow that picks up a distribution list with certain filters so that i can send out automated emails with a pdf attachment (each with different filters). Now I wanted to do the same with a View and this is not possible.50 users should receive an automated pdf of a View on a weekly basis filtered only on their set of Divisions/ Product Groups. What is the best alternative to automate this?BR  

320
antonio.figue
Level 2
R
Level 2
ramasrikari.donta12Level 2
asked in General Product Q&A
Initially I had four attempts to complete the Rising star technical assessment. I failed in the first two attempts of the first section. Now it shows 0 attempts remaining.I have competed all other sections.Please guide me how to restore those at

Initially I had four attempts to complete the Rising star technical assessment. I failed in the first two attempts of the first section. Now it shows 0 attempts remaining.I have competed all other sections.Please guide me how to restore those attempts.

315
Saurabh Raut
Level 2
Hannah37310
Level 2
Hannah37310Level 2
asked in Process Analysis
Bar chart including incomplete quarters

I’m attempting to create a bar graph that shows opportunities created by quarter (Q1, Q2, Q3, Q4). However, I want to include incomplete quarters (ex: Q1 - 2025, but I have no data for March 2025, only Jan 2025 and Feb 2025, but I still want to show this quarter). Is there a way to do this? I’ve tried a bunch of things, but none make the incomplete quarter appear. Thanks!

150
Hannah37310
Level 2
stephan.kosch
Level 2
stephan.koschLevel 2
asked in Process Analysis
Line Break in Tables

Hello everyone, have you thought about integrating line breaks into Tables of the new views? Can you please give us a brief update on this.Thank youStephan

241
A
Celonaut
filki
Level 2
filkiLevel 2
asked in Process Analysis
Send mail from Celonis in Action Flow

Hello,I’m new to Celonis, currently trying to estabilish Action Flow that sends PDF reports.Is it possible to send “Email from Celonis” from Skill in Action Flow?RegardsFilip Kin 

422
filki
Level 2
janpeter.van.d
Level 8
janpeter.van.dLevel 8
asked in Process Intelligence Graph (PI Graph)
Disappearing Tasks when switching between 'test' and 'production' Object Centric Data Modle

Hi all, We have installed the ‘Open Order Processing App’ on an Object Centric Data Model (OCDM), and using the latest version, built in the Enhanced Studio. The app was installed on the ‘Test’ OCDM, and in the Tasks Management view, you see all the predefined tasks (we added ‘Approval Block’ ourselves). See screenshot below.  When we update the OCDM of the Knowledge Model where the triggers are in, and publish the asset, all tasks disappear (I’ve added the approval hold again manually): This is in some way logical, since the triggers for the tasks are linked to a data model and not to a knowledge model. However, it’s quite disturbing, because switching from Test and Production OCDMs then include that you have different tasks, which is hard to maintain. My question to you is:Are there any workarounds that you know of to move all tasks from one data model to the other, without having to install the entire app again on a different data model? Thanks in advance,JP 

170
janpeter.van.d
Level 8
marilyn.torta
Level 2
marilyn.tortaLevel 2
asked in General Product Q&A
Requested column of table is not present in the according parquet file

HI everyone! I’m getting this error message when trying to Load my data model with a new table: “The requested column EKKO.INCO1 of table Agreements is not present in the according parquet file” .However the table “Agreements” is created in the data job with the same functions as any other table in the data model (“Create table Agreement AS ( Select CAST (EKKO.INCO1 AS VARCHAR) AS "EKKO.INCO1"...etcetc) so I don’t understand where this “parquet file” format is coming from… any idea?

202
marilyn.torta
Level 2
harshini.gampa12
Level 2
harshini.gampa12Level 2
asked in Process Intelligence Graph (PI Graph)
How do we merge two objects into one object ?

In OCPM ,  How do we merge two objects into one object ?

292
harshini.gampa12
Level 2
carmen.kaluz
Level 3
carmen.kaluzLevel 3
asked in Process Improvement
How can I use the List Items - Microsoft SharePoint Online in Action Flow module to read records that exceed the limit of 3500?

Hey everyone, I have created an Action Flow with the List Items - Microsoft SharePoint Online module to read data from a SharePoint site that contains more than 3500 records.I wanted to know if there is any way to read records from SharePoint that exceed the limit of 3500 and how to configure this (e.g. using the Repeater module) ?  

803
abhishek.chatu14
Level 7
tasneem.mukad11
Level 2
tasneem.mukad11Level 2
asked in Process Management
Celonis Live data link in CPM(Symbio)

Hi, does anyone know how to configure the live data link to Celonis in CPM? the instructions on the support page don't seem to work

281
abhishek.chatu14
Level 7
PhuongBHN
Level 3
PhuongBHNLevel 3
asked in Data Ingestion & Infrastructure
How to connect S3 without using access key?

I need to create a connection from Celonis - Data Integration to AWS S3 without using an access key, as our policy requires password rotation every 90 days, and I prefer to avoid manual updates. Do you have any suggestions on how to achieve this?

110
PhuongBHN
Level 3
nicolas.kazek
Level 2
nicolas.kazekLevel 2
asked in Process Improvement
Restrict Scope of People for Task Assignment

Hi,we are looking for an option to restrict the dropdown of an “Asignee” component to a selected number of persons. Currently the dropdown shows ALL persons / groups in our tenant (see example below): Is it possible to restrict the dropdown to display only pre-defined users or user groups? If so, how can this be achieved?BR,

253
janpeter.van.d
Level 8

Badge Winners

  • Qualified to Manage Change and Scale Adoption
    ravid.giladhas earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Build Views
    lohitha.asarahas earned the badge Qualified to Build Views
  • Qualified to Build Views
    rajarshi.chauh11has earned the badge Qualified to Build Views
  • Qualified to Prove Celonis Value
    santhosh.s19has earned the badge Qualified to Prove Celonis Value
  • Celonis Technical Expert
    Namit Singhhas earned the badge Celonis Technical Expert
VIEW ALL
Community Code of Conduct