Product Q&A

Hi all,  I created an attribute (“MARC”.”cond_mbew_compl_vprsv”) as a boolean with the following formular:CASE WHEN(  ( "MARC"."BESKZ" = 'E' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'S' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."STPRS")) = 0 ))    OR  ("MARC"."BESKZ" = 'F' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'V' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VERPR")) = 0)))THEN 1 ELSE 0 END Now I want filter like followed: FILTER "MARC"."cond_mbew_compl_vprsv" = 1 This does not work and I got the following error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account. Can you help me what I should change? Thank you. Regards

Hello everyone,I’m trying to create a new Record and Attribute in the Knowledge Model, but it seems that after creating them, I can’t use them.Record: "o_celonis_Material"Attribute:pu_last( "o_celonis_Material", bind("o_celonis_StockHistory", "o_celonis_MaterialMasterPlant"."id"), left("o_celonis_MaterialMasterPlant"."id", 3) = 'p18' ) Does anyone have any idea? 

Hi all, I have a problem with loading the asset library, it shows the following error.Cannot read properties of undefined (reading 'children') Anyone has the same issue? Thanks!

I'm facing an issue where my charts and tables show the message "You don't have data yet" even though I have connected them to the data model.When I create a Case Explorer, it only shows 1 row with these columns: Case ID Number of Activities Duration In the table section of the Case Explorer, it only displays CDHDR.CASES.Can someone please help me understand why I’m not getting any data in the charts or other tables I create?Thanks in advance!

Hello Community,I need you help in using the PQL Function QUANTITY_CONVERTMy objective is simple: I want to convert the SAP Field LIPS.BTGEW to Tons (TO). The original Unit is stored in field LIPS.GEWEI.With this try I get an errorQUANTITY_CONVERT("LIPS"."BRGEW", FROM ("LIPS"."GEWEI"), TO ('TO'))A PQL error is preventing this query from executing.Syntax error near [)] after reading [QUANTITY_CONVERT("LIPS"."BRGEW", FROM ("LIPS"."GEWEI"), TO ('TO')] at line 32. Please refer to PQL documentation for available syntax. What's the problem? If I understand the docu (https://docs.celonis.com/en/quantity_convert.html) correctly, I must not provide a conversation rates table?This operator converts quantity units based on a QUANTITY_CONVERSION_RATES table, which is optionally provided by the user. If not provided by the user, a default QUANTITY_CONVERSION_RATES table will be used. Where can I see the contents of the default QUANTITY_CONVERSION_RATES table?Thanks for helpBest, Thomas 

Hello everyone,I'm working with classic process data: Case ID, Activities, and Timestamps.I want to list all first activities and all last activities, and count them by case. This way, I can see which activities my variants start and end with, and how many variants they cover.Ideally, I’d like this in two tables—so I can select a starting activity and see the corresponding ending activities in the other table.I’m assuming it’s fairly easy but i can not manage to do this..Kind regards, Niklas

I need to use a filter in my extraction, but the field in the table I'm bringing it from has a separate name "Date Archived" Example.When I use it like this "Date Archived" >= '2024-01-01 00:00:00', it doesn't load, I believe it's because of the space between the column name. Does anyone know how to solve this?I've tried to put the column as a parameter, but I still can't. 

Hello all,I used this formular to get the average time of late payment:AVG((DAYS_BETWEEN(PU_FIRST("BSEG", "_CEL_AR_ACTIVITIES"."EVENTTIME","_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = 'Due Date passed'),"BSEG"."TS_AUGDT")) - <%= buffer1 %> ) This works well but when I filter on Fiscal Year the KPI is wrong because our Fiscal Year is not similar to Calendar Year. Our Fiscal Year starts always in october. How can I change my formular that the KPI is calculated for example from october 2024 til september 2025 when I selected 2025 as Fiscal Year. Thanks and best regards.

Hi,Is it possible to adjust the settings of a Process Explorer on how it opens inside a view, like the zoom level or which Events are shown?Right now, there are too many events displayed in the Process Explorer, and my users need to zoom manually to see the names of the activities and their KPI values. I would like to change the initial zoom settings to a higher value or to show only the activities that don't display 0 in their primary KPI, if that's possible.Many thanks for any help, Fabian

!--startfragment>Hi everyone,I'm currently facing an issue when trying to connect from Celonis to Redshift via the Extractor.!--endfragment>  When I check the Extractor logs, I consistently get the following error:!--endfragment>!--startfragment>ERROR 66250 --- [pool-4-thread-1] c.c.c.j.c.u.status.GetDataSourceStatus   : Error during connection test --EOM--cloud.celonis.connector.client.exception.ExtractorException: Unable to write a test file to the temporary directory '/tmp/CEL_CON_TEMP'. Please make sure that application is provided with the write permission on it and it exists. To troubleshoot, I’ve already ensured that the folder exists and has correct permissions. Here's what I've done:!--endfragment>!--startfragment>   sudo mkdir -p /opt/celonis/tmp/CEL_CON_TEMP   sudo chown ubuntu:ubuntu /opt/celonis/tmp/CEL_CON_TEMP   sudo chmod 755 /opt/celonis/tmp/CEL_CON_TEMP   sudo -u ubuntu touch /tmp/CEL_CON_TEMP/test.parquet !--startfragment>The manual file creation

I have tried to connect to my Redshift by Extractor Server. But I have meet the issue below when start the extractor. How can I fix this? [class cloud.celonis.uplink.manager.UplinkDataWrapper] and content type [application/json;charset=UTF-8]', waiting 3000ms before retrying --EOM--2025-06-13 02:11:40.256  INFO 22860 --- [uplink-thread-1] c.celonis.uplink.manager.UplinkManager   : Uplink could not connect: 'Error while extracting response for type [class cloud.celonis.uplink.manager.UplinkDataWrapper] and content type [application/json;charset=UTF-8]'

Hi team,Just wanted to check if any body has gone through this type of an error while using predefined transformations from ocpm catalog and if yes how can we resolve this. Thanks,Akshay

Hi All,I am trying to use OCPM catalog to build a procurement process, currently I am having 3 databases SAP ECC, S4 and ariba. The issue here is that when I am selecting the database ariba/S4 then also I am getting the option to select the transformations for only SAP ECC. Is there any way to get the s4 and ariba transformations itself for the respective databases. Thanks,Akshay

Hello everyone,I understand that the button dropdown is still not available in the new Views. Has anyone managed to recreate a similar functionality? For example in the analysis I have two button dropdowns and for each one of them I have manually inputted 5-6 categories (Local Supplier, Company Code, MSGK, PO number etc.). Each category is updating two variables (one is for the name of the column and other is PQL calculation in OLAP table). Categories from button one are updating variables in column A while the categories in button two are updating variables in column D. I need to achieve something similar in the new Views, but the documentation for the Input Dropdown isn’t entirely clear to me. Has anyone implemented this successfully? If so, how did you manage it?Thanks in advance for your help!

Hello everyone,I would like to create option for users where they can leave comments. I would like for this option to be connected to a chart (let say it’s a chart showing number of blocked documents per month) and I would like to allow users to leave comments for February (number of blocked documents was really high compered to other months). But the issue is that for comments and augmented attribute identifier needs to be unique and I cannot configure it. So if someone has some idea I would be grateful.  Also in documentation they configured comments with variables but when i put variable for DOC ID (VIM_1HEAD.DOCID) and use that variable as identifier it’s not working. Any idea what should be put there? Thank you!

Can we change Data model of an existing Knowledge model? As I am trying to change the data model, I am getting Data model fail notification.

Hello!!Does anyone know if it is possible to generate a document with the complete documentation of an OCPM-Model (Objects, Events, Relationships (O2O & E2O) and Transformation Scripts)?Thanks and best regards,Pablo

How do I see the replication cockpit also along with the data job. How do i set the change table and trigger for it?

Hi team,I need help in understanding how to apply filter for KONP table in data extraction joining another table.My requirement is:1.For A018 table - I need all the records where A018.MATNR =  EKPO.MATNR.2.For KONP table, all the records from KONP table where A018.KSCHL = KONP.KSCHL If i am trying to implement 1st point in filter condition of A018 extraction as screenshot below,Data extraction fails with error : Error loading resource A017. The multi-part identifier "ts1.EKPO.MATNR" could not be bound.Can you please help in this? Thank you in advance.

I DID THE WHOLE PROCESS IN MY DATA POOL, FROM UPLOADING A FLAT FILE TO THE DATAMODEL WHERE I HAVE NO ERRORS, HOWEVER IN THE VIEWS WHEN CREATING A TABLE VIEW IT ONLY BRINGS ME THE HEADERS

Hi Guys, what’s up ? I wanted to ask if there is any way we can selection multiple attributes in new views and update variable based on it. Currently, the ‘multiple’ option is disabled for attribute selection. I tried with free text but it just adds additional single quotes in beginning and end of the string, so those single quotes should be removed to consider it as table and fields. for ex. “table”.”field” is considered as ‘“table”.”field”’.  

Buenos días necesito saber si es posible utilizar CELONIS para realizar análisis de dato o información para obtener INTELIGENCIA en el ámbito militar, lo que me permitirá mejorar el proceso de toma de decisiones 

Hi all, In the case explorer, in YAML or Views, how can I change the Throughput Time and use my own formula in PQL?Thanks for helping.Br,Leonardo

Good morning all, I need assistance with PQL to compare the timestamp of a certain activity of case A with the timestamp of another activity of case B, has anyone done this before?

Hello,My goal is to create a filter which, after clicking, will only show cases which contain specific activity in them. In my case I want to include all cases which do contain activity with string ‘reject’ in the name of activity.I’m trying to create a filter with this expression:  FILTER MATCH_PROCESS_REGEX ( "_CEL_MERGED_ACTIVITIES"."ACTIVITY", 'X' >> LIKE '%reject%' ) = 1;             Although it does not seem to be working.How can I create and apply a filter to show only all cases which do have such activity?