Product Q&A

Good day, Is it possible to save grouped activities and then do calculations on them, such as throughput time between grouped activities? Would REMAP_VALUES be the right statement to group activities in PQL?

How can I enable the Transformations Center in my Sandbox team? Currently I don't the the option in the "More..." drop down menu.

We want to migrate our Views and Analysis from 1 Celonis environment to other. Is there any quick and easy way to do this? Our last option would be to make the data model from scratch.

Hi Team, Objective : We are doing holistic assessement of our current lanscape.We requrie list of all the componests in related sequence:1)Data integration : i)Data Pools ii)Connections iii)Schedules iv)Data jobs v)Extractions vi)Transformations vii)Data models2)Studio : i)Workspace ii)Assets Could you please advise how we can get this in a faster way not doing it manually.Are there any standards scripts which Celonis has to provide this information?  

I am trying to connect my SQL Server to Celonis to extract data from one of the created databases. It's unable to connect with the following error "Test ConnectionThe connection test failed, please check the Data Connection's configuration and ensure that the system is running: Telnet connection to the host ###### failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions."I have enabled telnet, and checked host/port settings,. Also, I tested the connection using DBeaver and it works well there.Has anyone faced a similar kind of situation? Any help would be highly appreciated.

Hi, If a Data Job fails, then an email has to sent to a DL (which contains 10 emails) - Is this possible? I don't see an option for it. All I could see is 'Enable Alerts' in the Data Job Settings, but it will send an email only to me. Any Thoughts?

We have a model with four event logs. If a case has activities in three event logs and no activities in one event log, it appears in the Case Explorer but not in the Process Explorer. What could be the reason for this and how can I fix the problem? Many thanks!  PS: This problem is only in the view, not in the analysis. 

Hi all, I need to filter some instances occurred on sunday and on holiday. Is there a PQL function that can help me out?Something like this:CASE WHEN DAY_OF_THE_WEEK("EVENTTIME") = 'Sunday' or HOLIDAY("EVENTTIME") = 1 THEN "ID" ELSE NULL END Thanks! EDIT: Solved the day of the week part, still missing the holiday one

How to upload data(in csv format) to studio?

I was thinking of reading all the fields of the table and then performing a group by. Is this the right way?

I need to count the number of invoices which follows a process flow 'Payment after Due date passed'.

I'm doing a date change analysis to understand how many days a sales order delivery date is changed up or out. I have the change from and change to dates. Anyone know of a way to incorporate the day of week? Ex, changed from monday to tuesday?

Usability of MarketPlace Connectors in "REALITY" Hi Team,I have started my market place journey by installing SAP "Order to Cash" Connector. Below was my experience :1)I tried to install the app in studio but it gave multiple errors for the Data Model.2)I looked at the data model and tried understanding it. -There are no documents to understand why that data model is build in the way it is.3)I looked at standard SAP tables and tried to understand it by looking into transformation.4)Transformation does have big quereis and most of the places there is no explanation of what does those quereis mean.5)I finally reached SAP functional consultant and technical resource to help me understand the quereies.6)Currently i am working with them and reverse engineering to understand what has been provided with connector.7)Parallely i raised a ticket to Celonis support for providing comprehensive documents but they responded they do not have comprehensive document but shared the b

Hi team! we downloaded the procurement starter kit and the P2P S4HANA Connector. There are some KPIs that request the TCURR, TCURF, and TCURX, but there is not any transformation for these tables inside connector Do you know how to add those tables?

Iam trying to find out or compare RC vs Delt job vs Full Load, when to use and why

How many characters are supported for naming convention for any object in Studio? For example if I am naming a ID for a KPI, how long can I keep the name? Do we have a constraint in that?

I have the PQL query as follows:  it returns:   How can i amend my query to remove the '0' counts for processes that do not have any rework on them? Thanks

What is the best way to have a good overview of: 1) activity durations 2) waiting times between durations As far as I understood, Celonis can show me the duration between activities (waiting time). What about the activity's duration itself?

We have table A (case table) and table B connected to A as 1:N relationship, 1 A has N BsWe want to show in an OLAP table A and B, and we want to aggregate SUM(B) for each A, so we can use SUM or PU_SUM. We are using SUM because we want the result of SUM(B) to be affected by filter selections. If there is A with missing values at B side we would expect to see A and NULL at the B column However we won't see anything unless we apply PU_SUM(B), and as said above, PU_SUM doesn't support filter selections so it cannot be used for this use case.Is there another way to see the A values together with NULL values at B column?

Hello! I've been having trouble with my queries in the Accounts Payable Case Study Training. Specificaclly, in the section 'Transform - Add an Activity: Set or Remove Payment Block'. I've been able to insert all the other activities without any problems, but I'm stuck at this one. Here are the instructions:   Here is the codes I've tried at first: ```INSERT INTO _CEL_AP_ACTIVITIES( _CASE_KEY, _ACTIVITY_EN, _EVENTTIME, _SORTING)SELECT  BSEG.MANDT||BSEG.BUKRS||BSEG.BELNR||BSEG.GJAHR||BSEG.BUZEI AS _CASE_KEY  , CASE    WHEN CDPOS.VALUE_NEW IS NULL THEN 'Remove payment block'    WHEN CDPOS.VALUE_OLD IS NULL THEN 'Set payment block'  END AS _ACTIVITY_EN  , CAST(CDHDR.UDATE || CDHDR.UTIME AS TIMESTAMP) AS _EVENTTIME  , CASE    WHEN CDPOS.VALUE_OLD IS NULL THEN 20    WHEN CDPOS.VALUE_NEW IS NULL THEN 30  END AS _SORTINGFROM BSEG AS BSEGJOIN BKPF AS BKPF ON 1=1  AND BSEG.MANDT=BKPF.MANDT  AND BSEG.BUKRS=BKPF.BUKRS  AND BSEG.BELNR=BKPF.BELNR  AND BSEG.GJA

so here if the count is just one then i just need to display 1 in the legend/axis. it should not show 200m, 300m.... etc. is there a way to achieve it?

I have calculated the date difference between last load ("Table1"."Column1") and today: DATEDIFF(dd, "Table1"."Column1", TODAY() ). I would like to apply a component filter to my OLAP table to see only the newest cases. I have tried with FILTER MIN(DATEDIFF(dd, "Table1"."Column1", TODAY() )); but no result. How should I reformulate my filter to get rid of the error I get?

Is there a way to view the table structure in data integration? something like "Describe Table_Name" which returns the columns, data types details of the table passed.

essentially i want to bucket cases based on where their latest event is.  what would be the best PQL clause to use in this instance?

Hi, I have the following use case and challenge: Use Case: Add a line as second KPI to an existing column diagram that shows the average of a KPI value for each labor week Dimension: ROUND_DAY("TABLE"."TIMESTAMP") KPI 1: COUNT("TABLE"."NUMBER" || "TABLE"."FIELD") - columns KPI 2: Show the average of KPI 1 from Monday - Friday for each week - line My attempt: WINDOW_AVG(COUNT("TABLE"."NUMBER" || "TABLE"."FIELD"), 0, 5, ORDER BY("TABLE"."TIMESTAMP"), PARTITION BY(ROUND_WEEK("TABLE"."TIMESTAMP"))) This does not work unfortunately as I can not use the COUNT within the WINDOW_AVG function. Does anyone know any alternatives?