General Product Q&A

I want to complete the elective course Data Integration Case Study - Accounts Payable inside Get Data into the EMS, but I have some problem at the step Transform - Add an Activity: Enter Invoice in SAP. No problems when I write the code with the INNER JOIN, but I'm not able to run the code whit clause WHERE EXISTS. In attachment you can find both codes. The "WHERE EXISTS" code returns the following error:Execution error: ERROR: Missing FROM-clause entry for table "BKPF". Where I'm wrong? I tried to follow the syntax reported in the Get Data into the EMS course but I'm in a dead end. Thanks in advance.

I have a table like this: "Table1". And I want the records count (Single KPI) between the MIN("Table1"."Posting Date") and TOday-7 and "Table1"."Status"='In Progress'. I tried following PQL query:SUM( CASE WHEN ( DATE_BETWEEN ( ROUND_DAY("Table1"."Posting Date"), ROUND_DAY(MIN("Table1"."Posting Date")), ROUND_DAY(ADD_DAYS(TODAY(), -7)))=1 AND ("Table1"."Status"='In Progress') )THEN 1 ELSE 0 END) Note: Formatting = Rounded Number  But it is giving me following error:The aggregation function MIN cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs. Could anyone please help me out on this?

We have installed extractor in VM and established successful connection between them. We are creating extraction 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.

Hi Team, have built an action flow to push data to data pool. Getting status code error "409" and "runningJob":"34a865e3-f92a-491c-b05b-4e95cdb45420","message":"A job on the same target is already running. Parallel job executions are not allowed"

"Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Telnet connection to the host 3.120.99.40:1433 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."

Hi .. ..can anyone help on the Free sourcing (Contract Management) connector and detailed activity list. We also required best practice used to develop a connector.

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 ?