Data Ingestion & Infrastructure

Dear All, Im new to the community, so sorry in advance if the question is obvious or not relevant. looking for a tool/feature embedded or not to ease configuration transport from sandbox to productive environment, in order to avoid to break the last operational config in production. regards Maxime

Fellow Celonauts, Im curious if the Celonis IBC has the same authorization object capabilities as on-prem version 4.5. Ive been scouring the documentation and team settings in Celonis snap, but I dont see any mention of authorization objects or a place to configure the authorization key queries. We have recently undertaken a substantial project to align our on-prem instance of Celonis with our global reporting and analytics security standards using table-based authorization. Were looking to upgrade to the IBC in the next year, but if we cannot migrate the current table-based authorization setup to the IBC this could be a major problem for us. Thanks for any insight! -Tyler

Hi Team, Is there any way we can extract the data model load status logs from Celonis. Could see some configurations to extract ACCESS_LOGGING and LOGIN_LOGGING from Celonis logs. Looking for similar configuration set up steps to pull the data model load status logs from Celonis Application. Any help on this is highly appreciated. Thanks, Aashik

Hello Cummunity , Using Python , how i can replace the existing usernames with the new username ? Refering to [1.0.0 / User Management & Permissions] on help celonis de , i extracted Old User Details , and i I already have pandas data frame with Old_User ID , New_User ID , Old_Username ,Old_First Name ,Old_Last Name ,Old_Email , Old User Group , how I can use this dataframe and simply replace old user id with new user id keeping everything else same using Python. How can i do that ?

Hi, we need to monitor the last Login-Time per user. Target is to identify Users which hadnt used their account for more than 3 month to disable the accounts. We use our Celonis 4.5 SP2 System based on a Postgres DB but we cant find any metadata about last login. Does anybody know how we could implement that? Thanks for any advice! Benedikt

Dear Community, I want to configure authorization objects for user groups. There is a function for each user - Manage authorizations. image.png1011743 33.1 KB There is no such function for groups. image.png1049727 36.6 KB Could you please tell me how to set up authorization for user groups? Thank you a lot

Hello Celonis Team, is it possible to change the time zone in Celonis ? Thanks in advance, Harun

Hi community users and admins, I have a new mail address, but cannot find where to change that in my profile settings. Can somebody help me out? Thank you in advantage! Best, Jan-peter

I want know about SAML JIT configuration . Is there is any document available for the same.

Error Message states "Syntax error near [FILTER] after reading [] at line 2. Please refer to PQL documentation for available syntax. According to my understanding of the documentation, this should work. Thanks in advance.

Hi Celopeers! I am trying to calculate the next activity of a specific type, ignorin all the activities between them. I have tried to filter by those specific activities and then calculate ACTIVITY_LEAD, by it seems that the filter is not working properly for this KPI.   As an example, imagine that the activities what I am talking about are 'A', 'B' and 'C'. But also I have in my process activities '1', '2','3' AND '4'. One casuistic is the following one:   A >> 2 >> 3 >> C >> 4 >> B   The metric I want to calculate is the next activity of the type A,B or C. If I filter the table only by those activities, and include the formula ACTIVITY_LEAD with this filter activated, it still returns me      What I want to have is:    Thank you so much!!

Hi all, Im prepping some data in Python (pandas data frames) where certain columns dont have a value for each row, e.g. are NULL or NaN for integers and floats. However, when writing the dataframe as Excel file and then loading this into Celonis CPM46 I get the error as below. When writing as CSV I do not get this error on the same data, but the files are far larger and therefore take longer to upload (working from home ) Any idea or tips how to handle this? image865226 13.2 KB

Is there a way to combine conditions across tables in a PQL query or is it required to join tables beforehand in order to be used in a PQL query?   Here is an Examples: I want to go from this: CASEWHEN ISNULL("LIKP"."ZZTERMIN_DATE")=1 AND ISNULL("LIKP"."ZZFRTER")=1 THEN 'Ohne Termine (Ohne frühster & Ohne Fixtermin' WHEN ISNULL("LIKP"."ZZTERMIN_DATE")=0 AND ISNULL("LIKP"."ZZFRTER")=0 THEN 'Mit beiden (Mit frühstem & Fixtermin)'  WHEN ISNULL("LIKP"."ZZTERMIN_DATE")=1 AND ISNULL("LIKP"."ZZFRTER")=0 THEN 'Nur mit frühstem Termin (ohne Fixtermin)' WHEN ISNULL("LIKP"."ZZTERMIN_DATE")=0 AND ISNULL("LIKP"."ZZFRTER")=1 THEN 'Nur mit Fixtermin (ohne frühster Termin)' END  To this:CASE WHEN "LIPS.LFIMG" <> '0' AND ISNULL("LIKP"."ZZTERMIN_DATE")=1 AND ISNUL

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 {  "compnr": 8010,  "orderno": "XX0000024",  "buspart": "P00000001", ... ...}`

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:00.0') caused by: Encountered " <LIST_STRING> "(\\'2014-06-01 00:00:00.0\\') "" at line 1, column 18. Was expecting one of: <EOF> "AND" ... "OR" ... 5 .  AEDAT >= DATE('201