Data Ingestion & Infrastructure

I know you can set filters in the graph, but these seem to be for the whole graph. I would like only one line to have this filter (So I can compare different days/ groups with the average values). Is this a possible feature in Celonis?

Hey Peers,  I´m trying to connect the right PO to the corresponding SO in the IM Datamodel. I tried to BIND the EKKN to the EKPO, since there is an 1:N relationship, I get following error  My current statement is  PU_LAST ( "MARC",   CASE    WHEN      BIND ("EKPO", "EKKN"."VBELN") = "VBAP"."VBELN"      AND       BIND ("EKPO", "EKKN"."VBELP") = "VBAP"."POSNR"          THEN      "EKPO"."EBELN"  END) Can somebody correct the syntax or push me to the solution?  Thank you :)

Hi all, I am looking to remove some old data tables from our data pool and clean up the data pool. What is the best way to achieve this? When I run a script to drop the tables, I am unable to execute it and receive the following error"Cannot drop Table AFKO because other objects depend on it" I have removed it from the data model and performed a full reload on the data model. Thanks,Michael

Hi, I have a SF connection set up to extract data (non-realtime). What type of Salesforce API does Celonis use for data extraction - Bulk / SOAP / REST ? Thanks,Bhasker

I delay the data that i set in my transformaitión datables with replication dependencies., but i need as realitme data as posible, and five minutes on delay in same tablas generate me incorrects action on Action Flow.

Is there an option available to Pseudonymize the columns of the data uploaded using File Extractor?

Hi, all.Hi, I'm starting a PoV with a customer that uses Salesforce. We don't want to involve IT yet so we would need a way to extract the log data in a csv file.Could you please help us? Thanks!Luis #salesforce #logfile

Hello, I would like to know if there is any way in which when adding data to my excel sheet, the information is also updated within my visualizations in celonis.

Hello, I would like to know if there is any way in which when adding data to my excel sheet, the information is also updated within my visualizations in celonis.

Hello All, I have a scenario where i need to calculate the time between one activity and the Previous activity. I have an activity Maintenance Rejected and it can happen once, twice or more than that for a case. Irrespective of the number of occurrences. I should always calculate the time difference between the Maintenance rejected activity and the previous activity. We have only option to take first occurence or last occurence.Is there a possible way to achieve this. Request you to kindly share your expert opinion on this.   Thanks ,Saravanan.G   

Hi Team,  I have a project on which we are supposed to connect Celonis with JIRA.  In help document https://docs.celonis.com/en/jira-connection.html it says we should use "Enter the name of the new Jira Data Connection." but we do not have such connector (see screenshot).  Is there any connector which could be used for JIRA connection? Thanks,Satoshi

Hello everyone,currently I am trying to calculate the KPI for the number that an activity is occuring overall.I tried this formula:COUNT(CASE WHEN Activity_Table.Activity_Column = Selected_Activity THEN 1 ELSE 0 END)Obviously it did not work. It gives me the result of all my activities/rows from the whole table.I actually do not get why it does not work.I am very grateful for helpKind regardsMatthias

Hy,I am trying to get some hands on over Replication Cockpit, but I am not able to see my already implemented data connection here. After doing some research, I found out that trigger and change logs are required to be created in source system. So, can anyone please tell me how is that possible ?

Hi, we need to capture the url of internal sites without the querystring as it could expose PII. Has anyone been able to do this with jquery in the web page data extractions? I have tried the following and confirmed that the console on the browser developer tools shows what is expected but the data is not captured by the Task Mining tool. The result captured is: [  {    "key": "url-hostname",    "data": []  },  {    "key": "url-pathname",    "data": []  },  {    "key": "url-location",    "data": []  },  {    "key": "url-document",    "data": []  }] Thanks 

Hi I have the following problem when I try to load a data model, "The Data Model Load experienced an issue exporting from the Pool Provider", I tried to look in Celonis Academy and Help Resources, but I wasn't able to find anything regarding this issue. Pls, does anyone know how to solve this problem?

getting this while data connection with on-prem mysql, how to fix it?

Hello everyone, I would like to build a data model based on case and activity tables built by me. However, the data model load is unsuccessful and the following error message appears: The export failed: Table contains more rows than the allowed maximum per table of 10000000 Please reduce the number of rows.  Both case and activity tables could be successfully modified in a data job, no matter how big both tables are. Also, I am working with unlimited APC consumption. I assume that this error is caused by the activity table - if I load table with less than 10mln rows, data model load is successful. However, I need to analysis bigger data that will produce more than 10mln activities.  Does anyone know what may cause this error and how to solve it?  Thank you in advance!

App: Procurement Starter KitConnector: Purchase-to-Pay, Real Time Connector for SAP ECCData Job: SAP P2P - ABAP one time extractionWhat I am trying to achieve: To use the 'Procurement Starter Kit" App with "Purchase-to-Pay" connector Data extraction:1. Data was extracted from ERP with the Celonis' ABAP report using the 'SAP ABAP generator'2. Data was uploaded in Celonis via 'SAP ABAP Uploader': Data ->File Upload ABAP Uploader Generator ->Upload ABAP Report Output3. Data model is run. Data ->Data Job -> SAP P2P - ABAP one time extraction ->Execute Data Job When/where the error is shown:Data -> Process Data Models -> Data LoadsError message is: "Data model load failed during table export: Error validating the Data Model: The following tables are missing in the Data Pool: P2P_MSEG, P2P_BKPF, P2P_QAVE, P2P_CONTRACT_INFO, _CEL_P2P_ACTIVITIES, P2P_MARA, P2P_LFA1, P2P_CONTRACT_RECOMMENDATION, P2P_MARC, P2P_EKKO, P2P_EBAN, P2P_B

Hello Peers, do you know if there is a way or workaround to enforce an update of the upper threshold in a Single-KPI component when a filter is applied on the dashboard. Currently, the upper threshold if calculated on all data once but it does not react on a filtering. w/o filtering:w/ filtering:Hope, you guys have an idea on that matter ;-) Cheers,Mark

"The table [insert table name] has more than 30000000 rows and it is therefore not recommend to be used with the augmentation feature." I see this warning message for a number of our tables, but that is expected. There is a substantial amount of data in these tables. Is there a way to either deactivate this message or remove it entirely? It seems unnecessary in the event a table is naturally designed to be that large, like CDPOS/CDHDR or even VBAK.

Hi process miners,  I'm doing some pitchdeck/marketing work and I'm wondering how many prebuilt connectors Celonis has. Based on this page, there is 20 https://docs.celonis.com/en/data-connections.html, but UiPath process mining has over 50. I can't imagine UiPath has more than Celonis,. Does anyone have a total number of prebuilt connectors?

Hi,​ I would highly appreciate your help as building given KPIs is business critical for our customer. Many thanks in advance,Michał  The issue is as follows: Client required a KPIs of total time of approvals and number of invoices going through approval within wider AP process. There may be different variants. Case 1 - The CT is simply time between A1 and A8, timestamp of activity A3 (in between) does not affect the calculationA1/ Invoice submitted for Approval A3/ Change PriceA8/ Invoice Approved  Case 2 – in that case, the calculation should start with A1 and stop once invoice rejected (activity A2) and then restored from next submission (activity A5) until approved (activity A8). Time between A2 and A5 should not be included/ any activities in between should not be taken into account. So the CT here is A1 to A2 plus A5 to A8. A1/ Invoice submitted for Approval A2/ Invoice RejectedA3/ Change PriceA5/ Invoice submitted for Approval A8/ Invoice Approved   Case 3 – in that case, the c

Are these 2 Time Filters equivalent or should the Time Filter be preferred over the Filter Statement? If so why?

Is there a standard technical specification document format available with Celonis for Extraction and Analyses technical documentation?

What is the go-live date for the new file uploader in EMS? It was supposed to be 16th Sep, but still dont see it in EMS.