Skip to main content

Data Ingestion & Infrastructure

Discuss and ask questions about data integration, task mining, admin settings, and PQL extractors to optimize your infrastructure.

  • 755 Topics
  • 2,022 Replies
755 Topics
C
chandrashekhar.burde
posted in Data Ingestion & Infrastructure
Level 1: Newbie (0 - 10 points)

Level 1: Newbie (0 - 10 points)I just join Celonis. Help me to explore Celonis Platform!

3
C
2 months ago
L
lea.filho
asked in Data Ingestion & Infrastructure
In a tranformation data job, I want to add in table A the last date of the table B.

To join these 2 tables I use the fields "MANDT" and "AUFNR".In the table B, there can be several dates for the same order (AUFNR) and in table A I want to have only the most recent date for the order.So I tried the formula LAST(table.date ORDER BY table.date ASC) but it did not work. CREATE VIEW PP_QALS AS (  SELECT DISTINCT    "QALS".*,    LAST("AFRU"."IEDD", ORDER BY "AFRU"."IEDD" ASC) AS AFRU_IEDD,  FROM QALS_U_PP AS QALS  LEFT JOIN "AFRU_U_PP_TEMP" AS AFRU ON 1=1    AND "AFRU"."MANDT" = "QALS"."MANDANT"    AND "AFRU"."AUFNR" = "QALS"."AUFNR"), Do you know how I can add this date field in table A ? @lovise.helln​ (FYI)

1
L
3 months ago
Y
yugandhargoud.ediga
asked in Data Ingestion & Infrastructure
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.

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.

1
mateusz.dudek14
Level 1
3 months ago
A
akshay.salga
posted in Data Ingestion & Infrastructure
I am trying to find a way to modify the following PQL code to change the KPI by the selection of the specific time frame.

I am trying to find a way to modify the following PQL code to change the KPI by the selection of the specific time frame.  KPI("days_considered_for_inv_lt")*MOVING_MAX( PU_SUM(  DOMAIN_TABLE(ROUND_MONTH("o_custom_StockHistoryStorageLocation"."CurrentPeriod")),  FILTER_TO_NULL(COALESCE(   CURRENCY_CONVERT(    "o_custom_StockHistoryStorageLocation"."BaseTotalValuatedStockQuantity"    *     BIND(     "o_custom_MaterialMasterStorage",      PU_LAST("o_celonis_MaterialMasterPlant",     "o_celonis_StockHistory"."UnitPrice"))    ,FROM(     BIND(      "o_custom_MaterialMasterStorage",       PU_LAST("o_celonis_MaterialMasterPlant",      "o_celonis_StockHistory"."BaseCurrency")))    -- ,FROM("o_celonis_MaterialMasterPlant"."BaseCurrency")    ,TO('EUR')    ,PU_MAX(CONSTANT(), "o_celonis_StockHistory"."CurrentPeriod")    ,&

1
mateusz.dudek14
Level 1
3 months ago
S
sivasakthi.dhand
posted in Data Ingestion & Infrastructure
Hi, Can anyone help me to calculate time difference between LAST TWO activities in the process where last two activities are not fixed ones.

Hi, Can anyone help me to calculate time difference between LAST TWO activities in the process where last two activities are not fixed ones. Thanks in advance!

4
S
3 months ago
C
carlos.antero.simón
asked in Data Ingestion & Infrastructure
Date, datetime and Polars dataframe

Hello good, When I work with a Pandas dataframe with the intention of transforming it to parquet to load it into Celonis, it is necessary to use "use_deprecated_int96_timestamps = True". Otherwise in Celonis the dates are recognized as integer type. However, what alternative is there when we work with Polars instead of Pandas to avoid this problem? Thank you so much

0
C
3 months ago
L
lucas.van.d12
asked in Data Ingestion & Infrastructure
How to capture the last activity of a case when using SOURCE() operator

Hi, I'm working on a case where we're analyzing activity time by users, by leveraging source - target. Looking at the simplified example below, I want to show that John has been working for 1 hr while Paul worked for 4.5 hrs. This works fine, however I'd also like to show the number of activities they have performed in the same table. As John only has one SOURCE activity (Activity 1, as Activity 2 is the last activity of the case and is therefore not connected to a TARGET activity), it appears if he only performed 1 task while Paul performed 2.The intended output is as shown below, with SOURCE(Name) as dimensionIs it possible to adjust the SOURCE config to include Activity 4 in Johns activity count? Or is there any other approach to get this done? Note that the actual throughput time calculation is rather complex (taking various attributes like user activity type into account), so SOURCE/TARGET seems to be the only way to calculate the right duration. Thanks in advance!

3
A
3 months ago
V
vicente.cox
asked in Data Ingestion & Infrastructure
How to connect to a SOAP web service?

Since Custom Extractors are implemented por REST APIs only, what is the best strategy to consume a SOAP web service? I successfully consumed it via a Python request, using an XML body. Is Celoxtractor the only way to upload the data, or is there a more straightforward way to connect to a SOAP WS? Thanks

0
V
3 months ago
U
ugurcan.aydem16
asked in Data Ingestion & Infrastructure
How to use DateTime_constant (TODAY, MINUTE_NOW, etc.) in the CALC_THROUGHPUT time function?

Hi all, I'm trying to calculate throughput time between and "activity" and "today" timestamps by excluding Sunday. First, I tried it with using DATEDIFF function like that: DATEDIFF (HH, PU_LAST ("cases", "activities"."event_time" ), MINUTE_NOW()) But in this version, I cannot exclude Sunday as you can see.   Once I tried to do it with CALC_THROUGHPUT function as below: CALC_THROUGHPUT ( FIRST_OCCURRENCE [ 'Order placed' ] TO CASE_END , REMAP_TIMESTAMPS ( "activities"."event_time" , HOURS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY ) ) ) Now, I can only calculate the time until last event timestamps, not until now since I cannot use any DateTime_constant (TODAY, MINUTE_NOW, etc.) in this formula . Do you have any suggestions/solutions for such cases? Many thanks in advance for the answers :)

1
P
4 months ago
S
sravan.kumar13
asked in Data Ingestion & Infrastructure
Access the Order Management demo to answer this question. 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 bel

   

0
S
4 months ago
D
dudekula.shafi
asked in Data Ingestion & Infrastructure
Your business user needs to investigate how the cases are flowing into undesired activities, in other words, see the predecessor activities. Which of these options would you choose to meet their needs?

Your business user needs to investigate how the cases are flowing into undesired activities, in other words, see the predecessor activities. Which of these options would you choose to meet their needs?

0
D
4 months ago
martin.memel
Level 1
martin.memelLevel 1
posted in Data Ingestion & Infrastructure
Task mining data configuration failures

Task mining data configuration failures I've recently started learning on the Celonis Academy courses and I'm stuck on the Task Mining sandbox.There is an error in the data configuration, it keeps failing:Uploading paquets from my machine seems to go fine:Yet it is impossible to analyse the recorded and uploaded task mining data, I'm guessing because the data configuration failed?It has been over two hours since my test tasks were recorded and uploaded. Does anyone know what is failing here and how to fix this?

2
L
4 months ago
hamood.farid11
Level 1
hamood.farid11Level 1
asked in Data Ingestion & Infrastructure
How to handle ORA-01795: maximum number of expressions in a list is 1000 issue?

 I have a table that I am doing an extract of last 1 year. Once the extract is complete, there is 1 column in it (let's say invoice number) that had some activity occurred for it few years back. I am trying to do a second extract of the same table where no date constraint is in effect but using invoice number column values in "Additional Filter" condition.Steps Performed:Extract table data for last 1 year.Create a dummy table to save invoice number column values in it.Create a list parameter to save all those invoice number values in it.Try a second extract of same table without "Enable creation date filter" condition.Use the parameter value in Additional Filter condition (Invoice IN <%=hist_param%>. I am getting an error in the second extract "ORA-01795: maximum number of expressions in a list is 1000".Its an on-prem extractor in use. Any help would be appreciated.

0
hamood.farid11
Level 1
4 months ago
S
sreenidhi.kalya
asked in Data Ingestion & Infrastructure
Hello, how to set up the connection to sharepoint through action flow? While registering the application what should be the redirect uri? The one which is mentioned in the celonis help documentation is not working.

Hello, how to set up the connection to sharepoint through action flow? While registering the application what should be the redirect uri? The one which is mentioned in the celonis help documentation is not working.

0
S
4 months ago
lovise.helln
Level 1
lovise.hellnLevel 1
asked in Data Ingestion & Infrastructure
Trying to create a status for each case based on a NULL field from the activity table

Hi all One of my use case is to monitor a number of fields being left empty at the sales order creation. In order to keep track of these issues and make sure the root cause are being resolved permanently, I want to create a "status" for each item (in the example below, we are monitoring the Plant field). Status:NOK = plant field is missingOK (fixed) = plant field was changed from NULL to any valueOK = all the other cases it is the second option 'OK (fixed)' that is causing me some headaches and I would appreciate your help. I tried several options but for now, none of them are working.  Option 1:CASEWHEN "VBAP"."WERKS" IS NULL THEN 'NOK' WHEN ("_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Change Plant')AND "_CEL_O2C_ACTIVITIES"."CHANGED_FROM" IS NULL) THEN 'OK (fixed)'ELSE 'OK' END the result of this option gives me a table that will display 2 rows for one item, one with the 'st

2
lovise.helln
Level 1
4 months ago
li.yan
Level 1
li.yanLevel 1
asked in Data Ingestion & Infrastructure
Does Celonis EMS has the function to consoliate several applications, with differnt data model, into 1 cockpit view? And also use common feild, such as "Material number", for all those application to dynamicly filter those app in that 1 view?

Does Celonis EMS has the function to consoliate several applications, with differnt data model, into 1 cockpit view? And also use common feild, such as "Material number", for all those application to dynamicly filter those app in that 1 view?

3
santosh.korad
Level 1
5 months ago
hamood.farid11
Level 1
hamood.farid11Level 1
asked in Data Ingestion & Infrastructure
How to use SQL in additional filter to update a date time column?

I have a table were I only want to extract last 20 days of data based on "Update" datetime column. As the parameter option has a fixed start time (default value), I am looking for an option to add a SQL in Filter Statement where it substract 20 days from current date. This is giving error "Error parsing filter:"SQL used in Filter Statement: ColumnName >= TIMESTAMPADD ('day', -20, CURRENT_TIMESTAMP AT TIME ZONE 'US/Eastern')As this is Full load extraction, I am not using "Enable Change Date Filter". I also tried the option of creating parameters and changing value in transformation but that too didn't work.Any help would be appreciated.

2
hamood.farid11
Level 1
5 months ago
B
bennita.dutoi12
asked in Data Ingestion & Infrastructure
How do I calculate throughput time from start to end for cases that did not meet a certain criteria. e.g I want to calculation the throughput time for cases that has a STP Fail = 'Yes"

How do I calculate throughput time from start to end for cases that did not meet a certain criteria. e.g I want to calculation the throughput time for cases that has a STP Fail = 'Yes"

3
S
5 months ago
P
pablo.messa11
asked in Data Ingestion & Infrastructure
OpenAI - PQL GPT

Dear Community, I hope this message finds you all in good spirits. I'm reaching out to gather insights on OpenAI's "PQL Expert", a feature available through the PRO license. Has anyone here had the opportunity to engage with this tool? I'm interested in understanding its capabilities and whether it offers significant advantages. Any shared experiences or evaluations would be highly valuable.Furthermore, I'm looking to connect with or learn about Jesse Ma. Does anyone have information regarding Jesse's affiliations, specifically if they are connected to a certain organization or perhaps directly involved with OpenAI's initiatives?Your feedback and any personal anecdotes regarding the "PQL Expert" or interactions with Jesse Ma would be greatly appreciated. Thank you for contributing to our collective knowledge and helping to foster an informed community.  Warm regards, Pablo

2
Sverre Klein
Level 1
5 months ago
R
ramanathan.iyer
posted in Data Ingestion & Infrastructure
Has anyone tried replacing the On Premise Extractor to Celonis On Premise Client .

Has anyone tried replacing the On Premise Extractor to Celonis On Premise Client .have quite few questions

6
R
5 months ago
R
raman.silot14
asked in Data Ingestion & Infrastructure
Dynamic Color Mapping

Was just curious that can we dynamically mention threshold value in color mapping? instead of mentioning static number. Just like in this image

4
L
5 months ago
E
el.mostafa.janah
posted in Data Ingestion & Infrastructure
Dear Community,

Dear Community,  does anyone have any idea on how to create a chart in a view with running sum logic, that means for: January 24: i would like to display the sum of purchase order value of the last 12 months from Jan 23 till end December 23 February 24: the sum of purchase order value (for example) from February 23 till end january 24 March 24: the sum of purchase order value ((for example) from March 23 till end February 24 and so on for the coming months. I can imagine that i have to build the logic in the KPI itself. Furthermore, i would like also to create a chart in a view with YTD Logic: January 24: Data, like purchase order value, just from January 24February 24: Sum of purchase order value of January & February 24March 24: Sum of purchase order value of January & February & March 24...... Thank you so much!

2
E
5 months ago
D
divya.tiyya
asked in Data Ingestion & Infrastructure
Access the Order Management demo to answer this question.What are the top three late delivery root causes by case occurrence for customer Wallenquist Organization 11746?

Access the Order Management demo to answer this question. What are the top three late delivery root causes by case occurrence for customer Wallenquist Organization 11746?

1
P
6 months ago
M
Level 1
matt.slocu12Level 1
asked in Data Ingestion & Infrastructure
Share Data pools with other companies

I have a customer who also uses celonis. We would like to push them tables from our instance into theirs. Of course we could also make the raw tables available and they could extract them directly. But was assuming there was also a capability to share a data pool externally from my instance. Is that a possibility? I could not find any documentation on this...

2
janpeter.van.d
Level 1
6 months ago
manuel.wetze
Level 1
manuel.wetzeLevel 1
asked in Data Ingestion & Infrastructure
NULL handling in Average formula:Hi all I want to create a (weighted) average of 3 already predefined KPIs which create a single number (percentage value).Now I want to create a weighted average of those three which is handling NULL values.

Example: KPI_A: 0% (weight 1)KPI_B: 90% (weight 2)KPI_C: NULL (weight 1)-> Expected outcome: 60% (2*0,9+1*0)/3 KPI_A: 0% (weight 1)KPI_B: 90% (weight 2)KPI_C: 0%(weight 1)-> Expected outcome: 45% However all I came up with is:((KPI_A*1)+(KP_B*2)+(KPI_C*1))/4 which is resulting in NULL if any of the KPIs is NULL. I could sove is using extensive nested CASE WHENs catching every possible combination but that seems quite cumbersome and hard to read/maintain. Does anyone have a better appraoch or PQL function I am missing? 

6
R
6 months ago

Badge winners

  • Certified to Build Analyses
    ben.lakho11has earned the badge Certified to Build Analyses
  • Certified to Get Data Into Celonis
    ben.lakho11has earned the badge Certified to Get Data Into Celonis
  • Certified to Build Action Flows
    ben.lakho11has earned the badge Certified to Build Action Flows
  • Certified to Build Views
    ben.lakho11has earned the badge Certified to Build Views
  • Certified to Write PQL Queries
    ben.lakho11has earned the badge Certified to Write PQL Queries
Show all badges
Terms & ConditionsCookie settings