Data Ingestion & Infrastructure

Hi @janpeter.van.d​ / @Celopeers .​  I'm trying to compare two dates from different columns in order to find out about a delay.  For this I need to (1) compare the highlighted dates in the red box (2) if the ETA is earlier than the Timestamp of the Activity "Ready for Pickup" I need to mark it with the value "1" in the respective column and line (as highlighted) [Note that the columns "ETA" and "Delay" are two manually created attributes within Celonis and were not part of the extracted data.] I guess I need to use a PU function here, but as I'm not very familiar with it I'd very much appreciate any help.  Thanks in advance anf brgds, Finn

I read the following message before: 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 WHENCALC_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 ne

 After creating an Attribute, to have a specific column in my table in celonis, I cant access this column in the KPIs.How can I access this new column when working with KPIs? Thanks in advance!

UNABLE TO UPLOAD FILE ON EMS !!!I have a csv file that is correctly uploaded on a trainning team but is being uploaded on my EMS CUSTOMER. Is Trainning better than EMS?

How to find the Cluster Details in the Training environment? Please Help!

Hi, I am trying to create a new connection to the on-prem MS SQL Server Database on my personal system for training purposes with database type as Microsoft SQL Server(native) but getting an errorTelnet connection to the host MSSQLSERVER2019: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.Please see the screenshot below.Port Number: 1433 Please help to resolve the issue. 

We are trying to do a user analysis to understand the usage of Celonis applications and were able to process the audit logs. Is there a way to understand how many Users were created along with user groups and Date of creation of User id etc. Swathi

Hello everyone,here is my case: I am using SAP table CRMD_ORDERADM_H as case table. I am using PU_SUM to have an OLAP table column with the sum of CRMD_ORDERADM_I.NET_VALUE grouped by CRMD_ORDERADM_I.HEADER (case id). I am using a dropdown to filter for CRMD_ORDERADM_I.ORDERED_PROD. It works in so far that the table only shows cases, where at least one item has the selected PROD, but the sum stays the same.I would like the filter to be applied to the sum.In case you are not familiar with SAP tables - I added a mock up of what I am trying to do.Have you got any ideas how I could accomplish that?Thanks in advance!

Dear Celopeers, May I ask you to dispell a potential misunderstanding on my part regarding the Calc_throughput function. I have three consecutive activities : A, B and C I would expect that: CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO LAST_OCCURRENCE['B']) + CALC_THROUGHPUT(FIRST_OCCURRENCE['B'] TO LAST_OCCURRENCE['C']) = CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO LAST_OCCURRENCE['C'])   Unfortunately, this is not what I'm observing at the moment when doing this on aggregates (say... all Purchase orders processed in the last 6 months). Calc_throughput A->C reports a much shorter throughput time than i would expect from the above calculation. What could be the reason for this?  Best Regards,

Hi AllAm very new to celonis data connection and events including PQLI have a data set for Requisition PR (EBAN), Procurement PO (EKKO and EKPO)I also have the finance data invoices BSEG.BSCHL = 31Is there a column or a query l can use to directly link the invoices (BSEG) to POs(EKPO) without the table EKBEEventually, l have to compare PR, PO and Invoice value?Thanks

Hi,Imagine a table of sales data with each row containing the sales date and the amount sold. My goal is to calculate the standard deviation of monthly sales (and use this value in other formulas). Getting the monthly sales is easy:DIM: ROUND_MONTH(SALES.DATE), KPI: SUM(SALES.AMOUNT) In order to STDEV over those monthly values, I thought about doing the monthly sum within a PU function like so: PU_SUM(DOMAIN_TABLE(ROUND_MONTH(SALES.DATE)), SALES.AMOUNT)) In my understanding of PU functions, I would've thought that this results in the same values as DIM: ROUND_MONTH(SALES.DATE), KPI: SUM(SALES.AMOUNT).  But it does not, the values are roughly 10 times as high, each "month" is higher than the sum of all amounts together.  In the end I want to be able to use a formula to get the STDEV and use this to calculate other KPIs Thanks in advance

I have some KPIs that are calculated based on the unfiltered population and some that are filtered by selections, but now I want the population to be flexible and since I have multiple filters that are applicable I need those KPIs to be flexible too. It does not work if I set the variables to not static because then some KPIs are calculated incorrectly with the sheet filters and selections even if i calculate them with the GLOBAL function. You can think of it as two populations. The first population is the basis for the main KPIs which is filtered by more generic filters but not with selections. The second population is the filtered first population which is the basis for more KPIs and visuals which can then be selected.  If anyone could think of a better way to do this I am all ears too because if I can assign multiple values to a static variable then I will have to implemented x Case When statements to check for which filters are active.

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 minut

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 th

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

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.