Product Q&A

Hi all, Id like to run the data job in O2C process conenctor after i connect IBC and SAP ECC. The extraction is done, followed by Transformation but failed, details as below - Error transforming data: SyntaxErrorException: [Vertica]VJDBC ERROR: Relation BSAD does not exist. Celonis Support ID: 473a50a9-aa4b-4f3e-8fc1-b3e280d9ce33 Or you can refer to my screenshot. Actually the data extraction for BSAD Table is done, so im confused why this error shows. image2362697 54.5 KB image18841072 177 KB

Hello!  I am in the process of developing a benchmarking tab to compare product performance. In using the button dropdown, I have indicated my wrapping characters to be single quotes, e.g. 'Apple' -- otherwise throws an error. I am facing issues when I try to select a product value that already contains a single quote in the name, e.g. Apple's. I have tried to use the backlash escape character but that did not work. Any help would be greatly appreciated!

Hi team, I have a question regarding the definition of a target value for a kpi list. According to the advanced configuration, it should be possible to turn "showTarget" to true. Nonetheless, I couldn't find a hint in the documentation about how and where to set that default value, as the KPI definition in the km doesn't seem to have a field name for its definition. Any help is much appreciated, thank you

We have a really complex query that was built out to extract data in flat files, but want to pivot to a direct connection. The query pulls from multiple databases, and we would like to avoid reverse engineering the logic as a large data job. Can we pull from multiple databases in one extraction, so that we can run the query we have built?

Hello, I would like to know if there is an option to make an automatic export of OLAP tables in excel or CSV. Would be interesting as well if the Action Engine could make it in a periodic manner. Thanks in advance

Hi everyone, we have 3 data models created on one schema (schema contains about 20 tables) we have a new schema created for a more enhanced feed from source, we transferred the data models over to the new schema but how do we setup the connectors to the new schema ? example a_schema has 20 tables feeding into celonis process view (3 data models), we created b_schema and moved the data models over, however we dont have the same connector feed, we need to update the celonis connectors to b_schema, is there an instruction list how we can do this ? anything at all will help thanks in advance

In my analysis filter I need a range over three month exactly.With this formular I get the last day of the preceding month:ADD_DAYS(ROUND_MONTH(TODAY()), -1) Today: 07.06.2021 Result: 31.05.2021This is the secound part of the BETWEEN order.Now I'm searching for the first formular in the BETWEEN ordersImilar to VBA: DateSerial(YEAR(Date()),MONTH(Date())-3,1)Is there a chance? 

Hello! i have a histogram chart where i am counting the number of cases bucketed into different completion rates (0 - 20%, 20 - 40%, 40 - 60% etc.). I would like to colour all the cases that have more than a 60% completion rate, but any formatting i put it seems to be only possible on the KPI side (i.e. number of occurrences). This also affects the position line option --> it turns out horiontal, rather than vertical. Anyone has a workaround? Best,Dom

So, I tried to solve it with a pull-up function. PU_COUNT("VBAK", "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN", "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Credit Approval Release') )   But the results do not seem correct to me:I do not think this offers a distinct valuewhen putting the KPI in an OLAP against the customer, I get duplicates for the customer. Another option that I could think of, made use of match_activity. However, this is then still at line item level.

Hi All, While working with multiple systems and Vertical Scenario (where different steps of a process are tracked in different source systems), do we have any documentation/ best practices on how to set up a data model? The training covers the Horizontal scenario in detail but I couldn't find any material for the Vertical scenario.  Any tips/suggestions would be helpful!!

Hello, Good day. Would it be possible to copy one data pool from EU-1 to US-1 via Machine Learning? If yes, how and what would be the ML code? Thanks, RJ

Unable to get Delta filter to work properly. Keep receiving the error "Field not found 'ekes.datetime' " because the delta filter is trying to convert the column to a datetime. I have been unable to find any documentation or post that would help for this situation. I am including screenshots to help show the errors. any help would be appreciated. Also, I tried creating a DATE parameter and a TEXT parameter and use them in the Delta Filter and the Date parameter gives the same Convert(datetime) error and the text parameter gives the error "Value 2021-06-01 19:05:26.0 could not be read as Text"

Hi all, I have a small problem with the calculation of the minimum variants depending on the company codes. My goal is to display the minimum number of variants as KPI. With my formula the number differs significantly compared to the KPI("Number of process variants") function. I think I need to add a distinct, but I don't know how exactly to do it.  Here is my code: MIN(  PU_COUNT(    DOMAIN_TABLE("VBAP"."BUKRS"),    (      SHORTENED(        VARIANT("_CEL_O2C_ACTIVITIES"."ACTIVITY_EN")      )    )  )) Kind regards Ilker

Hey, does anyone know, if - and if yes, how - it is possible to implement a subselect within an OLAP table in Process Analytics?Basically, we would like to build an OLAP table, where one column is being queried with input from another column from the same table. Specifically, we want to display EKKO.EBELN, EKKO.KONNR and EKKO.EKGRP, where the EKKO.EKGRP being displayed is not the EKGRP from the corresponding row, but from a different row, where EKKO.KONNR (from this row) = EKKO.EBELN.  In SQL, it would look like this: SELECT ebeln, konnr, (SELECT ekgrp from ekko WHERE ebeln = konnr) FROM ekko  

Are you experiencing issues when accessing snap URL? For instance, I'm not able to see the menu/bar at the right, and when trying to access some features, I get 403 page errors :(

Hi everyone, I would like to know if there are connectors ready to extract data from the Oracle HCM platform. We´re planning to use EMS to map and analyze personnel moves through positions, including transferences, promotions, demotions, etc. Thanks.

Dear Experts Does anyone know if Celonis OP system or the IBC Hybrid deployment supports Oracle database? Is there any customer references? Thanks!

Hi there, I would like to ask for you feedback to do the following: I would like to measure the median throughput time over time (per month) in two different column charts. Happy Path column chartThe first chart should display the median throughput time from "PR received" to "PO sent to supplier" where "PR received" is directly followed by "PO sent to supplier" (Happy path). The result should be displayed in a column chart: January - 20h, February - 23h, March - 18h etc. Non-happy path column chartThe second column chart should display the throughput time for all PR that didn't follow the happy path. This includes all PR request that did not go straight to "PO send to supplier", but had other activitites in between. The result should be displayed in a column chart: January - 40h, February - 46h, March - 36h etc. I am currently managing to get to the numbers seperately, but not displayed over time (per month) in two different column

I am trying to upload a CSV into my Celonis Snap, but when I upload it, I get a processing error that the "Number of fields does not match schema". Does anyone know why this is happening? I converted all of the columns to strings but did not help.

Mass Transaction Qualifier - We are currently trying to configure the mass transaction functionality. I am curious how others have coded this. Today it appears that it simply qualifies all activities done by a SAP user within 10 seconds (we can config the amt of time 10 seconds was recommended to start). All of these activities are classified as a mass transaction and they are all coded as user type "R" (again I believe this is the standard).  However, when you look at the actual business process and execution many if not all of these mass transactions are initiated by a manual user performing at least one of the steps.  Example: in P2P user marks "delivery complete' which triggers second activity automatically of set "final invoice indicator' in SAP even though user name is the same for both activities. Currently Celonis calls both of these activities "R" whereas we would like the initial activity to show as "A" because a user perf

Hi everyone, I created a Chart and face the problem that the expression of the KPI does not fit into the tooltip.   Option 1: Is there a setting to change the size of the tooltip box? Option 2: Alternatively I wanted to limit the characters of the variables. Could you help me to insert a LEFT or RIGHT statement? My syntax does not work. <%= MyVariable %> --> Full text is shown<%= LEFT(MyVariable,10) %> --> Only show the left 10 characters

Hi community,  I created a dashboard and would like to use a variable so that the end-user can easily switch between first-to-first // first-to-last occurrences. Could you help me with getting the syntax right. Thank you!

Hello, I want to create a variable that defines Area_of_Business. it would be a combination of the Department and Type of the Business. It is not a problem to create the variable but rather to integrate it into the graphs and diagrams as I cant use "CEL_CASES"."AREA"=Variable (dont have a column called "AREA") or "CEL_CASES"."DEPARTMENT"=Variable or "CEL_CASES"."TYPE_OF_BUSINESS" =Variable in the quiry. Any ideas how to implement it? Best,Maria

Please see error message:Data model load failed during table export: Data model tables: Quote_Header_xlsx_Quote_Header, Customer_xlsx_Customer contain more rows than the allowed maximum per table of 0. Please reduce the number of rows. Both tables are not bigger as the case table, so I cannot understand why the number of rows should be an issue.

Is it possibile to receive commercial deck and presentation in Italian?