General 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.

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?

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'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?

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?

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?

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?

Assume the data pool contains of AP, AR and O2C three processes. I want to delete AP process data, for that I have added an activity in transformation where I have droped all the tables related to AP process data and I have executed that activity and data load has been done. But no change in studio part and APC Consumption also, data got not reduced. Is there any way to delete the data ?

Good afternoon, Essentially we want to remove all 2021 Data, but we would like to keep our "Resolved History" for Use Cases in Action Views, that rely on Augmented Attributes. Would removing 2021 invoices, for example, cause us to lose all "Resolved Invoices"? How can we preserve this data? Thank you in advance! Best Regards, Vasco Carona, Solvay

Hi, we have a requirement to restrict extraction of purchase orders to last 2 years. We are planning to go ahead with ERDAT from EKKO table. But what about other tables like T*, CDHDR and the rest. How can we restrict data extraction in those tables? Also, How can we make EKKO as a parent table to consider the extraction of the rest of the tables based on the data from parent table like EKBE-EBELN = EKKO-EBELN?

Is there a way to automate the tasks captured by Celonis Task mining? I have captured desktop data/user actions for a task using Celonis Task Mining and data are loaded into EMS. After that, does Celonis provide any feature to automate (API or UI etc) those actions/tasks and run on any machine? Or need to use any RPA tool only for this automation?

For example, My KPI Query = SUM(Order Number) My KPI Component Filter is = FILTER NOT (ORDER TYPE = 'A') ; But; somehow I want to combine my component filter into the KPI Query? How can I do that?

I could able to successfully establish connection between SAP ECC and Celonis EMS standalone and the test extraction works fine. Now when I try to install standard SAP O2C connector with this connection, I get the below error. I dont get this error if I test the connection defined outside the connector. Request your inputs. 

we are having a bar chart with a single KPI but stacked by multiple selections. we want to set a default stack when no stacking option is selected when the dashboard is accessed. Is there any way to do so?  Snippets attached for reference.