Ask questions and get answers about Celonis products from experts and peers.
Recently active
I want to create an action flow, when I filter the data into the views, according to the filter data action flow triggers and send only the filtered value.
I have created a custom extractor to Extract Success Factors Data using Basic Authentication. When I am generating response, I either get no response or incorrect response for datetime columns. Has anyone faced this before?
Permissions required to read excel fill from SharePoint to celonis ML workbench?
In the apps, we are building insights around missed deliveries. There is a field where user can add comments of what happened and some investigation, however, there is a character limitation which is not highlighted upfront. What is the exact limitation? Can it be changed?
Hello everyone, I'm trying to calculate wit PQL different metrics like the Number of cases which flow through a certain process with specified activities . I'm using activity_lead and pu_first for that. For example (this is the PIZZA CASE): SUM( CASE WHEN PU_FIRST("CASE_TABLE", "EVENT_TABLE"."ACTIVITY_EN") = 'Order by phone' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 1) = 'Start preparing pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 2) = 'Start baking pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 3) = 'Baking pizza ready' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 4) = 'Plan route' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 5) = 'Departure pizza' AND ACTIVITY_LEAD("EVENT_TABLE"."ACTIVITY_EN", 6) = 'Pizza arrives at customer'
Hello everyone.I'm having some trouble trying to understand how this kpi works. KPI(PURCHASING_LEAD_TIME_MARC_PU_AVG_PARAMETERIZED,${SSL_TIMEFRAME_VARIABLE},0) PURCHASING_LEAD_TIME_MARC_PU_AVG_PARAMETERIZED--> this is another kpi in KM which I have figured how it works. My problem is that I do not know how the other part (,${SSL_TIMEFRAME_VARIABLE},0) is exactly affecting the result of the main KPI. Hope someone can give me a hand here. Thank you all!
Hello, i'm not able to access course content, i don't see the start course bouton for many courses, here is an exemple: create-background-filters-in-analyses
Hi all,I have an Action Flow where I use the Get Rows Module to get KPI Value from the KM. Then I use the Separator and do a filter on the on side to track if KPI1 > KPI2. But it doesn't work because the KPI values are somehow formatted as <text>. How can I do the numeric filter on the KPI's?
my badge are not comming
How to change the language of courses? I am new to Celonis and I'm doing the kickstarter course, whereas the should be a green dropdown menu to change the language of the course, but there is none. And the old method with rescheduling also doesn't work.
I was not able to find selection views functionality in Views which is present in Analysis and which helps very well in slicing and dicing the data.
How do I add language to a button in views, so that when it is clicked the entire view language changes. for example: English and germen, when clicked on English then view appears in English same for germen.
I have a “Case Table” table. This has 2 columns “Case ID” and “Target date”. I also have a 2 table “Horizon” with 3 columns “Case ID”, “Start date” and “End date”. The relationship between the tables is as follows: “Case Table” N : 1 "Horizon". The primary key is “Case ID” Target with the help of a PQL:I want to build a graph where on the X axis are the days and on the Y axis are the number of target dates.If the “target date” from the “Case Table” is between the “start date” (exclusive) and “end date” (inclusive) from the “Horizon” table, it should be counted. Example (The case ID of both tables is the same “Case ID” = 1): Target date = 20.09.2024Start date = 18.09.2024End date = 22.09.2024 Result:X axis: 17.09.2024; Y axis: 0X axis: 18.09.2024; Y axis: 0X axis: 19.09.2024; Y axis: 1X axis: 20.09.2024; Y axis: 1X axis: 21.09.2024; Y axis: 1X axis: 22.09.2024; Y axis: 1X axis: 23.09.2024; Y axis: 0 A 1 is added for all days where the target date lies between the start date (
I am trying to configure a comment component in the new views. I followed all the steps in the documentation but it is still not working. Is there additional documentation or other steps to configure the component that is not in the documentation?
I have number of files in pdf/word format. These are POD/BOL for an individual lineitem. I want to create a new column called as attachment where these files such as POD/BOL are available as hyperlink. Fileformat is in InvoiceNumber_BOL.pdf or InvoiceNumber_POD.docx . Is there a way to automatically attach the document to a particular line item and show as hyperlink.
I just want to understand what are the limitiations you may have faced while using a MEL model. Alos is it eveb a good option to use Multi-Event Log and are there any alternatives for the same ?
I am trying to add Custom object to the perspective without linking it to any object. Similar to currency conversion object. Table/Object that i am trying to add is TFACS for Workday Calendar, But result in below error.
We are using File upload data connection. I forget the datatype of column, so can anyone help in writing query like how I can find the datatype of column.
I was under the impression that Task Mining has this capability and, EEK, I found out differently just days before closing this deal. Please answer quickly as I need an answer tomorrow, if possible. If you can give me maybe the cost per invoice, that would help.
I'm looking at the IM started kit and excessive inventor. I see "Active Stock is defined on a SKU level, and is calculated by taking the the ratio between Target Stock and Actual stock." How do I see what the target stock level is to better understand the calculation?
Hi all, Question related to variables and images. The Image component works with a http URL as the input; I am attempting with not much luck to make this image interactive with input dropdown filters which are linked to a variable. Then editing in the YAML editor to insert a case when statement that would point towards a different image URL depending on the selection. As mentioned I'm not having much luck on this and wondered if this was possible or anyone has dealt with this before? Thanks in advance!
Hello All, I want to check of the fourth character in a phone number and make sure it's / and also make sure the 8 character is a dash - How would I do that? Example 314/789-9696
Hi, As title, in the new view, can you create a stacked column and line graph? Can it be implemented into components? Best RegardsSew
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.