Data Ingestion & Infrastructure

Hi, I want to apply a component filter to an OLAP table. The table initially contains only the case key and the event time. The filter should ensure that only the cases from the last month are displayed. I find the date of the last case with MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"). Then I subtract one month with ADD_MONTHS(MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"), -1). Up to this point everything works. If I then set FILTER "_CEL_O2C_ACTIVITIES". "EVENTTIME" > ADD_MONTHS(MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"), -1) as the component filter, it tells me of course that you can't apply a MAX function in the filter.  Is there a way to solve the problem anyway? Thanks a lot! Many greetingsLukas

I have alerts on data loading process, in terms if it fails it is sending to me. How can I do it for non administrator users?

Hi, I am trying to extract ObjectId from MongoDB via python. If I extract without ObjectID, extraction is successful. But when i am adding ObjectID into extraction I have started getting an errors. Can you please give me a solution/syntax?

After TM installation and data capture (including screenshots) where can we visualize the screens? And data is hashed?  Another concern is about data security. How to demonstrate to customer that data is protect and privicy is been follow?

Hi everyone, I hope I'm in right here with my question... We have Celonis 4.7.1 installed with production data, need to migrate the Potsgres databases to MS-SQL and are interested in documents on how to do the steps. Has anyone done this migration before? Regards,Daniel

Hi Team, The following problem was not solved, so when I tried using the connector for ECC, I was able to extract the data. https://www.celopeers.com/s/question/0D507000012uUWHCA2/how-to-resolve-errors-when-extract-tables-sap-connector Would you know that there is something issue with the S/4 HANA connector? Best Regards,Omachi Satoshi

Hi all, I was wondering if it is possible to create dynamic sql in transformation. I tried to use loops and define sql variables, however I didnt have any luck. I have never worked with Vertica database and seen some place that vertica has no loops, no arrays, no variables just a plain SQL database. I am not sure if thats true. Is this a limitation of a some kind? Thanks.

Extractions - Performance issues Hello, I am extracting data from a ServiceNow system. Sometimes it's quick and sometimes it takes a long time. To the point"Final Count: Loaded..."everything is always ok, but for the last steps "Starting load incident$sys_audit to target ..."until"Extraction successful"it is very different. 2022-01-11 08:59:15 INFO Extraction successful2022-01-11 08:59:15 INFO Table incident$sys_audit loaded ..2022-01-10 21:36:52 INFO Inserting extracted data into the Data Pool (this may take a while)2022-01-10 21:36:52 INFO Starting load incident$sys_audit to target ...2022-01-10 21:34:18 INFO Final Count: Loaded 5,450,395 record(s) for table incident$sys_audit2022-01-10 21:33:53 INFO Loading 12,276 records for table incident$sys_audit... In the best case, it takes 20 minutes and in the worst case >14 hours for extraction to be successfulWhat can be the reason? How can it be fixed Thank youHeiko

Hello I have the following problem: We have the AVG time cycle for a set of case and we want to obtain the % of cases with TC below de average and above average. I tried to do it in this way: CASE WHEN CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start']  TO ALL_OCCURRENCE['Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" ,  days))>AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start']  TO ALL_OCCURRENCE['Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" ,  days)))then 'TC > AVG'else 'TC <= AVG'END but I get the following message:The aggregation function AVG cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs. Which would be the correct way to have the information we need?  Thanks!

Hi Team, I got an error when running an Extracts data job after establish a connection with SAP.The description of the error is as follows: Error setting up extraction. Error executing function /CELONIS/FM_GET_TABLE_METADATA. Celonis Support ID: bb3af819-7bdb-4fe5-8ea6-f326c668079c Can you please give me a solution? Regards, Omachi 

HI All, We received a error when testing the data connection at a client on C4C+ project. The description of the error is as follows:  "Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Error making capabilities request to extractor: Remote application on http://uplink/uplink/api/internal/proxy/90574be94ecede1912b66868c75ec3994e77111b3c097720be3e1e94a41b3865/connector-capabilities[POST] responded with 500 : {"timestamp":1647536076176,"status":500,"error":"Internal Server Error","message":"Could not connect to middleware - client not connected. Client: 90574be94ecede1912b66868c75ec3994e77111b3c097720be3e1e94a41b3865, Channel: connector-capabilities","path":"/uplink/api/internal/proxy/90574be94ecede1912b66868c75ec3994e77111b3c097720be3e1e94a41b3865/connector-capabilities"} " The data connection first worked but after the weekend(11-12

I want to get a detailed view of the simulation scenario by generating an event log that can be viewed in the process explorer. Currently I see the simulation running and giving me the required summary. But I want to view the simulated process.

Hi,  I am facing an issue while getting the number of iteration of the activity purchase requisition before the activity purchase order.  if anyone have idea how can we get the activity occurrence so please help! Thanks in advance.

I need to review in detail a ETL process in Celonis. I would like to at least download to my desktop all the scripts. And if possible also to download all the tables definitions (including raw data, temporary, views, and data model) Is that possible? TIA

What changes are required in configuration xml?If we have to start the extractor with login credentials, then how can use the same extractor for another data source?Since TCP/IP ports are different for two data base systems how can we use same extractor to pull data from two different databases?

Multiple DB schemas with identical table names---Hi Team, we have a customer sharing a single DWH with more than one database schema with us. We need to access all of them sooner or later and they contain tables that all share common names. Celonis refuses to load these, even if we rename the target tables to unique names. Is there any other solution than setting up multiple data connections (which will be impossible to handle) or getting a single view in the source data base? Best and thanksJens

Hi, my Average of a PU-Function outputs two different values, when used in a table or a single KPI, when filtered for a dimension. When I use this simple PU function:  AVG(PU_COUNT("_CEL_RADAR_ACTIVITIES_CASES", "_CEL_RADAR_ACTIVITIES"."PROCESS"))  this happens: I have validated, that the output within the KPI is the right one, when filterd by a Dimension (in this case by "Deutschland"). Within the table however, the very same formula leads to wrong results. How can I fix it? What is the reason for it? I am just getting started with PQL. Since I could not find an answer within the forum, I hope you guys can help me. Thx Best, Max  

I have written a python script & it has no error. But still it cannot able to extract tables from Source. The uplink connection is successful. The script is returning data in json fromat. Can anyone please suggest solution?

Dear All, I would like to upload a JSON file in Event Collection which contains key:value pairs that are filled with dates. I have a "CancelDate" key, which sometimes contain null value (Date is not null here in the data if some conditions are met).E.g. [{"CancelDate":null},{"CancelDate":"2020-11-10"}]The datatype is set to DATETIME. After clicking the Finish button, i get the error code: „Processing Errorjava.lang.RuntimeException: java.lang.NullPointerException caused by null” .If i set CancelDate to DATE, i get: Data type conversion error for column "CancelDate", value "2020-11-10". Cause: Can not cast value "2020-11-10" to type DATE in column "CancelDate". I also tried DATETIME, as yyyy-MM-dd format, but the error code is the same. The only way i don't get an error code is if i set the datatype to STRING or if all the json objects keys contain values that are not null. Is there anything i can do so

Basically we would like to be able to track Skill Execution, is there a way to massively extract User Names and Timestamps of the Users running the skills? Thank you in advance! Best Regards,

Hi,can anybody help me understanding how the activity Invoice Due Date Passed is defined?I have a few cases, where this occures more than one time in the process and I wonder how this is possible.image1036535 32.9 KBThank you for your help!Best,Carina

Error in the Default Pipeline Script for assembling & pushing tables to front-end. Has anyone run into an error when running the default pipeline ML script where you get: "Could not execute foreign key join: There are duplicates on both sides of the specified key relationship. Table: Tm_Activities; Key("CaseID")"?  Not sure why this arose out of nowhere.

I was able to find a p2p best practices for SAP in the partner asset library. We are interested in building the activity table for P2P on oracle cloud. I wanted to get a sense of what tables and columns are need for various activities such as Create Req, Modify PO etc along the P2P process. Any help is greatly appreciated.

First, we have created O2C process and added tables that are required for AR process. The extraction part is done, but we have stuck in the data model. The connection between vbap and vbfa may be failing. 

For example: The time between activity A-1 and activity LIKE A. Activity LIKE B can be A-2, A-3, ..., A-n. I always want the activity that is closest to activity A. Between A and B can be other activities. thanks for helping