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.

  • 759 Topics
  • 2,040 Replies
759 Topics
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Convert to Date

Dear All,in my source data I have a field that I need to convert to Date.My field mask is DDMMYYSerialnumbe and represents barcode.I have used TO_TIMESTAMP and SUBSTRINGTO_TIMESTAMP(SUBSTRING(BSEG.ZUONR,0,2)||.||SUBSTRING(BSEG.ZUONR,2,2)||.||20||SUBSTRING(BSEG.ZUONR, 4, 2), DD.MM.YYYY)Sometimes however bardode has incorrect format. Can I have a function that will convert to date if format is ok and leave NULL is format is not ok?

05
D
Level 1
5 years ago
N
Level 3
neel.neelLevel 3
asked in Data Ingestion & Infrastructure
Lastest/Greatest Date

Hello AllI am trying to capture the latest date of a field.Ex: For VENDOR 1234 which has three separate PO Dates:PO Entry Date 1/1/18PO Entry Date 3/1/19PO Entry Date 2/1/19I would like the result of this formula to display Most Recent PO Entry Date: 3/1/19Thanks !

01
C
Level 1
5 years ago
G
Level 1
georgia.loveLevel 1
asked in Data Ingestion & Infrastructure
Accessing all folders and analyses within a project

I have successfully connected via the python API to my Celonis instance.I can see that each folder or analysis has an attribute to access which project it belongs to. ie: folder.projectHowever, if i start from a specific project how do i obtain a list of folders and analyses within it?Im essentially aiming to get something like this to begin with:for p in Project.load_all():print(p.name)for f in p.Folder.load_all():print(\\t\\t+ f.name)for a in p.f.Analysis.load_all():print(\\t\\t\\t + a.name)

01
D
Level 1
5 years ago
N
Level 3
neel.neelLevel 3
asked in Data Ingestion & Infrastructure
Check Formatting of Data in Field

I am trying to check the Number of records that do not comply with std format (XX-XXXXXXX) within a specified field.Any help is greatly appriciated !

01
F
Level 1
5 years ago
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Connection KPI for custom Activity KPI

Dear Colleagues,I have built a custom Process Explorer Activity KPI, that takes the number of activity occurences from Case Level (BSEG table) and aggregates on header level (BKPF). This is because some activities are happing on header level, regardless of how many invoice lines we have. For example I post invoice only once and want to show value 1, even though it can be posted on 5 vendor item lines (BSEG=5).I want to apply the same for Process explorer connection KPI, but I dont know how to handle it.Can you please help me understand how to apply the logic to connection KPI? Details in attachement.Thank you very much (173.9 KB)

52
K
Level 3
5 years ago
.
Level 4
.14600833Level 4
asked in Data Ingestion & Infrastructure
From a specific activity to the “NEXT” one

Hello everyone, is there a way to calculate a duration between a specific activity (lets say A) to the next activity (whichever it was). Thank you!

25
.
Level 4
5 years ago
oliver.joere
Level 3
oliver.joereLevel 3
asked in Data Ingestion & Infrastructure
Same data model used by different business areas

Weve got the challenge that one data model (for O2C) is used by several different business areas like Sales, Logistics or Finance. Every business area likes to get their specific process activities defined in the data model and number of activities increases significantly. In order to avoid that every business area needs to deal with very detailed activities they are not interested in Id like to provide a customized data model for each business area just showing their relevant process activities. Due to license restrictions we could not simply multiply the data model. Now Im looking for ideas how to solve this issue.

25
A
5 years ago
S
Level 3
sachin.rajpu12Level 3
asked in Data Ingestion & Infrastructure
Global Variable

Hello Celonis Team,Today I am using a variable that is defined within an analysis.How can I define the variable at the Data Model level so that we can use the variable throughout all the analysis that is created using that Data Model?Regards,Sachin

02
D
Level 3
5 years ago
S
Level 3
stefan.grossLevel 3
asked in Data Ingestion & Infrastructure
Getting Difference in consecutive data values in time series data (column chart)

Dear all,I have a time series plot of the automation rate like the following:x- Axis: ROUND_MONTH(EKKO.AEDAT)y-Axis: KPI(Automation Rate) (standard automation rate formula; should work then with any KPI)My Goal is to calculate the difference in the automation rate between the current month and the previous one i.e. get as result 4.8%.How to do this in celonis? In the end I want to have a list of KPIs which from design point of view look like the followingIs there a simple way to calculate the 4.8% in a dynamic way (the 7.33% is coming from 2 years of data)?Thxs & Br,Stefan

12
S
Level 3
5 years ago

Badge winners

  • Celonis Certified Data Analyst
    el.mostafa.janahhas earned the badge Celonis Certified Data Analyst
  • Masterclass in Implementation
    jumbo.szkhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    makun.sharmhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    yuya.sasathas earned the badge Masterclass in Implementation
  • Celonis Certified Data Engineer
    isabella.pau11has earned the badge Celonis Certified Data Engineer
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2024