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.

  • 806 Topics
  • 2,121 Replies
806 Topics
A
Level 3
antoine.leducLevel 3
asked in Data Ingestion & Infrastructure
Remove hours from a timestamp (SQL)

Hello guys,I have this column MAX(TO_TIMESTAMP(LPAD("gb"."demat_entry_date", 19, '0'),'DD.MM.YYYY HH:MI:SS')) AS "date reception" and i want to reduce the date by 2 hours. Exemple : From 2022-10-22 11:51:28 to 2022-10-22 09:51:28 I have tried a lot of formulas without success...

30
A
Level 3
D
Level 1
divya.sridhLevel 1
asked in Data Ingestion & Infrastructure
I am getting file validation error while trying to upload XLS file. What is the issue and how to resolve it?

I am trying to upload XLS file (just in KBs) . I get the following error. Could you please help?File validation failed. The following error occurred during upload: A part with the name '/docProps/core.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12]

110
R
Celonaut
S
Level 2
sören.krupkLevel 2
asked in Data Ingestion & Infrastructure
How to count loops / match process of similar but not the same activities?

Hi, i'd like to count how often cases circle in "waiting" activities. Specificly: How often do cases go from a node like %WAITING% directly to a node like %WAITING% - excluding the source node as target node. Problem: My solution SUM(MATCH_PROCESS(...)) doesn't count multiple waiting loops occurring within the same process but only processes with a waiting loop.Problem: I have no idea how to exclude the source node from the target nodes as both work with the same wildcard. I'm curious for any suggestions for a solution :)

80
K
Level 3
.
Level 5
.146001072Level 5
asked in Data Ingestion & Infrastructure
Best Practise for Task Mining

Dear Task mining experts, what are the best practices for Task Mining projects. Like do's and don't, how to start, how long to run data capturing, ......? ThanksBRTimo Peters

10
C
Level 2
L
Level 1
linda.rossLevel 1
asked in Data Ingestion & Infrastructure
My SAP team added new fields to a table that I extract for process mining. My delta loads have been failing. Do I need to initiate a full drop and reload? Will that then pick up these new fields or is there something else that I need to do?

My SAP team added new fields to a table that I extract for process mining. My delta loads have been failing. Do I need to initiate a full drop and reload? Will that then pick up these new fields or is there something else that I need to do?

30
dennis.pflug
Level 6
vamshi.vigne
Level 3
vamshi.vigneLevel 3
asked in Data Ingestion & Infrastructure
Generating a random number series table

We are trying to generate a table which contains n rows starting from 1 to n where n is dynamic.  we tried the below code, but it creates only 9 rows from 1 to 9. //code insert into supplierNumbers (num)WITH RECURSIVE NumberSeries AS (  SELECT 1 AS value  UNION ALL  SELECT value + 1  FROM NumberSeries  WHERE value < 20 )SELECT value FROM NumberSeries; // is there any way to overcome this?

90
G
Level 3
A
Level 2
anurag.singh23Level 2
asked in Data Ingestion & Infrastructure
I have fully loaded data model in data integration but i do not see and rows when i use the Data model in Studio?

I have created a new space in studio to analyse master data changes in SAP, The data integration part is successful and the data model along with activity and case table also seems to load successfully. But when i use the same data model in studio, it shows that the tables have no rows.  Can anyone please help me. I have been trying to solve this since last week and still cannot figure out. :( What am i missing?  

30
A
Level 2
A
Level 2
anurag.singh23Level 2
posted in Data Ingestion & Infrastructure
I have created a new space in studio to analyse master data changes in SAP, The data integration part is successful and the data model along with activity and case table also seems to load successfully.

I have created a new space in studio to analyse master data changes in SAP, The data integration part is successful and the data model along with activity and case table also seems to load successfully.  But when i use the same data model in studio, it shows that the tables have no rows.  Can anyone please help me. I have been trying to solve this since last week and still cannot figure out. :( What am i missing?

22
A
Level 2
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
What does "{t 946771200000 } " refer to? What is returned as O/P for the above part in the PQL statement -CASE WHEN "Table1"."Column1" IN ( {t 946771200000 } , {t 1009756800000 } , {t 1245145600000 } ) THEN "Table1"."Column1" ELSE null END

It is mentioned in the scenraio 5 of 'IN' Predicate function documentation page - IN (celonis.com)  Thanks in Advance!

70
abhishek.chatu14
Level 7
R
Level 1
raúl.ramírLevel 1
asked in Data Ingestion & Infrastructure
Task Mining trying to see my screenshots in Studio View

Hi, I'm having issues with displaying the screenshots in the Task Mining Screenshot Viewer component in Studio Views.  The error is the following: 

30
H
Level 1
R
Level 1
raul.salom11Level 1
posted in Data Ingestion & Infrastructure
Hello, can you help me with this? I want to see my screenshots in a View Sheet.

Hello, can you help me with this? I want to see my screenshots in a View Sheet.

01
R
Level 1
vamshi.vigne
Level 3
vamshi.vigneLevel 3
asked in Data Ingestion & Infrastructure
How to declare a variable in the data jobs?

I am trying to create a variable and set a dynamic value to it using the below syntax. DECLARE @my_variable INT. But it shows syntax error near "@". I tried checking the syntax in the Vertica SQL and i could not find a difference. It would be helpful if someone would help on this or can share your prior experience on the same.

90
abhishek.chatu14
Level 7
A
Level 1
amit.arvin12Level 1
posted in Data Ingestion & Infrastructure
Dear All,

Dear All,Hope all is well. I would like to compare two event logs (one is Actual and Another Planned) for same activity.lets sayID; Activity; Planned Date111, "Activity1"; "15/10/2022"111, "Activity2; 17/10/2022" ID; Activity; Actual Date111, "Activity1"; "16/10/2022"111, "Activity2; 20/10/2022" Objective: I would like to know which activities are impacting my overall performance. Thanks.  

01
tsholo.lesof
Level 2
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
What does the Indirect 1:N relationship mean ?How can we analyze the Indirect relationship between tables ?

Do we refer to the end to end relationship between the Table B (1) and Table A2 (Case Table - N), by ignoring the intermediate tables (Table A)?

50
A
Level 3
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
How to convert seconds to the date format (DD-MM-YYYY)?Also what could be the reason for having the same 'PU_median time' value for all the cases in the data set?

Hallo Team, I have been using the P2P dataset provided by the academy.  Had used the following statement to calculate the PU_median according to each case - PU_Median("LFA1", "_CEL_P2P_ACTIVITIES_EN"."EVENTTIME").  I have diffculties understanding the outcome (in pic attached) - Why do I get the PU_Median time calculated in seconds format?How can I convert the O/P format in seconds to DD-MM-YYYY ? - Had tried using {t } function, but it was an failureEven though there are different time stamps for each case wrt to activity - why do I get the same median time (1245079800000) for all the cases?  Can any I detail it . Thanks in advance.

80
A
Level 3
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
Can you please guide me - what is the next step we need to proceed when get the error message 'No Common Table', along with the 'Path defined in the error message?

Over the Join Functionality documentation page (Join functionality (celonis.com)), when we get an 'No Common Table' error message - a detailed explanation along with the join path is explained. As I am new to the Celonis world, I wonder how to use the mentioned path to achieve the corresponding result.  Thanks in advance.

450
A
Level 3
A
Level 3
alejandro.bayonLevel 3
asked in Data Ingestion & Infrastructure
How can I use a KPI that is defined in the knowledge model in an action flow Query Data module?

Hello, I open this question that was already asked by another user 5 months ago and not answered from Celonis. Moreover, I'm not allowed to comment or ask for update on that post if the post is older than 30 days. I would like to query data in an Action Flow from the Knowledge Model and not from the Data Model. Currently I have an Action Flow connected to a Data Model and I have modules like Tools (set multiple variables) replicating the same KPIs I have in the Knowledge Model. If I need to update a KPI in the Knowledge Model I have to remember to update it as well in the action flow, this causes high maintenance and possibility of error. This feature is critical since one of the main goals of using Studio is the centralization of KPI definitions into a single source of truth, the knowledge model. If you have any update on this topic I'd appreciate if you can share it with the community. Thanks. BRAlejandro 

230
janpeter.van.d
Level 8
.
Level 4
.146192833Level 4
asked in Data Ingestion & Infrastructure
Network diagram for user approvals

Dear Experts , I have P2P activity logs and i have users column along with it infront of activity who executed it. Is it possible to create a network diagram using network explorer with each node being users along with value of transactions they are executing ? Can you advise ?

20
R
Celonaut
K
Level 2
kihyun.kim12Level 2
asked in Data Ingestion & Infrastructure
Is there a way to define dimension to only include activities that occurred before/upto specific activities?

I want to define the dimension so it includes activities in 2 conditions, that only has occurred before specific activities (ideally defined by LIKE "string%") OR upto specific activites. However, what I found so far for cropping methods (e.g. crop to null) requires specific name of the activity and doesn't allow LIKE predicate. Is there a way to crop activities to anything before specific condition / first_occ of specific condtion?

00
K
Level 2
A
Level 1
armz.agbuy12Level 1
asked in Data Ingestion & Infrastructure
need to compare each of the the Part Name under Ticket.Id 123456 if any of them are the same in Ticket.Id 345691

need to compare each of the the Part Name under Ticket.Id 123456 if any of them are the same in Ticket.Id 345691 and in the Ticket table (in the same row as the Ticket.Id) the list of Part names also found in the succeeding Ticket.Id Ticket TableTicket.Id Event time123456 8-Jul345691 9-Jul Parts tableTicket.Id Part Name123456 PartName1123456 PartName2123456 PartName3345691 PartName1345691 PartName3

00
A
Level 1
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
Can anyone - please explain the UNIQUE_ID functioning wrt to the below scenario 2 over the documentation page - https://docs.celonis.com/en/unique_id

For me, the output is not clear -   Given 'A' has 4 unique combinations (Munich - DE, NH, UK, TN) - as expectedGiven that 'B' has 0 unique combinations. As per my understanding, the O/P I expect is 3 (Berlin - DE, UK, TN)Given that 'C' has 1 unique combination (Berlin- NH) - as expectedGiven that 'D' has 0 unique combinations - as expected (all the unique combinations wrt Berlin - DE, NH, UK, TN are covered in the B and C Cases).Given that 'E' has 3 unique combinations (Bristol - DE, NH, UK) - as expectedGiven that 'F' has 2 unique combinations. As per my understanding, the O/P I expect is 1 (Bristol - TN) - as the combinations (Bristol - DE, NH, UK) are covered in the case of 'E' above.  Can you please correct me if my understanding of the concept is wrong? Also please provide your inputs. 

10
A
Level 3
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
What does "{d '1970-01-02' } " refer to? What is returned as O/P in the PQL statement - REMAP_TIMESTAMPS ( {d '1970-01-02' } , DAYS ) ?

REMAP_TIMESTAMPS (celonis.com)

50
A
Level 3
G
Level 3
gerald.dunnLevel 3
asked in Data Ingestion & Infrastructure
Simultaneous timestamps treated as sequential, not parallel?

How would I expect this data to be visualised. Would it be as four parallel tasks or in sequence in record order. Does process mining support a parallel split?Case,Task,Time1,x,01/01/2023 00:00:001,y,01/01/2023 00:00:001,z,01/01/2023 00:00:001,a,01/01/2023 00:00:00

00
S
Level 4
jonas.schei12
Level 3
jonas.schei12Level 3
asked in Data Ingestion & Infrastructure
Abbreviated Number with same number of decimals?

Dear all,I would like to have the same number of decimals for different abbreviated key figures.With ".3s" I can only define the total number of digits, but I would like to define the number of decimal places for an abbreviated number.With ".3s" -> 8.07k .... 17.0k but I want: 8.07k ... 17.01k  Thanks in advance! Best,Jonas

70
S
Level 4
R
Level 2
raisa.ukuLevel 2
posted in Data Ingestion & Infrastructure
Variant and Process Explorer not filtered when using CALC_CROP in load script

Variant and Process Explorer not filtered when using CALC_CROP in load script  How to ensure that Variant and Process Explorer are filtered when using CALC_CROP or CALC_CROP_TO_NULL in Load Script (Analysis/Tab/Component). When the crop is done through Selection Views, it works correctly, but when the crop is done using PQL in Load Script, filter does not work for Variant and Process Explorer. Examples below: FILTER ISNULL(CALC_CROP_TO_NULL(FIRST_OCCURRENCE['XXXXX'] TO CASE_END, ACTIVITY_COLUMN())) = 0 Or FILTER CALC_CROP ( FIRST_OCCURRENCE['XXXXX'] TO CASE_END, ACTIVITY_COLUMN()) = 1  Thanks 

71
R
Level 2

Badge Winners

  • Qualified to Build Views
    adrian.michlhas earned the badge Qualified to Build Views
  • Qualified to Prove Celonis Value
    anuhya.yedot11has earned the badge Qualified to Prove Celonis Value
  • Qualified to Identify and Drive Opportunities
    anuhya.yedot11has earned the badge Qualified to Identify and Drive Opportunities
  • Qualified to Deliver Business Value with Celonis
    suresh.jassahas earned the badge Qualified to Deliver Business Value with Celonis
  • Celonis Technical Expert
    anuhya.yedot11has earned the badge Celonis Technical Expert
VIEW ALL
Community Code of Conduct