Data Ingestion & Infrastructure

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. Apply here https://www.linkedin.com/jobs/view/3803667401/   

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.

Hi,  i would like to know how is it posible to uptade a record of my database connected to Celonis by jdbc by an Action Flow. I consider that i will need a Celonis Agent, but i can´t find it. I don´t know if it is only exits for SAP. and then, which is the component i have to use on Action Flow ? Thanks in advance,Sincercely,

Hi everyone, we want to restrict access to users for a dashboard. Therefore we match the user_name() to an uploaded excel.  But since some users should see whole regions and others just single plants we want to adapt the dimension based on the excel input. To make it more understandable: FILTER VBAP.WERKS = (CASE WHEN EXCEL.EMAIL= USER_NAME() THEN EXCEL.WERKS) This is working fine. However making the "VBAP.WERKS-part variable doesn't work yet. (CASE WHEN EXCEL.EMAIL = USER_NAME ( ) AND ISNULL(EXCEL.WERKS) = 0 THEN EXCEL.WERKS' ELSE 'EXCEL.REGION' END) So the idea is that this also leads to: FILTER VBAP.WERKS = EXCEL.WERKS Does anyone have an idea how I have to adapt the part that chooses the dimension? Best regardsAram

To achieve real time data there are two possible ways. 1. Use the replication cockpit with a real-time extractor.2. Use scheduled delta extractions as data jobs. Option 1 obviously will be the recommended one. But what are downsides of option 2?From my understanding the bottleneck of this whole process is loading the data model.If that takes e.g., 10 minutes (which is a rather fast example), scheduled delta extractions, if scheduled more frequent or equal, should achieve the same thing like the replication cockpit.So why would I use a real time extractor instead of that when I can achieve the same result with option 2?

Good morning, I'm working with Celonis EMS Studio (with packages, no with views), and I have two dropdowns like a filter. I would like when select one value of the first one, the another dropdown put only the posibles values to select in this columns (not appear in gray, behaviour similar to 'FILTER FORCED'). For example, I have countries and cities like dropdowns, when select Spain, would like have only the cities of Spain (and not cities of another country in gray like now). Thank you very much. Kind regards.

Hello everyone, I want to calculate the average delivery time and I chose to do this by calculating the throughput time between activity A and activity B in Studio with this formula: AVG (  CALC_THROUGHPUT (    FIRST_OCCURRENCE [ 'A' ]    TO    LAST_OCCURRENCE [ 'B ] ,    REMAP_TIMESTAMPS ( "ACTIVITIES"."EVENTTIME" , DAYS )  )) However, Celonis warns me that >> The aggregation function AVG is applied on a column from table "_ACTIVITIES_CASES" which has a 1:N relationship to the common table "ACTIVITIES". << Could anyone tell me what causes this and how I can make sure that there are not multiple entries sabotaging the average? Thank you very much in advance!

Hello @All i'm trying to export data from an ready/productive Analysis with pycelonis. My Analysis has a table, from which i got the query (compontent.get_query()). With this query i wanted to export the dataframes (data_model.export_data_frame(query)).I'm getting some errors on all variables and saved formulas.e.g: PQLColumn(name='<%=ZZ_ABC1%>', query='<%=ZZ_GHJ2%>'), Is there an option to use variables & saved formulas in pycelonis export? Thanks in advance!  

I want to be able to get the username of someone that executes a skill and update an augmented attribute with the username. In Knowledge Model, I created a KPI with the PQL formula - USER_NAME(). This works fine in the knowledge model and returns the user. However, in action flow when I use Get Rows to get the KPI, it returns Unknown User. Does anyone have an idea why this is the case or perhaps any other idea to achieve what I want?

I'd suspect a lot of activities happens outside of Celonis, initially to 'prepare' the data quality, ensuring its reliability and integrity once in Celonis. I'm sure there's a lot of common challenges when uploading into Celonis, and have experienced some myself.