Product Q&A

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 "DEV_CUSTOMER_HIERARCHY"."KUNNR" in (${path_from_top}) the filter is flagged with a red

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?

Level 1: Newbie (0 - 10 points)I just join Celonis. Help me to explore Celonis Platform!

I want to add days to a date in vertica SQL in transformations. I have tried using DATEADD and TIMESTAMPADD, both are showing permission denied. Please help how can i achieve this.

Hi, I wanted to create a pdf report of an analysis sent to my mail account. Therefore, I created an action flow with the Celonis module "create PDF report".To filter the analysis to get the correct data, I'm using a runtime variable which needs to be implemented in the action flow.I implemented it as you can see on the first picture. The result of the pdf report is, that it doesn't show me any data in my charts as you can see on the second pic.  Thanks for helping me.  Niklas

Hi All, I am trying to create a overlay view in new studio, created a target view as well. However when I click on the sales order in my main view the target view value is not updating, mapped a variable as well

Hi All, This is the detailed explanation regarding what Information I have, what steps and option I followed to make this connection:Steps followed: Add Data connection-->Connect to Data Source-->custom-->Build Custom Connection-->Build a new extractor: (1) Extractor Information: Input provided in the Name filed(2)Connection Parameters: Unchanged(3)Authentication Methods: API Key Authentication Selected and In the API Key header: Key generated from admin setting was entered .e.g. x-api-key:"Generated Key".(4)Define Endpoints: Add new endpoint--> (A)Configure Endpoint:  Endpoint name(entered)-->HTTP Method(GET)-->Use this endpoint for connection test(enabled) (B)Configure Request URL: {Connection.API_URL}/"Endpoint URL entered"Request Parameters: Leaved as it isHeaders-->Add new header-->"Key and Value" enteredPagination Method: Leaved as it is (C)Configure Response: Leaved as it is Clicked Fininshed. 

Hi team, Is there any way to link power apps to celonis to enable workflow mechanism.

I would like to create a KPI to determine the % of the confirmation date changes which were caused by a requested date change in the Order to Cash activity flow.If the 2 events: Requested Date Change and Confirmed Date Change happened at the same time and with the same change number (which is stored in a separate column in the activity table), we assume the confirmed date change was caused by the requested date change.What would be the best way to check for this? SOURCE? TARGET? ACTIVITY_LAG/LEAD?Any ideas are appreciated. 

Hi team, This is related to PQL function CURRENCY_CONVERT_SAP. I want to know how this field GDATU from TCURR table is converted to date once it is in string in celonis.

I am trying to upload FK company logo using YAML script in new view. Below is the coding of image uploading. I am not getting any error however image is also not appearing in front end.Please Help. id: image    type: image    settings:      src: data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALIAAAA1CAYAAADlP7EIAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFiUAABYlAUlSJPAAABDqSURBVHhe7Z0JdFXFGcfdal0qLtVqF5daW6217rba2oW61H2ptdtpra0giqAiIqIoiwJVEYEiiGJFUVlUNkEBKUmABEJIQkgIEEJCCEsWEkjIBgGm87u5kzd37ryXPAL0CPM/5zvAvd9d3tz/zHzbDIedc/ZZwomTL7scJhwcDgI4IjscFHBEdjgo4IjscFAgQOSahl2ifPtOq+xo3O1rRbB7zx5RWdto1a+o2Sn2+Ho66nfutuojtfL5Dg57gwCRczfViCv7p4nLDblCymtz1ovGXUFqSh6LgTPXhfSRaweli/mrt/qaERSW14sbXs20XtPpvVUe0R0c4kXItHjw3VXisAfmheT8ZxaLjVt3+FoRbKlpFF9/bIH1mr+NyRUNlpG81yf5Vv2Tus4XM7K2+FoODq1HiMgZRdvFVx5MCJHsiA4JYuKSUl8riF6frA3pIxC8uKLe14qgtKpBHPtQovUaOtJum03i4BADISJv3NogvtszxUqye0dm+1pBLMjbJg7vENZHpmaW+1pBXN4vzap/Sd9UsdMwYRwcWkKIyFuk0/XTF5daSXZxn1RfK4jsDTXia52TrNcM+6LY1wrirhHLrfqnyVHc5lg6OMSC

Hello everyone, I want to create a dimension switcher within a view (s. example from a Celonis App). In the installed APP, however, I cannot access the originial knowledge model as the one visible is an extension. Hence, I do not know how the configuration of a dimension switcher is done on the YAML knowledge model side.  Does anyone have a step by step explanation?Thank you! Best regardsJulia Bauer

Hi Celopeers,  Is it possible to create an overview (i.e. Olap table) of all Celonis users (per group), and set up an action flow with this info (i.e. send a list of all users to specific email addresses monthly). Does something exists about it? I`m looking for smth that automates the manual process: manually going to Admin/Users & downloading the user list.

Hi everyone,I am currently playing with features like the PAM in OCPM and stumbled across something that struck my mind. I remember that in the context of case-centric Process Mining, Celonis is using a Token-based-Replay variant for Conformance Checking. Within the PAM (Process Adherence Manager) for OCPM, there is now an "Alignment Explorer" available. Is this based on Alignment-based Conformance Checking techniques, or is Token-based-Replay still being used for this? Is there a similar implementation of this in case-centric Process Mining? Tim

Hello All, I am trying to get a KPI PQL statement for SAP field KDATE(Date) when the date in the field = 9999-12-31 Has anyone done PQl statements like this before? Thanks for your help in inadvance