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.

  • 769 Topics
  • 2,057 Replies
769 Topics
M
Level 3
mara.aderm11Level 3
asked in Data Ingestion & Infrastructure
Conditional formatting based on variable

Hello all, I have a dropdown for choosing a time dimension (day, week, year etc.). My charts change with changing this dimension so I can see my data on a more or less aggregated base. The only thing I struggle with is the conditional formatting of the dimension. I tried with setting a second variable as the target formatting but dont know how to insert this variable in the formatting field of my chart dimension. How can I do this? Thanks in advance!

40
milan.eric
Level 3
henning.gertz
Level 3
henning.gertzLevel 3
asked in Data Ingestion & Infrastructure
Combining PU Function & CALC_CROP Function

Hi,is there a way to combine a PU Function with a CALC_CROP Function? CASE WHEN PROCESS # 'Change Requested Delivery Date' THENTO_TIMESTAMP ( PU_FIRST ( "VBAP" , "_CEL_O2C_ACTIVITIES"."CHANGED_TO" , "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" = 'Change Confirmed Delivery Date'), 'YYYYMMDD' )ELSE"VBEP"."EDATU"END This is the formula without CALC_CROP. But doing this, Celonis is looking at the first "Change Confirmed Delivery Date".I would like to look at the first "Change Confirmed Delivery Date" Event after the last "Change Requested Delivery Date" Event.

10
henning.gertz
Level 3
A
Level 2
alice.sansoLevel 2
asked in Data Ingestion & Infrastructure
SAP extraction fails for abort in SAP system with log "Error: Error during Hash calculation for value 100"

Hi,I'm extracting data from SAP ECC, but when I try to pseudonymize fields from tables I receive an error of aborted operation from SAP system, with log "Error: Error during Hash calculation for value 100"Someone please know why? Thank you!

10
A
Level 2
s.a14
Level 3
s.a14Level 3
asked in Data Ingestion & Infrastructure
Collating data from different data pool

Is there a possibility of collating data from different data pools so that a dashboard can be built for task mining which will then enable us to see how many users have installed task mining and analyze the captured data which is residing in separate data pools for each teams?

10
s.a14
Level 3
C
Level 1
clemens.dries13Level 1
asked in Data Ingestion & Infrastructure
Data of imported tables is not updated

I have two data pools.(A) One data pool extracts P2P data from an SAP system. This connection is shared.(B) The other data pool uses the first data pool as a connection. The tables are synchronized. After extracting the table EINE in A, it is not automatically updated in B (see screenshots).The documentation states that it should be done automatically "If new rows are added to the tables and views of the exported Data Connection, the data will be available automatically in the importing Data Pools" https://docs.celonis.com/en/transfer-data-between-data-pools.htmlIt seems that there is a routine which updates the table in B at a certain moment. But I do not know how to control/trigger this.

10
C
Level 1
G
Level 2
giulia.francLevel 2
asked in Data Ingestion & Infrastructure
Jira Connection

Hi,we would like to connect our Jira project to Celonis with API.  we couldn't find a standard connector so we've created a New Extractor with Extractor Builder using REST APIs calls. For autentication we used API token as specified in the documentation. The connetion tests run succesfully but, when we try to Build the response we have this error message:"Cannot get samples from source system: Unable to read the response"  Can anyone help us to solve the problem ? Thanks for you time.Giulia 

60
Sverre Klein
Level 6
mukesh.gupta11
Level 4
mukesh.gupta11Level 4
asked in Data Ingestion & Infrastructure
Does anyone have the steps to do the data integration with the Dynamics 365 for order to cash process?

Does anyone have the steps to do the data integration with the Dynamics 365 for order to cash process?

10
mukesh.gupta11
Level 4
X
Level 3
xuegang.yuLevel 3
asked in Data Ingestion & Infrastructure
May I ask is it possible to connect with the local database in the training system?

I am trying to use uplink connection to create the connection between celonis platform with MSSQL database, but it's failed, can anyone help? thanks a lot!

20
X
Level 3
A
Level 3
alexander.grafLevel 3
posted in Data Ingestion & Infrastructure
Hallo together,

Hallo together,I like to select a dataset(date) within an App via dropdown. However the dropdown always sorts ascending. Is there any posibility to have earliest days on top?So like:2024-02-272024-02-262024-02-25...2018-01-01 instead of  2018-01-012018-01-02...2024-02-27  

01
dennis.pflug
Level 6
ankit.chatt13
Level 3
ankit.chatt13Level 3
asked in Data Ingestion & Infrastructure
Fetch login history to data pool?

Hello team Is there any way to fetch user login history to data pool?  Thanks In Advance  Regards,Ankit Chatterjee

00
A
Level 4
K
Level 1
karri.siddaLevel 1
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.

30
P
Level 2
K
Level 2
kamjur.abhisLevel 2
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?

answer

70
C
Level 2
joos.buijs
Level 6
joos.buijsLevel 6
asked in Data Ingestion & Infrastructure
Celonis EMS Impala error due to "-symbols in query

We are currently migrating to Celonis EMS, however we are experiencing an issue with the Impala connector. Celonis creates queries such as  Select * from "schema"."table" where Impala interprets " as string delimiter. Other tools that are talking to our Impala database, including Celonis on-premise, do not have this issue. Does anyone know how to configure the Celonis Impala data connection to change this? Many thanks in advance! Joos Buijs - APG

00
joos.buijs
Level 6
M
Level 2
manish.srima11Level 2
asked in Data Ingestion & Infrastructure
Is there a way to use the Pull Up functions in PQL Logics to display every line?

In my project, I'm experiencing an issue with PQL pull-up functions. I am utilizing pull-up functions because Level 2 and Level 3 Columns are generated based on augmented attributes (User Updated in Celonis). If I use those fields directly in the Logics, I get a common table error as we are pulling data from multiple tables.Using PU_FIRST gives me the oldest first record. Using PU_LAST gives me the latest record.I looked over the documentation, but I couldn't find any alternatives.I tried with BIND and DOMAIN Table Functionalities those are also not working. Please let me know if you have any knowledge on the aforementioned question Thanks in Advnace.

30
B
Level 1
Sverre Klein
Level 6
Sverre KleinLevel 6
asked in Data Ingestion & Infrastructure
CALC_CROP Filter statement

Hello! I am trying to apply a filter script on a process explorer component. I do not want to use a selection. filter CALC_CROP(first_OCCURRENCE['Start'] to last_OCCURRENCE['End'], "Activities"."Activity Name") = 1; For some reason it does not apply the filter and crop accordingly. Is there something I am missing? ('Start' and 'End' are placeholders)

50
M
Level 1
F
Level 3
francisco.da.siLevel 3
asked in Data Ingestion & Infrastructure
Dropdown button automatically changes table columns

Hey everyone!I was trying to do the same as one of Celonis examples, where a drop down button changes the initial dimension column in a OLAP table, at the same time as it changes the table title.Dropdown button selection - Company code -> Title "Purchase Order by Company codeLooking forward to hearing from you.Thank you for your help!Francisco

00
S
Level 2
R
Level 4
raman.silot14Level 4
asked in Data Ingestion & Infrastructure
Data model refresh update in front end

Hi,I want to show that a data model is successfully refreshed, in studio with the updated refresh date.What is the best possible way to achieve this ?

120
janpeter.van.d
Level 8
S
Level 3
sudhanshu.kumar15Level 3
asked in Data Ingestion & Infrastructure
I want filter first, second and third highest location based on FCR%how can i do that?

I want filter first, second and third highest location based on FCR% how can i do that?

00
L
Level 1
enrico.pugli12
Level 3
enrico.pugli12Level 3
asked in Data Ingestion & Infrastructure
What is the best way to do data ingestion with genesys?

Has anyone had experience in integrating Genesysis, telephone contact center software (https://www.genesys.com/)?There is no connector, there is no extractor, and Genesys does not store data in an externally accessible database. Has anyone had any experience? How did you establish the data connection to the source? Thanks

180
enrico.pugli12
Level 3
M
Level 1
md.asif12Level 1
asked in Data Ingestion & Infrastructure
What do you know about the term “Big Data”?

What do you know about the term “Big Data”?

00
R
Level 1
C
Level 1
chuck.wriskLevel 1
asked in Data Ingestion & Infrastructure
Total of Invoices for Vendor at Time of Invoice Posting

I am trying to create a formula to calculate the total of all invoices for a vendor (but not yet cleared) when an invoice for that vendor is posted. I am using SAP data, and trying to calculate using data from the BSEG table. I am displaying this total in an OLAP table in an analysis. I am passing in the posting date of the current invoice as a parameter ({p1}). The result displayed is the vendor invoice total for all invoices, for all records. PU_SUM("LFA1", "BSEG"."WRBTR", ("BSEG"."BUDAT" <= {p1}) AND ("BSEG"."AUGDT" >= {p1})) The Vendor Master table (LFA1) and the Invoice Line Item table (BSEG) are linked in the data model via MANDT (Client) and LIFNR (Vendor ID). Whatever help you can provide would be greatly appreciated.

10
B
Level 1
R
Level 3
rodrigo.vianaLevel 3
asked in Data Ingestion & Infrastructure
No data in the LIPS table when the delivery type is HOD, NL or NLCC

Hello, I'm trying to do an analysis where I require the item data from delivery notes ( LIPS table), however for some reason in this specific table I have no information regarding items with delivery type = HOD, NL, and NLCC, only LF and LR appear. I checked all analysis filters and found nothing. LIKP table has HOD, NL, and NLcc information and so do VTTTP and VTTK.Can someone tell me what the issue might be? Thank you

10
B
Level 1
C
Level 1
colm.horan12Level 1
posted in Data Ingestion & Infrastructure
Hi all,

Hi all, I am getting an error when I am extracting data in my training environment. I am attempting to extract a 200mb table from my Azure SQL database.  My data consumption is 1.74gb of 4gb. Data consumption levels had previously been exceeded on the 14/01/2023. I have attempted to upload even smaller tables and the same issue persists.Is there a quick solution to this.

01
janpeter.van.d
Level 8
S
Level 3
stefan.grossLevel 3
asked in Data Ingestion & Infrastructure
O2C Process Data Model Setup

Dear all, just out of curiosity. In the O2C Template data model the tables VBRP and LIPS are joined to the VBFA and then to VBAP. We are doing this in the transformation and join VBRK,LIPS directly to VBAP. image711316 16 KB What are the advantages of including VBFA in the process model? PQL Coding, Performance, Thanks & Br P.S.: Dont consider this question high priority

100
E
Level 2
A
Level 2
alice.sansoLevel 2
asked in Data Ingestion & Infrastructure
I'm working with views and I'd like to show a chart only when a runtime varible has specific value. How can I do that?

I'm working with views and I'd like to show a chart only when a runtime varible has specific value. How can I do that?

40
A
Level 2

Badge winners

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