- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Product Q&A
Data Ingestion & Infrastructure

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

When you subscribe we will email you when there is a new topic in this category

759 Topics

Recently active

Most replies Most views Newest first

steven.berndLevel 3

asked in Data Ingestion & Infrastructure

Delete 0 values

Hello, I use my formula (CASEWHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%' THEN 'South Saxony'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-A%' THEN 'Saxony-Anhalt'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-W%' THEN 'West Saxony'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-B%' THEN 'Brandenburg'ELSE ' ' END) to cluster values. Works great, except that it always gives me the ELSE values as 0 in my graph. 0 means that there is actually no ELSE, or in other words, everything is clustered. How can I hide the 0 in the formula or in the component filter? thx :-)

1 year ago

daniel.schus12Level 3

posted in Data Ingestion & Infrastructure

Hey Peeps,

Hey Peeps, can someone help me. I try to connect, the correct PO to the corresponding SO in the IM Datamodel.See picture below. I tried the BIND() and several PU functions. Would be great if someone could help. Thank you. Daniel

1 year ago

ravi.kumar23Level 4

posted in Data Ingestion & Infrastructure

docs.uipath.com

===============================Usability of MarketPlace Connectors in "REALITY"================================= Hi Team,I have started my market place journey by installing SAP "Order to Cash" Connector. Below was my experience :1)I tried to install the app in studio but it gave multiple errors for the Data Model.2)I looked at the data model and tried understanding it. -There are no documents to understand why that data model is build in the way it is.3)I looked at standard SAP tables and tried to understand it by looking into transformation.4)Transformation does have big quereis and most of the places there is no explanation of what does those quereis mean.5)I finally reached SAP functional consultant and technical resource to help me understand the quereies.6)Currently i am working with them and reverse engineering to understand what has been provided with connector.7)Parallely i raised a ticket to Celonis support for providing comprehensive documents but they re

1 year ago

jannes.nagel12Level 2

asked in Data Ingestion & Infrastructure

Celoxtractor - Custom Messages in Extraction Log

Greetings,is it possible to display custom messages, defined in the python script of the celoxtractor, in the real time log of a extraction (when the extraction gets executed)? We are currently writing debug messages to local logs on the celoxtractor server. Having it directly in Celonis would be a blessing. Best Regards

1 year ago

dan.griebLevel 3

asked in Data Ingestion & Infrastructure

How to analyse SAP Credit Mgmt | Use/Encode BALDAT in EMS?

Hi Everyone,We work on the Accounts Receivable Usecase and want to include the credit management.Analysing the outcome of the credit checks and understand reasons for credit blocks is the goal.The logs from the credit check results are stored in the Application Logs BALHDR and BALDAT.However, the information in BALDAT is encoded and therefore not directly usable in Celonis.SAP decodes information from BALDAT by the Function Modules BAL_DB_SEARCH ,BAL_DB_LOAD, BAL_LOG_MSG_READ. Did someone come across this use case recently?Do you have any idea to solve this? I appreciate your support.Dan

1 year ago

irfan.suria12Level 3

asked in Data Ingestion & Infrastructure

Excluding specific dates from the throughput time calculation

Hi all, how can I exclude specific dates like bridge days from a throughput time calculation? I am already using REMAP_TIMESTAMPS with calendar specification, but INTERSECT only accepts two arguments and they are already used for factory calendar TFACS and WEEKDAY_CALENDAR. Ideally, I would be able to give INTERSECT a third argument to exclude certain dates and times, but that does not work. Any other ideas or alternatives?

1 year ago

dinesh.kumar35Level 3

asked in Data Ingestion & Infrastructure

What's the best practice for Master Data tables Load, Full or Delta?

Hi Experts,Could you please advise what's the best way to load Master Data tables like Vendor, Material etc. In my opinion, since the tables are not huge, can be fully loaded each time. Any different view suggesting delta load etc. from a best practice perspective? Please guide. Thanks!

1 year ago

ravi.kumar23Level 4

posted in Data Ingestion & Infrastructure

Hi Team,

Hi Team,What is the standard way how to document your pipelines from Analysis -> Data Model -> Transformation -> Extraction.Is there holistic view in Celonis which shows these relationships in one shot.

1 year ago

ravi.kumar23Level 4

asked in Data Ingestion & Infrastructure

Order to Cash Market Place Connector Transformation Logic

Hi Team,We are trying to implement "Order to Cash Market Place Connector"We have installed the connector but not able to utilize the transformations which are written. Does anyone know the logic for the transformations written in the Full Extraction ?

1 year ago

raman.silot14Level 4

asked in Data Ingestion & Infrastructure

subtracting two kpis in views

how can we subtract one kpi value in a kpi list with another kpi value existing in another kpi list and show the difference in a seperate kpi ?

1 year ago

Anonymous

asked in Data Ingestion & Infrastructure

Version control best practice

Dear all, I started new DCP project from this month. I installed Process connector and Analyses from App store then modified some of Vertica SQL in transformation, and PQL in the analysis. After some changes, I found that I am not confident which code I modified. Referring to SAP ABAP or Java or some other languages, we normally can use version control tools, like Git, Subversion, that can manage who and when code is committed, which part of code was changed (before/after). In Celonis Project how to manage source code version ? Do you have your best practices ? Best regards, Kazuhiko

013

1 year ago

frederick.coutr12Level 2

asked in Data Ingestion & Infrastructure

The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]

Here is the context of this error message (from EMS) when trying to connect to the DB:Extractor has been installed on client premises (Windows Server 2019) with OpenJDK11Target DB is running on Windows 2008 server. We're using Celonis to analyze processes prior to a system (legacy as you can see) migration.The same error message appears in the extractor logs obviously.Any insight on how to fix this problem ?

1 year ago

michael.walzLevel 2

asked in Data Ingestion & Infrastructure

How to detect the first change event in CDPOS table (S4/HANA)

Hi all, I have an issue with the way that the data in the CDPOS table is stored in S4/HANA. The issue occurs when an event triggers multiple follow-on events in SAP. For example, changing the company code (BUKRS) on an invoice will update the country code automatically (LAND1) at the same time. The user has only performed one change, but two are reflected in the CDPOS table with the same date, time, change number etc. When creating the activity in the transformation, I wish to capture the first activity that the user has performed, not the follow-on activity. Is there a way to detect which CDPOS entry is the first activity? Example of CDPOS entry CHNGENR FNAME DATE USER000001 BUKRS 01-01-23 12:00 John Smith000001 LAND1 01-01-23 12:00 John Smith Cheers,Michael

1 year ago

kiran.kanja14Level 2

asked in Data Ingestion & Infrastructure

Generated months using RANGE_APPEND but how to fill value using PQLExample: Lead time value changed in 2022-03 as 40 to 30 and after no change, the requirement is to generate months from 2022-04 to till now and show the 30 value to all forward m

Need to do in PQL, not in backend SQL

1 year ago

.146004200Level 5

asked in Data Ingestion & Infrastructure

Behaviour of the Process Explorer when applying attribute selections / filters

The premise is in regards to the process explorer and its behavior when applying different levels of filters:applying process-related filters (flows through, select cases going from A to B) everything works as expected.Applying attribute selections on an activity level, i.e. selecting all activities performed by a single department, process explorer returns all cases where at least one activity within that case abides by the selected filter.Thus it appears that the behavior of the process explorer is as follows:First find all activities that meet the defined conditionSelect all cases that belong to those activitiesvisualize all activities for those cases in the process explorer without filtering the activities that do not meet the criteria. What makes this matter more complex is the following:Standard Process Explorer KPIs (case count, activity count) are calculated based on the latter conditions. So all information of the case and all activities regardless of activity attribute condit

1 year ago

lizzie.willi12Level 2

posted in Data Ingestion & Infrastructure

guidemesolutions-startover-c4c.us-1.celonis.cloud

Hi Can anyone help me understand this error message please? I've used templates throughouthttps://guidemesolutions-startover-c4c.us-1.celonis.cloud/

1 year ago

alex.timm11Level 3

asked in Data Ingestion & Infrastructure

Is it possible to use Range as graph Dimension?

Hello everyone,I would like to make a graph where Dimension is a range.Mock Up: I have got a table with an Object ID, a Gross Value and a numeric Attribute A1.I would like to sum up the Gross Value if A1 is bigger than the Dimension and have a range with step of 5 as my graph dimension. The result would look something like the upper right quadrant of 1/x. I tried creating a variable as range, but PQL gives me the error, that the temporary table is not connected.Thanks in advance!

1 year ago

minakshi.malliLevel 2

asked in Data Ingestion & Infrastructure

How to calculate working hours spent for a CASE on a activity

For Ex Time spent on Deliver block activity. I am using below formulaDATEDIFF ( HH, PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Set Delivery Block, Set Default Delivery Block)),PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Remove Delivery Block)) )But this formula will consider weekend and holiday hours as well.Please let me know how to get the working hours only .I have tried below formula as well after looking at Using workdays_between without a dedicated calendar table Codes & Statements Hi guys, my problem ist actually quite simple. I want to calculate the number of workdays (monday till friday) between two given timestamps. The relevant function requires me to reference a specific calendar table from the data model. Within the data model options, however, the possiblity exists to define a custom calendar without implementing a dedicated table (simply by selecting relevant days and time windows). My

1 year ago

abhishek.chatu14Level 7

posted in Data Ingestion & Infrastructure

Hello, I wanted to understand the C4C APC storage consumption to view

Hello, I wanted to understand the C4C APC storage consumption to view The understanding is that views generally don't consume any data in Celonis or consumption is dependent on the parent. I wanted to understand if the same holds for C4C environments as we are currently noticing that all views created in C4C consume data and some consume more storage than the parent as well.

1 year ago

gabriella.koopmLevel 2

asked in Data Ingestion & Infrastructure

Hi,I would like to count the cases which have a certain activity. (not the same as activity count) If they have the activity 40 times per case I want only to count them as 1 per case. Does anyone have a suggestion? Thank you in advance

The standard ratio count does not work because it takes into account the activities and not the cases.I have tried: filter count (which does not work because it counts activity and not the cases)I tried multiple PU_count and PU_count_distinct (also did not work)I have tried case when (activity = "XX") then count (cases) else 0. (But this is not allowed in Celonis)

1 year ago

venkata.vara.prasad.nallaLevel 1

asked in Data Ingestion & Infrastructure

How to find descriptions for oracle ERP tables ?

Hi Team, can you please help if there is away to find Descriptions for oracle tables like Leanx for SAP. Thanks,Venkat N

1 year ago

anoop.singh.rajpuLevel 2

asked in Data Ingestion & Infrastructure

How to switch between the Data source for an existing connection

We have a celonis instance which as established connection with a SAP testing sandbox. I want to know if we build a data model and then the Analysis using this data currently and later want to use the SAP Production instance data for these analysis, then what steps we need repeat. Does it involve lot of changes OR I can simply go and just update the data source URL (Host and port) in the connections. Please help.

1 year ago

parth.daveLevel 2

asked in Data Ingestion & Infrastructure

I am trying to create data model with multiple csv file. I am looking to merge those file within celonis using any available transformation and use the combine data to cary out process mining

I have tried using PQL transformation but again when I go to process model, mark each file as activity file and then do data load, it is loading multiple file individually. What I can do to combine all this files into one data model and then carry out process mining.

1 year ago

sree.cLevel 4

asked in Data Ingestion & Infrastructure

can a Delta load be configured based on string column instead of changing date field

1 year ago

vamshi.vignesh.d13Level 2

asked in Data Ingestion & Infrastructure

Does Replication Cockpit in Data Integration captures only new entries being added or structural changes to tables as well

For e.g. when a new column is added to the table in SAP systems does replication cockpit captures these or we need to run data job for this?

2 years ago

Page 10 / 31

Badge winners

laura.walku11has earned the badge Celonis Certified Data Engineer
alessio.vasinhas earned the badge Celonis Technical Expert
alessio.vasinhas earned the badge Qualified to Build Action Flows
eric.gring11has earned the badge Qualified to Manage Implementation Projects
pranav.prashant.pattehas earned the badge Celonis Technical Expert

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook