Data Ingestion & Infrastructure

Hi all,I would like to build a chart which shows the number of open activities at a given day.In our data activities are a combination of a task (e.g. modelling or testing), and a (lifecycle) status (e.g. new, in progress, done, rejected). I would like to plot per day the number of open tasks/activities of a certain type.I currently have the activity timestamp aggregated to day as DIMENSION, and the following KPI:MOVING_COUNT_DISTINCT(CASE WHENMATCH_ACTIVITIES(NODE[Testing - In progress] , EXCLUDING[Testing - Done, Testing - Rejected] ) = 1THEN L33_V_MBD_INZICHTEN_STATUS.FEATUREAPGIDELSE NULLEND,-999,0)In (my?) theory this should use the activities up until the day, and then determine whether the case contains an open testing task or not. However, my current result is incorrect:image1223594 18.2 KBWhich trick am I missing?BTW: were on CPM4.6Happy holidays!

Hi Team,Am trying to find out , country wise how many billing blocked customers and delivery blocked customers I think i did it, but how do i remove the zeros from the pivot table.image940425 14.6 KBIf i expand the country, i required only the KPIs Dimension. not the unwanted values (refer the below screen shot). Thanks in advance.image977439 28 KB

Does anyone have the link between the Plant Maintenance Orders PMOs tables to Purchase Order POs table EKPO?

HI, as a newbie to PQL, I am would need help in order to calculate the different in stock levels between two months. The current display shows the SUM of the stock, with a Component Filter the particular month. How could I calculate the difference between the starting stock (January) and the current stock level, by month? (there are multiple stock items)ThanksKenny7

Hi,i do have trouble implementing implenting a filter. I want the to give the business user the chance to filter for a value range.the column looks like:x001x002x003y001y002z001At the moment there is a button dopdown - but there is the need to look up a range, e.g. x050-x080 which are to many values to be selected manually.My idea was to let the user set the minimum and maximum value via input fields and use those values as a sheet filter but variables can not be used in sheet filters.Does someone have an idea?Best regards,Jan

Hi team,i have an activity table as follow:activity_table(Case ID, Category, Activity, Timestamp)A, Red, Activity 1, Jan 1 2020A, Red, Activity 2, Jan 2 2020A, Red, Activity 3, Jan 3 2020A, Blue, Activity 4, Jan 10 2020A, Blue, Activity 5, Jan 31 2020B, Red, Activity 1, Jan 5 2020B, Red, Activity 2, Jan 10 2020Is there a way that i can aggregate the average throughput time per category to get the following result:Red --> (3 + 5) / 2 = 4 daysBlue --> 21 daysBest,Dominic

Hi everyone,Im having some trouble finding out how to implement a throughput time KPI.How do i calculate, for example, the throughput time from the first occurence of an activity to the second occurence of another activity?The goal with this would be to compare activity changes and check which take the most time.Thanks a lot in advance!Joo

Hi, we are using Celonis Version 4.5 on premise. Is there any chance to configure Database connections parameters at one singel Point? At the moment every project has its own definition. Because our Database user password has to be changed frequently this is quite unhandy. kind regards Benedikt

Handle uncommon JSON formats in Extraction Builder Hi all,  We are working with the Extraction Builder, but unfortunately the API we are using returns slightly adjusted JSON-formats. Format 1 is Newline delimited JSON (application/x-ndjson), where entries are delimited with a newline (\\n) character.Format 2 is a multipart results, with a combination of plain-text and JSON, see example below Is there a way to handle such results in Celonis, without creating parser using Python in the Machine Learning Workbench?Thanks in advance! Jan-peter ----Multipart response example:`--Boundary_1141620_1164068888_1623858255903Content-Encoding: identitydl_compression_type: deflateddl_document_date: 2021-02-11T15: 13: 52.988Zdl_corrupt: falsedl_size: 1024dl_encoding: UTF-8dl_document_data_type: JSON {  &qu

Hi All  We have created a custom REST API to pull data into Celonis. This is working well for full data extractions. How do we create and use a variable within the API rest query to enable delta extract? ie. We want a way to replace the text in {{}} with the last date within the datamodel: http://xxx.service-now.com/api/now/table/sys_audit?sysparm_display_value=true&sysparm_query=tablename=interaction^sys_created_on>javascript:gs.dateGenerate({{MAX DATE FROM MODEL}}','00:00:00')^ORDERBYsys_created_on&sysparm_offset=0&sysparm_limit=1000 thanksDavid

connecting uipath using API Key

Imprementation TrackProcess Connection Basics  Exercise: Extract Data - Create Extraction TRAINING.EKKO Suggested solution: EKKO.AEDAT >= '01.06.2014’ Configure columns: AEDAT == STRING Extraction Preview: AEDAT(1) ==  2016-05-02 00:00:00.0 Doesn’t work:1.     EKKO.AEDAT >= '01.06.2014’2.    EKKO.AEDAT >= '2014-06-01 00:00'3.    EKKO.AEDAT >= '2014-06-01 00:00:00.0' Filter contains a data type mismatch. Column "AEDAT" has data type: " DATETIME". You supplied an value of type: "STRING". Please adjust your value. 4.    AEDAT >= DATETIME('2014-06-01 00:00:00.0') Error parsing filter: AEDAT >= DATETIME('2014-06-01 00:00:

Hello, Celonis community and team, this is our first C4C project. We have provided the client with a Celonis ABAP-Skript and used the SAP ABAP Output Uploader. In the third stage Processing, some of the 86 SAP tables could not be processed. The following issues arise for the respective tables: EINA: Convert to parquet failed. The following chunks could not be processed: EINA_1_20201203_155035.csv, EINA_1_20201203_154720.csv, EINA_0_20201203_155035.csv, EINA_0_20201203_154720.csv EINE: Convert to parquet failed. The following chunks could not be processed: EINE_1_20201203_155048.csv, EINE_0_20201203_154734.csv, EINE_0_20201203_155048.csv MARC: Convert to parquet failed. The following chunk could not be processed: MARC_2_20201204_080156.csv MSEG: Convert to parquet failed. The following chunk could not be processed: MSEG_93_20201204_102543.csv T023UT: Job failed T16FE: Job failed What could be the reasons for these issues? The tables incurring the error Convert to parquet failed. The fol

Hey,I want to access some system parameters like logged in users language and last successful dataload. Is there any possibility to do that?Kind regardsAlex

Hello, I am trying to use the demo P2P data as a pandas dataframe throught the ML Workbench. Following the documentation : from pycelonis import get_celonis login = { celonis_url : url api_token : token } celonis = get_celonis(**login) out pycelonis: Login successful! Hello vasilis <pycelonis.api.IBC at 0x7f6cb9719340> celonis.workspaces out <Workspace, id 0036fb70-61e7-4e8e-92d3-4aeac9d563bd, name Purchase To Pay Demo Analysis> Then when i try to find the analysis i get " No result found for id : xxx" analysis = celonis.analyses.find(0036fb70-61e7-4e8e-92d3-4aeac9d563bd) Any hints how to get the OLAP table of the P2P demo data to a pandas dataframe?

Dear all, Is there any way to migrate a data model from Celonis 4 to IBC using pycelonis? Otherwise is there any method to convert a data model object to data frame to use the function push_table? Thank you in advance

Hi all, I have a big problem. I have several CSV/xlsx-filles uploaded as tables to my data model. When I try to delete one table (e.g. in data model under Tables) I click in Edit and then Remove table. After done that the table is gone, but ca. 10-12 seconds later the table comes back, magic. If I click it several times, sometimes the table is gone then. At the buttom of the Tables list there are then created several new tables like that Auswahl_Delta.xlsx_0_0_0_2_0_1_0_0_0_0_0_2 What can I do to solve that? What is going wrong? Please help me. Thx and br Daniel

In our company we use Unit4 Business World for our transactional services (OtC, RtR, PtP). Is there any experience within the community with connecting real time to the Unit4 Business World database?

We want to make a connection to a Mendix platform which is hosted in the Mendix on AWS from our EMS. The Mendex documentation shows that the following endpoints are possible: Soap Rest Odata Is there anybody who has done this already?

Hi, Everyone. Is there any way to give access to some users just for Team Settings and Configuration purposes? At my company the IT teams are responsible for making applications work but dont have access to the information in them. In fact different teams are responsible for different tasks like user configuration, permission configuration or server configuration. So, what would be nice was some kind of CONFIGURATION role where I, as ADMIN, could decide which users can do what, under the Team Settings menus (could be different permissions for each submenu), but nothing else. Thank you. Joaquim

Hi Task Mining Experts,  Question :During Testing Task Mining on Sandbox, I have added few users and facing data limitation. It is related to table rows count and the standard issue. Error Message :Data model load failed during table export: Data model tables: user_interaction_event_log contain more rows than the allowed maximum per table of 10000. Please reduce the number of rows. Any inputs to increase the rows count more than 10000 ? RegardsVivek M

Task Mining members, I am facing 2 issues for the past couple of days, would be helpful if you can suggest a solution. 1) While trying to create a quickstart project with template, after entering the name of task mining project, I get error that "Project cannot be created because it fails to connect servers" and I had been trying this for couple of days now facing the same issue. 2) Another issue is, I tried to create a project with blank template and completed tasks capture and screenshots caputre using task mining client, and it shows upload successful. But when I go to data model, it shows no data uploaded and then when I try to do force upload from cache or complete force upload, it gives errorMessage :Data model load failed during table export: Data model tables could not be exported: user_interaction_event_log It will be a great help if someone can provide a resolution to this issues.

Hi, Task mining experts I have tried to create a Task Mining project, and I had several issues:-"New Project with template" it is not working: see attached screenshot-When I create a "New Blank Project", after following the instructions to download and setup the "Task Mining client" using the "Configuration" utility, everything seems to be ok, but the client seems to fail when uploadind data to the server, because I can't see no data non analysis its automatically created. I have checked in my PC that the screenshots and parquet file are created. I have even checked using different PCs as clients, as you can see in the attached "Users and Invite" screenshot. The client without errors seems not to be able to upload data...and even worse, Im not able to see the errors reported by the other client "oscar.vinan".-The celonis snap server seems not to detect the chrome plugin I have installe

Is there any system tables in Celonis we can check, for example, in Oracle, we have all_objects, user_tables such kind of tables we can have an overview understanding for one DB

Hello, Is anyone able to share insight into what a ServiceNow Change Management Data Model might look like, i.e. which standard tables are involved and perhaps an example of the associated activity table? What is your experience with using the ServiceNow Change Management Connector and Apps? Appreciate any information or tips, Regards, James