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.

  • 801 Topics
  • 2,108 Replies
801 Topics
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Filter Date Range

Hello Community,I am trying to create a data range for my analysis.I have the below equation which works:FILTER CASES.NetDueDate BETWEEN ADD_DAYS(TODAY(),-6) AND TODAY() ;However, i would like to replace the 2nd TODAY with the last day of the prior month - 6.Can you please let me know if this can be achieved in Celonis?Many thanks,Anna

110
V
Level 1
J
Level 2
jacob.visse12Level 2
asked in Data Ingestion & Infrastructure
How to set up 2 filter criteria’s on 1 table

At this moment we have a filter on the extraction of the EKKO and EKPO which filter all orders and items based on the start date 31-07-2018.However, we want to add a second filter or expand the filter that fetches all orders starting with 37 which are in the EKKO and EKPO and started before before 31-07-2018.All other orders not starting with 37 must be retrieved via the previously set filter of start date 31-07-2018.The result must therefore be that we all pick up orders starting with 37 and the other orders only if they have been created as of 31-7-2018.How should we set up this filter?

10
J
Level 2
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Calculate Euro value but only for the past 6 months (moving date)

Hi Community, I am building an OLAP table and I would like to calculate the average value over the past 6 months. With the 6 month time frame changing as time go on. CASE WHEN ROUND_MONTH(ADD_MONTHS(CASES.PostingDate, -6)) THEN TRIMMED_MEAN(CASES.Value(EUR), 5, 5) ELSE NULL END I have tried various options of the above and cant get it to work. Can you please help? Thanks, Anna

10
.
Level 4
.
Level 2
.14600831Level 2
asked in Data Ingestion & Infrastructure
Need help with the function to make a numberic quantity

Hi.We have function CASE WHEN KPI(FFF_TIME_PROCESS)><%=FFF_TIME_PROCESS_1%> THEN 1 ELSE NULL END.How I get a numberic quantity from function?With function COUNT it doesnt workDetails:in KPI(FFF_TIME_PROCESS) we have AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(EVENTS_EVENTS.EVENT_DATE, DAYS)))in variable <%=FFF_TIME_PROCESS_1%> we have AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS("EVENTS_EVENTS.EVENT_DATE, DAYS)))

00
.
Level 2
.
Level 2
.14600794Level 2
asked in Data Ingestion & Infrastructure
Conditional formula based on selections

Hello, Is it possible to have component value conditioned by selections from a button dropdown? Ex: Button Dropdown (Country) options: Portugal / Spain / German If Portugal selected -> VBAP.BUS_UNIT_TEXT IN (FA, PA)If Spain selected -> VBAP.BUS_UNIT_TEXT IN (DI, MC)If German selected -> VBAP.BUS_UNIT_TEXT IN (SI, CP) Multiple selection possilbe. Thanks in advance. Best Regards, Joo Bu

20
.
Level 2
C
Level 3
cristian.cristLevel 3
asked in Data Ingestion & Infrastructure
PU Funtions Count Vendors with Criterias

Dear teamOur Objective is to obtain per Company Code , the number of vendors which net order value in a given year-month is greater than certain value for PO a particular type of POin the example below , Year=2019, PO Type ZLV, Amount 500KThe KPI below is our best last attempt, Still InaccurateKPI 2019:SUM ( CASE WHENPU_SUM(LFA1, EKPO.NETWR_CONVERTED,EKKO.BSART = ZLV AND EKKO.AEDAT_YEAR=2019) > 500000.00 AND EKKO.AEDAT_YEAR=2019 AND EKKO.BSART = ZLVthen 1.0/PU_COUNT(LFA1, EKPO.EBELN,EKKO.BSART = ZLV AND EKKO.AEDAT_YEAR=2019)ELSE0.0END)My Understanding is that the problem resides in the way we designed the KPI particularly in the Denominator used to obtain the Vendors instead of the cases. if you take a look in Line 3, we are considering all the cases that meet the criteria, except for the condition > 500.000,00 ( I did not include this conditions because I dont know how) this is why the KPI is approximately to the value, in the example below, outcome is 10.09 which Rounded is 10

70
V
Level 1
S
Level 2
srinath.ramgo12Level 2
asked in Data Ingestion & Infrastructure
Missing data connection in BMC Remedy Process connector

While installing BMC Remedy process connector in app store I could see that it is without a data connection and has only the transformation. Could you please provide more information on whether its possible to configure a data connection to BMC Remedy using its API.

10
S
Level 2
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Use Pull up and header filters

Dear All,I have the following use case: for each document I need to compare if the value is 5 times more than average for given vendor and highlight such positions. This I have already done using domain table (formula also includes certain exceptions given by the business). The only problem is that is always counts values globally and does not limit to the document range from date range selected. Is there any way to make it work, so that the average is calculated only from the range of selected cases?image879296 8.07 KBimage2105372 46.4 KB

00
K
Level 3
F
Level 3
francisco.da.siLevel 3
asked in Data Ingestion & Infrastructure
[ISSUE FORMULA] Considering only weekdays in a Throughput Analysis

Hey there!Hope you are doing fine.I was wondering if it is possible to consider only weekdays in a normal throughput formula, or even right from the get go, in already built-in dashboards such as the follow one:image1269361 15.3 KBIs there already a pre-built formula for this problem?AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Consumption] TO LAST_OCCURRENCE[Purchase Order Release], REMAP_TIMESTAMPS(Consigned_EventLog_xlsx_Consigned_EventLog.TIMESTAMP, DAYS)))For example in this formula.Looking forward to hearing from you Best,Francisco

20
F
Level 3
G
Level 3
gopinadh.kanch12Level 3
asked in Data Ingestion & Infrastructure
Celonis Authorization Objects: query-definitions.xml.sample

Hi All,I would like to create query-definitions.xml.sample file and upload to application server to get the values for authorization objects.Could someone provide an example file for query-definitions.xml.sample!Thank you.

10
V
Level 1
V
Level 2
vilas.kulkaLevel 2
asked in Data Ingestion & Infrastructure
IBC - Cloud table loader - Installation issue

We are using Celonis provided tool to transform the data files extracted from SAP ECC and upload into IBC cloud. Since this process is time consulting, we wanted this to be done by multiple people in our team. We are having issues in installing this tool in our client provided laptops. Everyone in our team is facing same issue. During installation we see error installing module names pyxlsb The error description shows "Maximum retries exceeded with url SSL Error - SSL Certificate Verify Failed During actual upload - we get error No module named Pyxlsb Did anyone else encountered this type of issue before? What do you think is probably solution? Thanks, Vilas Kulkarni NTT Data, McKesson - Celonis implementation project

10
V
Level 1
W
Level 2
westenhöfer.westeLevel 2
asked in Data Ingestion & Infrastructure
Percentage of cases covered by the 5 most common variants

Hello,I want to calculate a Number KPI that will return me an percentage value of the cases covered by the 5 most common variants. The code should be similar to the % of cases covered in the Variant Explorer, but will always select the 5 most common variants in respect to the selection.Neither the Number of variants function nor the PQL references help me with my problem.Can someone help me out?Thanks in advance!

20
D
Level 2
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Case_key count including & excluding certain activities

Hi Community,Hope everyone is staying healthy.I would like to build up our KPI statement but am having trouble making the formulas work as they should.I would like to count certain activities from the activities tables, but also exclude certain cases if they also pass through for example Changes to Document activity.For example:COUNT(DISTINCT CASE WHEN (ACTIVITIES.ActivityEN = Start of FI Non-Compliant Approval AND ACTIVITIES.ActivityEN != Changes to Document)THEN CASES."_CASE_KEY" ELSE NULL END)When applying the above formula, i get the same result regardless if I included the the "!= Changes to Document or not.I have also tried using a PU_COUNT formula but receive an error message:PU_COUNT_DISTINCT (CASES.ACTIVITIES.ActivityEN) IN Start of FI Non-Compliant ApprovalAND PU_COUNT_DISTINCT (CASES.ACTIVITIES.ActivityEN) NOT IN Changes to DocumentTHEN CASES."_CASE_KEY" ELSE NULL ENDPlease help.Cheers,Anna

30
D
Level 2
V
Level 2
vilas.kulkaLevel 2
asked in Data Ingestion & Infrastructure
Procure to Pay Model question on multiple processes - Best practices / Recommended approach

The PTP model which we are working on has several major processes such as Standard ProcurementStock Transport OrdersDrop Ship purchase orders (originated from Sales orders)Returns Purchase ordersInter-company purchase orders etc.International purchase orders etc. In order to see these processes separately under Celonis IBC cloud., we can develop Custom transformations. However we want to understand what is the best practice or recommended approach. To elaborate the question - Let us consider example of one activity Create purchase order item Is it recommended to create multiple activities - one for each process such as Create standard purchase order itemCreate stock transport order itemCreate Drop Ship purchase orders itemCreate Returns Purchase order itemCreate Inter-company purchase order itemCreate International purchase order item etc. OR Is it recommended to just use the common activity name Create purchase order item for all the above processes and use attributes such as docume

00
B
Level 2
C
Level 3
carina.carin11Level 3
asked in Data Ingestion & Infrastructure
Component Filter: Crop Process

Hi,Id like to create a component filter to filter a dashboard sheet and its KPIs for a Subprocess.E.g. our KPI Touchless Order Rate should only be calculated for the subprocess process start to create delivery.I can get the right result, if I use the crop selection but I want to have this as a component filter.Can anyone help me with the right PQL filter formula?Thanks ,Carina

60
J
Level 1
B
Level 2
benedikt.tiege12Level 2
asked in Data Ingestion & Infrastructure
Postgres Datasource

Hi, i am trying to connect to a Postgres Datasource via jdbc. It is not possible do get a connection. I always get the information unable to connect. With our Hana Source everything is working fine. Any advice? Beneditk T.

10
V
Level 1
.
Level 4
.14600775Level 4
asked in Data Ingestion & Infrastructure
Complicated OLAP table using variables, pulls and date calculations

Hi Team,I have a rather complex OLAP table that I am looking to build and need your help. Its a two step issue that I am hoping that someone has some guidance.Part 1.We have a table in the back end that contains pmt term information. We have ranked the payments terms from 1 best to 30 worst. I have also created a drop down variable for the user to be able to select 1, 2, or 3.Essential, what i need to happen is, based on the current payment term that we have for the invoice, if a user selects 1, in the variable, then the next best pmt term will be populated in that column. if they select 2, then it would skip to the 2nd better pmt term that is on that list. so on and so on.image697258 7.47 KBCan you please advise if you can help me solve this issue.Part 2:Given that the first part can be done.The next part would be to calculate the days difference between the net due date of the original pmt term and the new payment term net due date. The original payment net due date we already pull i

10
.
Level 4
A
Level 3
alexander.alexaLevel 3
asked in Data Ingestion & Infrastructure
Using “LIKE” in Process Functions as CALC_THROUGHPUT

Dear Colleagues,I have a problem: I am calculating days with CALC_THROUGHPUT function. For some events I need to use LIKE function. But As I see, it is not possible to use one, only in func. FILTER or CASE WHEN. But How to apply event in CALC_THROUGHPUT when you need to cut a part of name?For example.AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Event1]TO LAST_OCCURRENCE[Event2:%],REMAP_TIMESTAMPS(EVENTS_EVENT.EVENT_DATE, DAYS)))Or maybe it can be done by another function of Celonis.Thanks

50
A
Level 3
G
Level 3
gopinadh.kanch12Level 3
asked in Data Ingestion & Infrastructure
Data model loading Case table along with Activity table

Hi Team, I got doubt while loading data model. I have created a data model and added only activity table and stated loading from hana to data model. But data model loaded case table along with activity table without adding the case table to the data model. Is the case table loading automatic if we add and load only activity table to the data model?

10
D
Level 2
D
Level 2
diego.diegoLevel 2
asked in Data Ingestion & Infrastructure
Ariba-P2P Implementation

Hi, We are using Celonis 4.5 on premise and we have implemented ECC-O2C data model. To get further, we would like to implement ARIBA-P2P data model, but we dont know which is the correct approach to extract the data to Hana. Do you have some technical information about how to extract this data? Thanks in advanced! Diego

10
D
Level 2
.
Level 2
.14600899Level 2
asked in Data Ingestion & Infrastructure
Need to connect Database (HANA/ SQL Sever) to Celonis IBC Sandbox

Hi Team, Greetings! I have a Celonis Sandbox instance (https://ey-in-sandbox.demo.celonis.cloud/process-mining/ui) and we are trying to connect this to HANA DB and SQL Server by providing the credentials but are unable to get the connection working. Below are the details. 1>>The HANA DB is on Azure Cloud, we had selected database type SAP HANA and entered the other details which didnt work and we got a simple error message unable to test the connection . What other configuration needs to be done (please specify the details) 2>> The SQL Server 2012 is deployed on a Windows server system (on Azure cloud), we opened the TCP port 1433 at both the OS level and the Azure level for the same for this but the connection has not worked. Could you please help.Thank you!

20
V
Level 4
A
Level 2
abhishek.mitra11Level 2
asked in Data Ingestion & Infrastructure
Celonis generic error while extracting database table

Hi, I am encountering a generic error support code while extracting data from an Oracle ERP database. Celonis Support ID: 19442d8c-7c0e-4145-a964-85883ac4cfab Any idea on why is this coming and how to resolve this? I have also raised a support ticket but havent received any response yet. Error log does not say anything else, hence it is not possible to debug the problem. Please help. Thanks, Abhishek Mitra Tata Consultancy Services Ltd.

00
V
Level 4
K
Level 3
krzysztof.sitar11Level 3
asked in Data Ingestion & Infrastructure
Select dates in dropdown

Dear Colleagues,I have the following problem: I am calculating the DAYS_BETWEEN certain events and if they are more than 1 day, it is to be counted in KPI.image89879 5.73 KBThere are exceptions to this standard rule for month end closing period. I would like to list those dates (or allow users to select them accordingly to closing calendar) and if the date of order is for these particular cut off dates, then is it also acceptable.I created a dropdown and even tried to convert it to date, but I think it is kept as string by definition. Is there any other way to include these exception dates?

20
M
Level 1
H
Level 2
hugo.gonçaLevel 2
asked in Data Ingestion & Infrastructure
Single KPI component

Hello,Im having an issue when I try to use my code in the component Single KPI returning a number.When I use that same code in an olap table it works, when I copy past that code into the single KPI it shows me the value I want in the preview but when I click done it doesnt show the number only a dash.image1205898 63.3 KBThanks in advance

00
V
Level 1
D
Level 2
dom.tLevel 2
asked in Data Ingestion & Infrastructure
Average throughput times for two target process flows

Hello,i would like to calculate the combined average time that it takes to move from:Step 3 -> Step 4 (3 days)Step 3 -> Step 5 (5 days)The result i am looking for should be 4 days (for illustration, both process happen once above). I have written the following code but get an error returned to me:AVG(AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Step 3] TO LAST_OCCURRENCE[Step 4], REMAP_TIMESTAMPS(TABLE_TRANSFORMED.AUDITTIMESTAMP, DAYS))) AND AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Step 3] TO LAST_OCCURRENCE[Step 5], REMAP_TIMESTAMPS(TABLE_TRANSFORMED.AUDITTIMESTAMP, DAYS))))Would anyone be able to advise on this?Best,Dominic

30
V
Level 1

Badge Winners

  • Celonis Certified Data Analyst
    sudhakar.ybhas earned the badge Celonis Certified Data Analyst
  • Qualified to Build Views
    Gero Busatishas earned the badge Qualified to Build Views
  • Qualified to Write PQL Queries
    sahil.rathe11has earned the badge Qualified to Write PQL Queries
  • Qualified to Manage Implementation Projects
    delano.dewet11has earned the badge Qualified to Manage Implementation Projects
  • Qualified to Create and Deliver Demos
    anna.jakub12has earned the badge Qualified to Create and Deliver Demos
VIEW ALL
Community Code of Conduct