Data Ingestion & Infrastructure

I want to extract a table "SRRELROLES" from SAP system. For this table, I have to use dynamic and private parameters on the column "UTCTIME" UTC Timestamp in Short Form (YYYYMMDDhhmmss).  I get an error for delta extraction since the data type I use is date (I have tried integer and double but neither worked)and the data type of UTCTIME is float according to SQL vertica in Celonis and UTCTIME has data type DEC in the SAP system.  My question is which datatype can I use for my dynamic and private parameters? Or how can I define a variable inside the FILTER STATMENT or DELTA FILTER STATMENT in order to get the max of the UTCTIME and use it for my delta extractions?

Hallo, as pycelonis states: Using this package you can programmatically interact with Analyses, Workspaces, Data Models, Data Pools and other Celonis objects. The package also allows pushing and pulling data to and from Data Pools and Data Models. I would like to programmmatically interact with celonis analysis (mainly) and extract the data for other purposes and to other sources. That means, the statement suggests to me the possibility to extract the data from Celonis into an external database like say MySQL. I dont find a supporting material on this in the documentation. Can someone shed a bit more light into the darkness here?

Hello friends! :) I have a bar graph with ROUND_MONTH("ACTIVITIES"."EVENTTIME") set as a dimension and a requirement for it to display the following: -For each month, we want to get a difference of new cases between said month and the previous one-It would be ideal to also get a percentage change compared to the previous month. Have you guys ever dealt with something like this? It seems simple enough, but I've been scratching my head with this one. Thank you for your help in advance!

Joining between different data sources are possible in global data jobs, e.g.  select *from <%=DATASOURCE:MDT_100%>.EKPO A join <%=DATASOURCE:MDT_200%>.EKPO B ON ... But is it possible to join each other within the scoped data jobs (MDT_100, MDT_200), that means Scope MDT_100:select *from EKPO A join <%=DATASOURCE:MDT_200%>.EKPO B ON ...

I push data in celonis using data push api (python methods), but column width of some of the is so high that it is showing entire content . is there any way to increase the column with from 80 to 240 in data push api methods

When I try to mine a process from an event log I see wrong activity in the beginning. And can't understand why is it there. As well, BPMN model is built incorrectly. I can modify it, but I don't see it in process or variant explorer in a modified way.  I use Python simulation to generate data. it simulates facility with several rooms where users can move and drink coffee. Coffee increases their heart rate. As well, the system starts displaying messages and offers users to drink water.  In the process model I get users have increased heart rate in the beginning and their moves between facilities are happening in one direction, while in reality they move randomly.  I try to understand what do I need to modify (Python code for data generation or something inside Celonis) in order to see the real model and a sphagetti diagram showing all possible users' movements and events.   

 The Celonis documentation does not specify passing the proxy configuration to docker. I don't know if the way to pass it to docker is to add one more line-e PROXY_ENABLED=true \\ -e PROXY_HOST=<host>, etc. Or how it would be since it depends on how the Docker image has been mounted. 

Dear all, I would like to use Action flows to push an excel file (xslx) to Celonis using Action Flows.  Use Case: Excel file is received via email and up until now manualy uploaded to a data pool. I am successful in accessing this email, downloading the excel file.  I am following this tutorial to learn how to push a CSV file to a data pool. Create and Push CSV to Data Integration (celonis.com) However, it does not work for XSLX files for me. I changed the file type already to "XLSX" and "EXCEL". Error is: "something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID" I also tried to find a module that would help me translate an excel to CSV but could not found anything. Thank you,Gregor

Documentation of conditional filters Hi @mentor.vucit​ , I just came across your answer (link) and I am wondering where I can find the documentation of conditional filters? They seem very powerful but I can't find any of this in the celonis documentation. BR,Florian 

Hi Team,We are working on reviewing our landscape with respect to Celonis best practices.Currently we have multiple data pools and extracting data from multiple connections.In many cases we can have a situation where:1)Getting data from same connection but using extracted data for different data models.2)Getting data from different connections and combining extracted for single data models.3)Often times buiness requirement for same process may vary for different units and they would want to see different views / analysis / actions for them in those case how the data pool should be structured. Are already there best practices along these lines with pros and cons?

In one system I have two processes with two number logics. First one is called S_ID and shows Process A ("From Receiving Technical data to releasing technical data for invoicing". 2nd one is called "L_ID" and shows process B "Creating data set to invoice sent"  If data has status 4 in the system, the data has been transformed from process a to process b and every s_id is combined with a L_id.  I checked with a table if ir possible to see status4, s_id and L-id in one table and cheked in the source system if the data is correct- it is.  In the Data model I created two activity tables and zwo cases tables, one with S_ID logic, the other one with L_id logic.  The last step should be to combine the data so the customer is able to see the whole process from receiveing the technical data to invoice sent.  I tried it with this script, and I know it is not correct yet:  case when"TableS_id"."STATUS"= 4then Bind("TableS_id", PU_first(&

I am trying to extract the date from a string. the date comes after '-'. The challenge is that there can be more than one instance of '- '.So, tried to find the '-'followed by a space and '/'after 3characterString sample: $$$$$ $$$$$$$: $$~$$$$ - $$$$ $$$$$$$$ $$$ $$$ ~$$$$ $$$$$$$$ $$/$$/$$$$ - 07/01/2022 $$$:$ $$$:$ $$$:$.$ ( i want to extract the date after the second '- ') Code I used:(code gives me error)CASE WHENMATCH_PROCESS_REGEX ( column, '.*- .{3,}/' )=1THEN TO_DATE(RTRIM(RIGHT(STRING_SPLIT (column, '- ' , 0),11)),FORMAT ( '%d/%m/%Y'))ELSE NULLEND Thanks In Advance

Hi, I'm unable to upload dataset in in the tool, ERROR- Remote application on http://integration/integration/api/internal/data-pools/data-models/655b7a20-e1d7-4c50-b4d6-328a000bb992/load-info-sync[GET] responded wi

In the given data tables below -  I used the statement - 'PU_SUM ( DOMAIN_TABLE ( “Chapters”.” Title”, “Book_Author_Mapping”.” Book ID” ), “Chapters”.” Number of Pages” )' Here I have a couple of questions in understanding the functionality:- If the Domain Table is formed based on the specified column/tables - To which Specified Table will the Damon Table be linked to? - as both the tables 'Chapters and Book_Author_Mapping' have an N:1 relationship with other tables?Will the Domain table link to the 'specified tables - Chapters; Book_Author_Mapping' based on the Table we mention in the SourceTable?Column field of PU_X Functions -i.e. “Chapters”.” Number of Pages” in this case ?'  Thanks in Advance. Kind regardsAbhinav

How many cases are covered by the five most common variants.

Help needed with a % connection path KPI I am trying to figure out how i can make a connection KPI which shows the path percentage of cases that passed through. now i want to see the path percentage flow from each individual Activity. exmaple: Start -->Activity A (branches pathways) ---55% for a path---> Activity B (branches Pathways) --23% for a path--> activity Z. so from each Acitivy i want to calculate how much of the (total) cases that landed there go a certain path % wise. Now i figured out by doing: COUNT (DISTINCT SOURCE ("Table"."colum")) / GLOBAL(COUNT (DISTINCT SOURCE ("Table"."colum"))) I can filter the path connections to % based on the Total amount of cases present in the dataset. This only shows me how cases % wise flow through the whole process. but not from an indivual activity.  In my mind somehow every Activity point needs to be seen as the "new" total 100% so a calculation can be made for the paths. but i

i want change the dimension of olap table using dropdown in views, How to display name like display name in dropdown in views

Hi! can anyone please help me figure out the following PQL? I have cases that have a lot of the same activity.  Imagine the activity is "Walk The Dog" and there are activities with the following dates: 1/1/20231/8/20231/15/20231/25/2023 I would like a query that returns the largest number of days between consecutive events  So in this example: 1/1/2023->1/8/2023 = 7 days1/8/2023->1/15/2023 = 7 days1/15/2023-1/25/2023 = 10 days I would like the query to return '10'  I am having trouble with trying to connect the dots with the documentation on calc throughput. Not sure how to approach it. 

Detail:in our data model, the event time must with format YYYY-MM-DD HH:MI:SS. But my data source is DD-MM-YYYY HH:MI:SS. so this data is not available as event time. I tried to follow : https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Formatting/TemplatePatternsForDateTimeFormatting.htm use query : TO_TIMESTAMP(Date_column, 'YYYY-MM-DD HH:MI:SS'); (attachment 5) but the date format is not correct as below: 0028-01-20 00:00:00 (Attachment 3) The original date is 28-01-2022 13:51:24 (as attachment 4) 

Can Pull-up functions also be used in the context of transformations on Data integration side or is the usage only possible in Celonis Studio components etc.?

Hi All, I am trying to take my activity table and break it out into different subactivtiies groupings. Basically trying to create a counter calculation by case whenever the activity is 'Start' and have it copy all the way down until the next 'Start' activity or using a sort of lead object to distinguish the beginning of a sub activity. Example:Case Activitiy Counter1 Start 11 Activity 11 Activity 1 1 Activity 11 Start 21 Activity 22 Start 12 Activity 1 I have tried to do this with a variety of formulas, but have been unable to recreate this. I can do this in the backend transformation, but would prefer to see if it can be done within a calc from the front end. Please advise whenever you get a chance. Thanks for reading! 

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...

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]

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 :)