Data Ingestion & Infrastructure

Is there a possibility of collating data from different data pools so that a dashboard can be built for task mining which will then enable us to see how many users have installed task mining and analyze the captured data which is residing in separate data pools for each teams?

I have two data pools.(A) One data pool extracts P2P data from an SAP system. This connection is shared.(B) The other data pool uses the first data pool as a connection. The tables are synchronized. After extracting the table EINE in A, it is not automatically updated in B (see screenshots).The documentation states that it should be done automatically "If new rows are added to the tables and views of the exported Data Connection, the data will be available automatically in the importing Data Pools" https://docs.celonis.com/en/transfer-data-between-data-pools.htmlIt seems that there is a routine which updates the table in B at a certain moment. But I do not know how to control/trigger this.

Hi,we would like to connect our Jira project to Celonis with API.  we couldn't find a standard connector so we've created a New Extractor with Extractor Builder using REST APIs calls. For autentication we used API token as specified in the documentation. The connetion tests run succesfully but, when we try to Build the response we have this error message:"Cannot get samples from source system: Unable to read the response"  Can anyone help us to solve the problem ? Thanks for you time.Giulia 

I am trying to use uplink connection to create the connection between celonis platform with MSSQL database, but it's failed, can anyone help? thanks a lot!

Hallo together,I like to select a dataset(date) within an App via dropdown. However the dropdown always sorts ascending. Is there any posibility to have earliest days on top?So like:2024-02-272024-02-262024-02-25...2018-01-01 instead of  2018-01-012018-01-02...2024-02-27  

Hello team Is there any way to fetch user login history to data pool?  Thanks In Advance  Regards,Ankit Chatterjee

Filter on the most common variant #3 and #4. Make sure the two variants are superimposed on top of each other. Looking at the Process Start and Process End dotted lines, which of the below statements are accurate? Select TWO options.

answer

We are currently migrating to Celonis EMS, however we are experiencing an issue with the Impala connector. Celonis creates queries such as  Select * from "schema"."table" where Impala interprets " as string delimiter. Other tools that are talking to our Impala database, including Celonis on-premise, do not have this issue. Does anyone know how to configure the Celonis Impala data connection to change this? Many thanks in advance! Joos Buijs - APG

In my project, I'm experiencing an issue with PQL pull-up functions. I am utilizing pull-up functions because Level 2 and Level 3 Columns are generated based on augmented attributes (User Updated in Celonis). If I use those fields directly in the Logics, I get a common table error as we are pulling data from multiple tables.Using PU_FIRST gives me the oldest first record. Using PU_LAST gives me the latest record.I looked over the documentation, but I couldn't find any alternatives.I tried with BIND and DOMAIN Table Functionalities those are also not working. Please let me know if you have any knowledge on the aforementioned question Thanks in Advnace.

Hello! I am trying to apply a filter script on a process explorer component. I do not want to use a selection. filter CALC_CROP(first_OCCURRENCE['Start'] to last_OCCURRENCE['End'], "Activities"."Activity Name") = 1; For some reason it does not apply the filter and crop accordingly. Is there something I am missing? ('Start' and 'End' are placeholders)

Hey everyone!I was trying to do the same as one of Celonis examples, where a drop down button changes the initial dimension column in a OLAP table, at the same time as it changes the table title.Dropdown button selection - Company code -> Title "Purchase Order by Company codeLooking forward to hearing from you.Thank you for your help!Francisco

Hi,I want to show that a data model is successfully refreshed, in studio with the updated refresh date.What is the best possible way to achieve this ?

I want filter first, second and third highest location based on FCR% how can i do that?

Has anyone had experience in integrating Genesysis, telephone contact center software (https://www.genesys.com/)?There is no connector, there is no extractor, and Genesys does not store data in an externally accessible database. Has anyone had any experience? How did you establish the data connection to the source? Thanks

What do you know about the term “Big Data”?

I am trying to create a formula to calculate the total of all invoices for a vendor (but not yet cleared) when an invoice for that vendor is posted. I am using SAP data, and trying to calculate using data from the BSEG table. I am displaying this total in an OLAP table in an analysis. I am passing in the posting date of the current invoice as a parameter ({p1}). The result displayed is the vendor invoice total for all invoices, for all records. PU_SUM("LFA1", "BSEG"."WRBTR", ("BSEG"."BUDAT" <= {p1}) AND ("BSEG"."AUGDT" >= {p1})) The Vendor Master table (LFA1) and the Invoice Line Item table (BSEG) are linked in the data model via MANDT (Client) and LIFNR (Vendor ID). Whatever help you can provide would be greatly appreciated.

Hello, I'm trying to do an analysis where I require the item data from delivery notes ( LIPS table), however for some reason in this specific table I have no information regarding items with delivery type = HOD, NL, and NLCC, only LF and LR appear. I checked all analysis filters and found nothing. LIKP table has HOD, NL, and NLcc information and so do VTTTP and VTTK.Can someone tell me what the issue might be? Thank you

Hi all, I am getting an error when I am extracting data in my training environment. I am attempting to extract a 200mb table from my Azure SQL database.  My data consumption is 1.74gb of 4gb. Data consumption levels had previously been exceeded on the 14/01/2023. I have attempted to upload even smaller tables and the same issue persists.Is there a quick solution to this.

Dear all, just out of curiosity. In the O2C Template data model the tables VBRP and LIPS are joined to the VBFA and then to VBAP. We are doing this in the transformation and join VBRK,LIPS directly to VBAP. image711316 16 KB What are the advantages of including VBFA in the process model? PQL Coding, Performance, Thanks & Br P.S.: Dont consider this question high priority

I'm working with views and I'd like to show a chart only when a runtime varible has specific value. How can I do that?

(Senior) IT Consultant Celonis Projects Inetum. Spain. Location: Spain - RemoteDescription: Process Mining Celonis Consultant.  You will work on various processes such as public administration procedures, banking processes, insurance processes, procurement processes... All certified candidates will be evaluated to fit any of the required positions based on their experience. 

Hi everyone, I am trying to build an OLAP Table where I need to have "Case Key" Column. The problem I have is that I need to highlight just the CASE KEY Values (distinct) for which in column "Parameter" the values are different then Null. Here is the input table: Here is how the Output Table should look like:  Any idea on what should I do to get that OLAP Table? I tried with CASE WHEN + ISNULL Functions but so far without any succes. Thank you in advance for any tips!

Hello,   I want to clear filtered selections on other sheets (Celonis EMS free plan with Process Mining)/the selection only affects a specific sheet. I have not been able to do this, any ideas?   Thank you very much.   Best regards, Pedro.