Product Q&A

UTC TO LOCAL TIMEHello, I'm curious if anybody else has already faced the following issue: For some tables, timestamps are stored in UTC in SAP, although in display mode of transaction timestamp is shown in local time. This leads to UTC timestamps for activities in Celonis and can cause confusion of end users.  I already tried SQL best practise to transfer UTC in local time but standard operations/ local time zones are disabled in Event Collection. SELECT GETDATE() only provides UTC (Vertica base)getutcdate() is not supported (Vertica base)SELECT * FROM sys.time_zone_info is not allowed/missing rights (SQL Server base) It would be better to avoid hard coded transformations due to summer and winter time in Europe which will lead to maintaining effort. Does anybody else has an idea how to transfor UTC in local time?  Looking forward to hear your experiences!Greetings from Germany,Jasmin

API Key vs. Bearer Token for Data Push API Hi all,  We are trying to push data towards the EMS using the Data Push API. In our tests with Postman, we were able to do this, but we found out that the API key in the EMS should be used as a Bearer token.In the application we use, a Bearer token can only be obtained by requesting it from a authorization endpoint.Moreover, we cannot use the Celonis API key as a REST API key authorization, since you need a key name for that (and this is not the key name in the EMS). Has someone of you experienced the same issue, and is there a workaround for it?  Kind regards,Jan-peter

Good morning everyone, Is there a way for me to extract more than 100 rows of data from the Transformations / Event Collection workspaces? For some context, we don't have access to the SAP environment from where we are extracting the data; we do, however, need to provide a considerable sample of the data we're working with to validate with the team. If I do a regular SELECT * FROM CDPOS for example, I will only be able to get 100 rows of data at a time Thank you in advance! P.S: Apologies if this is not posted in the appropriate place!

Any of you have "play" with the Task Mining Quickstart - Workforce Productivity? I have tried with the template button, and I get a white browser page. In the other hand, I have tried also with the create from the scratch, following the instructions, but the client in the PC seems not to be able to upload the data to the server.That is, at the end, I was not able to test any Task Mining functionallitily :(

MasterplanWhile CoEs are the key accelerator to drive success, daily work might drag you too much into process- and technical discussions. In order to drive sustainable Value a CoE should keep an eye on five complementary streams. The following one pager can be used as template for discussing and managing all relevant streams.Hope it helps, keen to get your views

Hi Team -  I am working on developing a business case to develop a business case at my company. I want to show the value and the business benefits exist in developing a CoE. I understand the value and have a vision on what I want to accomplish with a CoE. Does anybody have a business case or presentation I can leverage in developing a business case to our leadership to getting a CoE established? Any other feedback is greatly appreciated.Best,Paresh

Hi Celopeers :) We have a specific use case, based on JIRA data. For a case a limited set of activities (~7, JIRA stories) need to be performed. For each activity (/story) we know when it was ready for pickup, in progress, and done (or rejected). If we would like to calculate the total time the activity/story spent in the status 'in progress' I was thinking of something like this: SUM( CASE WHEN "TABLE_STATUS"."STATUS" = 'In progress'   THEN HOURS_BETWEEN("TABLE_STATUS"."STATUSDATETIME",ACTIVITY_LEAD("TABLE_STATUS"."STATUSDATETIME")) / 24 --to get fractional days   ELSE 0.0 END) Where the dimension could be the different activity/story names for instance. However, the activity_lead often is a very different activity (/JIRA story), hence the calculation fails.I also cannot use a process pattern matching using first and last occurrence, as an activity can be 'in progres' multiple times and I would need to

Hello, Celopeers! This is my first attempt at what will (hopefully) evolve into a series best-practice forum posts. If you have any questions about anything I share here, please do not hesitate to ask. I also encourage you to follow along with this post, so please log in to the EMS! In my four years here at Celonis, I've asked (and have been asked) many, many questions about our platform and its capabilities. The top 5 questions I've seen (and continue to see) asked are: Can we establish a connection to source system ABC-123? How do we do this? Is there a step-by-step guide?How can we manage access to our team? Is there a step-by-step guide to setting up SSO?Do we have a PQL function that can do XYZ? Are there examples of function input and output?What are our options for editing a specific component in our analysis?What features of the Celonis EMS are currently available? Can you tell us about them? I'm happy to say that the answers to these questions (any many more which

I´ve seen that in the Vertica documentation there is a function called „LISTAGG“, but it seems that celonis do not support this function. Thanks in advance for your help. 

I want to understand the rationale behind creation of the automatic data extraction field: "_CELONIS_CHANGE_DATE"

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 :(