Product Q&A

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

Hi all,  I have questions about SAP onetime data download ABAP program.Doese anybody give me the screenshot for selection screen sample? I mean, I'd like to know the syntax to write in selection scree, such as comma separating or if I need to use quotation to define table name.Is all data extracted if I push Execute extraction in background if I write selection condition to custom table data download field? (I mean, will data be downloaded wheateher O2C data + selected data or only selected data?) (In case I'm using O2C download template.) Regards,

Hi All, I'm wondering if there is an option to see history of augmented attribute? Let's take a look on below example: If we are changing status (augmented attribute) to "Urgent", we always want to see this case with priority "High", no matter that we will change this status to "In progress" later on. Priority field should works like IN() formula - we want to check if at least once this status was used so the priority can be assigned properly. In addition to that, can we somehow see the history of those changes in simple table? For example three columns - date | user who set the status | status.And I'm not talking about Activity History which seems to not be very customizable and is showing each field as separate change. Many thanks in advance for your help!

I want to insert date-time data from one table to another but I am getting Execution error: ERROR: Column "event_time" is of type timestamp but expression is of type varchar error

How can I pass data from all the tables from a view on a button click to a webhook, if through YAML then how can I configure it in YAML?

To join these 2 tables I use the fields "MANDT" and "AUFNR".In the table B, there can be several dates for the same order (AUFNR) and in table A I want to have only the most recent date for the order.So I tried the formula LAST(table.date ORDER BY table.date ASC) but it did not work. CREATE VIEW PP_QALS AS (  SELECT DISTINCT    "QALS".*,    LAST("AFRU"."IEDD", ORDER BY "AFRU"."IEDD" ASC) AS AFRU_IEDD,  FROM QALS_U_PP AS QALS  LEFT JOIN "AFRU_U_PP_TEMP" AS AFRU ON 1=1    AND "AFRU"."MANDT" = "QALS"."MANDANT"    AND "AFRU"."AUFNR" = "QALS"."AUFNR"), Do you know how I can add this date field in table A ? @lovise.helln​ (FYI)