Product Q&A

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  

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.

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

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. 

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

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!

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

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

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.

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

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

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!  

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!

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

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 

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 

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?

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

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

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

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?

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,

How do I calculate the Cycle time in OCPM, when my process starts in one object and ends in another?I tried PU functions + bind but I didn't get good results. If anyone can help me I'd be grateful.

Hey,I have an activity that every case has to go through. I would like to know how long the time is between each case. (This is interesting for me because only 1 case can go through the activity at a time and we want to analyze the “empty” time).Does anyone have an idea how to calculate this?Thanks for helping!

Hi all,What are your methods to crosscheck all information is correct in a Studio View?Using Variables and the Knowledge Model is a very important practice, when changing formulae in the KM, then the components automatically update.However, when using a KPI from the KM is not possible, how do you ensure consistency throughout different tabs? How do you guarantee to the users that they won’t find any misalignments or mistakes?Is there a specific methodology at hand, besides suggesting a manual check tab-by-tab?Thank you for your guidelines.