General Product Q&A

Hi allI have a very basic question – sorry for that, I’m quite new to PQL and I cannot apply the information available online (or did not find it).I have two tables incident_CASE with column CASE_ID (1-side) and workorder_CASE with column WORKORDER_ID (n-side) (1 incident can have 1 or more workorder).How can I count the following:Number of incidents with exactly 1 workorder Number of incidents with 2 or more workorder Many thanks for your supportBestroger

I would like to understand how we can leverage Celonis functionalities to identify duplicate invoices or vendors. What are the different approaches available in Celonis to achieve this

Every ‘Get Row’ module suddenly stopped working, all at the same time… Has anyone ever seem this error message before? What does it mean? How can I prevent it from happening again? Error: Cannot initialize the scenario because of the reason 'Failed to compile IML function 'functionToDeleteSecond'. Unexpected identifier 'is''  

12月23日（金）に11月9日と10日にドイツで開催されたCelosphereの内容について、ダイジェスト版として日本後のRecap Webinarを実施します。日本語でCelosphereの内容をご案内させていただきますので、ぜひ、奮ってご参加ください。また、このWebinarはパートナー様だけでなく、お客さまもご参加いただけるWebinarです。​​https://www.celonis.com/jp/webinar/the-best-of-celosphere-japan/

Dear all,I was wondering if there are any approaches on how to measure how endusers are actually using the dashboards. With the purpose of improving usability.Does anyone have any approach on how to do this within the platform or by any workarounds on logs or even third party tools? Do you have any other appraoch to determine what the user really needs? Example key question would be:Which views get accessed how often?Which tabs get viewed how often?Which filters get used?Context: Naturally when developing custom dashboards you are implementing a lot of small requirements and end up always adding more functionally and therefore complexity. To have an aggregated analysis on how the users navigate a series of linked dashboards would help to remove less frequent used parts. 

Below an example of the code I am usingFor detailed information go to Celonis info page:<a href="https://docs.celonis.com/en/process-ai.html"target=_"blank"> Process AI</a>

Hi,Do you know if there is a way to execute an already exist Schedule in the Data Model from the Action flow. I have an Action Flow that updates some fields in the source system, and I want the data jobs (extraction, transformations, and data model load) to be executed as the last step of the Action Flow, so the updates will be available in the dashboard as well. Thanks.

Hi ,I am trying to use a PU function and use the result as a filter within another PU function.When i try below PQL it works fine.PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN ( PU_LAST(OBJECT,EVENT_LOG)))But when i try to add another argument for the ‘not in ‘ it returns nulls . In this example the ‘ABC’ is the additional argument for the ‘not in’ PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN ( PU_LAST(OBJECT,EVENT_LOG),’ABC’)) .have also tried splitting the filter using AND but still same issue persists.Any insights would be much appreciated.

In the Platform Adoption View downloaded from the Marketplace, there is a filter bar, and the list of dropdown values in each filter is sorted alphabetically. However, I noticed that there are numbers displayed next to each value, indicating the number of views.I would like to know if it's possible to sort the list by the number of views (e.g., from highest to lowest) instead of alphabetically by name. Alternatively, is there a way to hide the number of views displayed next to each value? Example of dropdown filter: 

Hi, I am trying to create a list of Action Flows using PyCelonis and I want to also add status if the Action Flow is currently active or not. I was trying to do it .get_action_flow(id).dict()/json()/json_dict() but there is no parameter there that would indicate if the Action Flow is activated or not.Thanks in advance for any replies :)

I want to create trigger for a action flow. Im not sure how to do it, I am creating a trigger in the KM but that trigger is not showing up in the Watch Trigger module in the action flow

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!

!--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]'

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.

We are working with a prospect who uses JDE and he requested us this information.

Hello everyone,I have a list of Material Numbers, and some of them belong to the P18 Business Unit, some to the P20 Business Unit, and some belong to both P18 and P20 at the same time.I created a Quick Filter to show only the materials that belong to P18, and it works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')I did the same for materials that belong to P20, which also works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')However, when I try to filter for materials that belong to both P18 and P20 at the same time, the following filter does not work correctly — it also shows materials that belong only to P18 or only to P20:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')AND "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')Do you have any idea how to fix this?Thanks! 

I am working on an intercompany transaction where one subsidiary of the parent in buying material from a vendor which is a subsidiary of the same parent. Hence O2C-AR of the buyer should be synced with the P2P-AP of the vendor.

Dear Community,I want to calculate an average error rate for each year under certain conditions. Even though it may seem quite simple, I receive an incorrect result. 🤔This is my formula:COUNT (DISTINCT (“Table”.”Column”))/COUNT (DISTINCT (“Table”.”Column”)). The KPI “2023” has the following conditions as filters: Do you have any idea what is wrong with my formulas? Many thanks and kind regards,Varvara

Hello Community,I hope you can help me to find the best approach of my issue. My challenge is to build a table with the complete SAP Process Flow: Order, Delivery, ShipmentFor this I have created a data model with the following linked tablesVBAK (1) - (N) VBAP (1) - (N) LIPS (N) - (1) LIKP (1) - (N) VTTP (N) - (1) VTTK When I try to add fields from all tables into one studio table I get the following error:I have understand the problem but missing the best approach to solve it.What do you think? Is the a studio table with different PQL formulas the solution? If yes, how can I do it?Or is it better, when I create a table (e.g. TAB_PROCESS_FLOW) within the transformations that includes all the key columns and connect the other tables (VTTK, VBAK...) within the data model. So the table TAB_PROCESS_FLOW is like a case/common table.Best, Thomas 

i have activity table which have same timestamp(T) for multiple activities in a single case. for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C. but flow is A->B->C

Hi, I want to know if there is a way to export the following listData model name ------ Data permissions ( Enabled/Disabled )if enabled then Group / User name ------ condition ( if any ) ----- unlimited (yes/no)i want to download this list as an excel, is it possible?

I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task templates?

Hi! I would like to personalize the event names for a client demo. How can we do it? Regards