Product Q&A

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?

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

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?

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

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.

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?

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!

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  

what is the celonis sizing guidelines for CPM4?

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

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

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? 

 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  

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.

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

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 ?

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

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 ?