Product Q&A

Hello Celopeers, whats the best way to handle NULL results in PU-Functions when I need 0 if no PU results are available? Here a example how I do it today: CASE WHEN ISNULL(PU_SUM(VBAK, VBAP.KWMENG)) = 1  THEN 0 ELSE PU_SUM(VBAK, VBAP.KWMENG) END Is there a way to make it better? BR, Thomas   

Hi all,  In one of our Studio Views, some components are not loading. We see the error message: 'The component contains a large amount of data. Loading may cause the browser to crash'. It is just a KPI-bar component that worked properly before, but after we did some additional checks in between to set the scope of the cases correctly, it is not loading anymore.  My question is, what are the limits before such error messages pops up, or are there any best practices to solve this easily (for instance, a max number of nested KPIs or max number of rows?). This would help us in solving the issue.  Best regards,Jan-peter  

I'm using a dimension which is based on KPI which contains different tables IDs (e.g: matnr from marc, ebeln from ekpo...) I´m trying to use this dimension whit a KPI (inventory on hand). This KPI is formed the following way: COALESCE(  PU_LAST(    "MARC"    , "STOCK_HISTORY"."VALU_LBKUM_CON"    , ORDER BY "STOCK_HISTORY"."EVENTTIME" ASC  ) -- Ascending order is considered. Hence the result is the last eventtime (and therefore most recent) in the table per Material || Plant.  ,0.0).It is giving me a problem of common table, but I thought that by stablising MARC as the common table with pu_last it would work, as it is working with other KPIs made the same way.Hope somebody can help me here, thanks

I wanted to know a best way to extract a table from a data pool directly, I am aware of the way of extracting it from data model but rather than that I would prefer extracting it directly from the data pool.

... the person responsible does anyone know how to solve this?

I am doing conformance analysis and i want to add some process rules to be considered in the analysis. For example: If the PO is of type X, then it does not need a PR. Other PO types need a PRAnother example: for all POs in company code XXX, the activity 'Receive Order Confirmation' is not required. In the conformance sheet we can only add KPIs and add violations to allow list, but there is no option to customize these violations to focus on certain cases, or add other process rules to the analysis. I'd appreciate it if there is any way to come over this! Thanks,Nourhan

I'm dealing with an issue in Action Flow. I have a text cell within an xlsx file that needs to be parsed using regex, and this data needs to be saved into a new table. I can handle this initial part using the text parser, iterator, and array aggregator, but it results in the data being separated into operations. I have around 5k records to process and iterate through, which ends up generating more than 10k operations. What I want to do is aggregate all of these into a single file, thus avoiding the need to make 10 thousand HTTP requests. Does anyone know if this is possible?   

Hi all, I am new to Celonis and I am trying to upload the data model using excel / csv, however the time value looks different when i upload it to Celonis. Would you please help to see how can i show exactly the same time on Celonis? Thanks in advance! Time value in ExcelCelonis

Hi all! First time here, but god a question. I am running a python script (pycelonis 1.7.6) that needs to push data into a table. Everything work fine unless the data push:  datamodel.pool.create_table(df_or_path = res,table_name = 'TABLE_NAME',if_exists = 'drop',column_config=column_config)  which returns: [2024-07-23 16:26:09] INFO: Data push job status: QUEUED...[2024-07-23 16:26:14] INFO: Data push job status: QUEUED...[2024-07-23 16:26:19] INFO: Data push job status: QUEUED...[2024-07-23 16:26:25] INFO: Data push job status: QUEUED...[2024-07-23 16:26:30] INFO: Data push job status: QUEUED...[2024-07-23 16:26:35] INFO: Data push job status: QUEUED...[2024-07-23 16:26:41] INFO: Data push job status: QUEUED...[2024-07-23 16:26:46] INFO: Data push job status: QUEUED...[2024-07-23 16:26:51] INFO: Data push job status: QUEUED...[

Hi all, I was trying to export OLAP table data to excel but couldnt find the export button, where can I enable this? Thanks!

Let's say I have two tables:  - TABLE A: User ID, many other cols. [PK is User ID] - TABLE B: User ID, many other cols. [Many lines per User ID] Is there any way I can go through each User ID in TABLE A and do in the SQL transformation something such as: Declare TABLE C for each User ID in TABLE AAppend TABLE A.User ID, TABLE A.Name in TABLE C Select * from TABLE B where TABLE B.User Id = TABLE A.User IdAppend TABLE B.User ID, TABLE B.Other Field in TABLE C The idea would be to create a table in which you can find each line in TABLE A followed by every line for that same ID in TABLE B. Sorry for the poor SQL terminology, as I am not very used to it. Thank you so much in advance.

In my studio settings and/or package settings I am missing themes creation option. How can I configure a theme/colour/logo template -> https://docs.celonis.com/en/2442167.html

Basically, delta load captures when there is any change, update, insert happens based on the Change date like CPUDT, UDATE. But when we have the ERDAT as delta filter it will just capture the new record but what will happen to the Change ? Does any one tried this or come across this senario?

Hi Team,I need assistance with building a Generative AI-based use case in Celonis. As a starting point to understand the various functionalities of Celonis, I aim to develop a basic chatbot system.Here’s where I need help:I want to create a view in Celonis that mimics the look and feel of ChatGPT, where I can ask questions related to the data and receive responses.I have successfully integrated OpenAI with the Machine Learning Workbench, but I’m not sure how to trigger the Machine Learning Workbench from my Celonis views using a button click and display the response appropriately.As I am new to Celonis, I would greatly appreciate a detailed explanation.Thank you for your help. TLDR : Help me understand to built the UI, where i can write in input box my query, on click the button i want to run my ml work book code and then show it as a text response on my views(my ml workbook has open-ai integrated)

Hello everyone, I am trying to call a ML python script from an Action Flow with some parameters. Do some math with it, and give a response to the same Action Flow.Following the documentation in Trigger Machine Learning Script (celonis.com), I have been able to call the Python code, pass some parameters, process them and then call a NEW Action Flow. Is it possible to make the first action flow wait for a response and make a GET or something similar so you continue in the same action flow? Thank you,Federico Arribas. 

Hi, I have been trying to build a filter in the new view based on a variable - but couldn't get it to work. Target filter should look like this (and the explicit example below works): FILTER "DEV_CUSTOMER_HIERARCHY"."KUNNR" in ('9000100043','9000100188','2000000007') The variable contains a list of strings, each string enclosed by single quotes, separated by a comma, see below - as I couldnt make it work I tried different versions in respect to start and end of string (with or without parentheses and single quotes) ('9000100043','9000100188','2000000007')'9000100043','9000100188','2000000007'9000100043','9000100188','2000000007 I didn't get any of these filter expressions working: FILTER "DEV_CUSTOMER_HIERARCHY"."KUNNR" in ${path_from_top}FILTER

Hi everyone, I would like to create a chart where I show for each month the number of cases that satisfy some conditions in terms of process activities. Specifically, I need to count the number of cases that every month end with activity A. Therefore, if a case at the end of the May and at the end of June ended with activity A and in July it ends instead with activity B, I want to see it in both the column of May and June but not in the column of July.I tried to combine the TIMELINE_TABLE function with the MATCH_PROCESS function but it only takes into consideration those cases that satisfy the requirement today.Do you think it is possible to get what I need?Thank you in advance for your help!

How to enable "Label: True" in Histogram for New View?

I want to add descriptions to KPIs and predifined filters in my view so that this description is shown when the user hover over. I tried to do so in the KM, but nothing is shown and the components themselves don't have the label or description field. Any idea how to do that?

Hi, Please help.I want the blue bars to be broken up /split up into vendor names, so if there is 2 vendors their order values should add up to the total stacked on each other.id: chart-c1c15300-c92b-4d97-8598-b90b8aa0069dtype: chartsettings:  limit: 20  sortBy:    - id: f8639d07-e8cb-4f72-b6b4-16da36b1d74b      field: KPI_PO_ITEM_THREE_WAY_MATCH_ORDERED_VALUE      direction: DESC      order: 100  visuals:    - id: 3eabb17a-7f5a-43d1-8d50-0d24bfa526e8      mark:        type: bar        bandwidth: 0      order: 100      encodings: {}  encodings:    x:      field: PO_ITEMS.MATERIAL_GROUP_MATERIAL_GROUP_TEXT    y:      field: KPI_PO_ITEM_THREE_WAY_MATCH_ORDERED_VALUE

 Hi, I'm attempting to create a PDF report that includes a time filter, such as a start date and end date. The timestamp column in my data is currently in the format of "Mon Feb 28 2022 11:45:11". The values in the timestamp column are in the format of YYYY-MM-DD HH:MM:SS. I've set up a filter using the following code: FILTER "table"."column" >= TO_DATE({{13.Start_Date}},FORMAT( '%Y-%m-%d %H:%M:%S' )) AND "table"."column" <= TO_DATE({{13.End_Date}},FORMAT( '%Y-%m-%d %H:%M:%S' )); However, I'm still receiving an empty PDF report. Could you please help me identify what I'm doing wrong? Thank you.

The PQL statement is FILTER ("ACDOCA_AP_SUSPENSE"."AUGBL" IS NULL OR "ACDOCA_AP_SUSPENSE"."AUGDT" >  {d '2024-06-02'}) AND  "ACDOCA_AP_SUSPENSE"."BUDAT" <=  {d '2024-06-02'};The above PQL statement works fine when I hardcode the date. I have created a date variable in a view(Is it possible to default it to the current date?). I want the user to select a date from the date range component, the date variable gets updated from the END date of the Date range and the PQL statement gets executed based on the selected date. But for some reason, it does not work for me. The PQL Statement is FILTER ("ACDOCA_AP_SUSPENSE"."AUGBL" IS NULL OR "ACDOCA_AP_SUSPENSE"."AUGDT" >  {d '<%date_filter%>'}) AND  "ACDOCA_AP_SUSPENSE"."BUDAT" <=  {d '<%date_filter%>'}; The error I get is attached in a screenshot.Any suggestions on fixing this or alternative solutions would be appreciated.

Is there a variable in PQL that I can use to display the datamodel refresh date & time?

Hi Everyone, I want to ask if exists some way to extract data with PyCelonis lib but based on SQL scripts ( with transformations, for example). I know that we have access to the SQL script by this example: https://github.com/celonis/pycelonis-examples/blob/main/pycelonis1/03_Connectivity/05_Transformation_Download_to_MLW.ipynbbut my idea is to use this SQL and run it and export (.csv files ) or work this data with Python ( pandas data frame ) .

I am trying to bring in LIKP fields like ZZCarrier, Delivery number into VBAP. In the transformation while doing a left join i get duplicates per case key in VBAP. Is there any other way to bring in Likp field into VBAP?