Product Q&A

Data-model is not working for task mining. The activity log is appearing in Data models, but when I create analysis based out of data model, I am getting 'No Process is Configured'. Anyone, Any thoughts?

Hello, I am looking for something similar to a lookup function in Celonis. Is it something possible? I have a child table "X" linked to Parent table "A" another child table "Y" linked to same parent table "A". Both links are based on different keys. I want to lookup a value from X to Y is it something possible as in is there PQL formula which could help me do that? Thanks.

I have been trying to carry out the data engineer course and in when doing the "Access Source System" step in the Process Connection basics, it tells me to go onto the event collection page and create a data pool. However, an error appears in the bottom left corner as shown below  

We are trying to connect to SAP ECC using uplink connector, post Test Connection got successfull, tried to create Data Job and trying to load tables but not moving ahead from log "Job not yet started in SAP. Current status: SCHEDULED", so it could be issue in SAP RFC module, unable to understand the issue please suggest.

I have currently one data pool where I have 3 Data models. I want to use data in O2C and P2P together. How do I make it possible. please see both data models attached. Is there any additional information that you might need? I want to be able to use data in VTTK/VTTP tables together with P2P.

HI, I have embarked on learning the usage of MERGE_EVENTLOG in Celonis Snap environment. I cannot set two tables as Activity Table at the same time, making it unable to go further investigation.How could you set several tables as Activity Table (and Case Table as well) at the same time?

Hi team,How to extend the result rows for more than 100 or to export the transformation query result to excel?If not from transformation, is it possible to do it via Machine Learning workspace? Is it allowed?Thank you

Hi, I would like to know what I have to put on the "realm" box when installing a connector from the EMS to connect to an APP. Thanks

Hi all. We have created 6 activity tables, and allowed the data model to create a merged activity table. When I add the Case explorer component, it isn't using the merged activity table, but defaulting to one of the 6 we've created. Also, for the conformance component, I've allowed celonis to mine, and this too is defaulting to the same activity table. Do any of you know how to get these two components to use the merged activity table?

Hi Community, I would like to align my text vertically. Is there a way to do this in the BB code function. I am using Celonis 4.5 Thanks, Anna

Do you have a tips how I can create the sorting numbers? Do I have to create the sorting number while i running the procedures to create the event log entries afterwards when the event log is created? But I don't know how to define the sorting number with SQL.

Hello All, I have a csv file (attached a screenshot of the same) which has the Case ID (column A), Activity (Column N) and the Timestamp (column O) in the correct format. There are also other columns in the file that I will be using for my analysis. The error (screenshot attached) says that there are more than 100 empty cells within the Acitivity, Timestamp and CaseID columns but I have double-checked and can confirm that, that is not the case. Has anyone experienced this before? What could be the issue over here?  This is an urgent matter so any quick responses would be much appreciated! Thanks!@1460045682​ ,@joos.buijs​ , @hugo.victo11​ 

Best 20% and worst 20 % Cases based on their duration Hi everyone, we are looking for a solution to the following problem. We would like to get the best 20% and worst 20% of the Cases based on their duration, including all cases that fall between the scope, e.g. in a pie chart.So we could filter on the specific cases that are in the defined scope and as an output we would like so see them individually (with Case Key and their specific duration) in an OLAP table. Does anyone know what formula to use to get the relationship to each other?

Hello everyone, Can someone please share details of week one courses?

Does anyone know how can you remove disk space (hence reduce APC consumption) removing specific rows from a table? I would need to remove permanently rows from a table based on a specific sub-query. I have limited space available so i cannot use operations that require, even for a small period of time, twice increase in space occupation Thanks in advance  

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"