Product Q&A

Hello, in the ML workbench, as the R language is available, is there a way to push and pull data from a data model using R kernel? Or is it possible only in Python using the pycelonis package?

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 All, In celonis transformation I would like to use Dynamic parameter to store the select query output and the same parameter i need to use in upcoming queries for further processing.  Could you please help me with option for the same? Thanks in Advance.

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

Hey there! is it possible to extract the saved variable values in a specific analysis using pycelonis/ML workbench? Any insights on this is appreciated. Thanks in advance!

When sending an email using "Email By Celonis" using a Smart Sensor in Studio, how does one create/specify/add an attachment to the email? Can it be an external document or only information that is stored in the knowledge model? Thank you.

As a Business View user I would like to re-arrange columns in a table and show/hide columns and save these configurations as a favorite or pre-set so that I can always return to my customized view

Hi Team , I am trying to connect with Oracle Database from Celonis ML using cx_Oracle python Package but getting error as : cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: libclntsh.so: cannot open shared object file: No such file or directory. See https://oracle.github.io/odpi/doc/installation.html for help . Any help or information about this would be highly appreciated . Thank You, Amruth Muddana

Hi,I was trying to set a schedule for my action flow, but on the time icon scheduling mode option, I only have this option: According to scheduling. And I cant find where that scheduling is. Is there a new way to schedule action flows?

Does anyone has sample Event log for the beginner to analyze it in Snap ? If so please share. Thanks in advance for your help.

Creating a drop-down field that will change the dimension of the first column in a table. E.g. I want to be able to switch between dimensions like, country, regions, Vendors, etc.To display in a chart the top 5 values (like Top 5 Vendors) with the possiblity to scroll beyond the top 5 (adding a scrolling functionality).  Normally it’s quite straight forward but within Views I can´t find the solution.  Many thanks and best regards, Manuel

I have setup a ML Duplicate Checker model that runs daily, it is connected to the Action Engine and generated a Dashboard Report as well. Whenever there are new duplicates I receive signals alerts and the information gets pushed to the Dashboard report as well. How can I include the signals creation date to the reporting Dashboard in Studio?

Is it possible to color code the unwanted connection?

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

I have two CSV files with the same headers. The only difference between the files is that it contains data from two different dates. For example one csv file has data for today's sales. The other CSV file has yesterday's sales. In Celonis I have already uploaded the CSV for yesterday's sales. How do I now upload and combine the CSV for today's sales, into the data for yesterday's sales which is already in Celonis.

We would like to send alerts / reports via mail. Currently these mails are sent by Celonis . We would like to change that to use a generic company mail id. How can this be achieved.

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", ... ...}`

Dear Team, similar to what someone has previously posted I am also following the ML Training and am receiving an exception saying that I am either missing the correct permissions to query the datamodel or that I havent loaded them correctly. Neither seems to be true, because I set all permissions as required and I cross-checked that the datamodels have been successfully loaded. Could you kindly help me out on this one, please? ! Screenshot is attached, my training environment is: Process Data Models | Event Collection (celonis.cloud) Exception|690x359

Using the SAP ABAP Output Uploader:  Have the header files as .csv, and data files as .csv.gz The processing portion 'converting input files to parquet' is stuck processing for hours & has not yet been able to get through this step. I have tried uploading separately to see if size of data is the issue, but processing for a table with 1 singular data file attached is having the same issue.  Please advise. Currently unable to create a case in celopeers...   

Is there any webinar / knowledge base article on how to run the S/4HANA migration with Celonis? Also, any recording of past S/4HANA Lunch & Learn sessions? cc @Janine Guertler​ 

Hi , I'm trying to build a KPI that checks the date fields which have the correct date format or not. In my case I want to check if the date is in format mm-dd-yyyy. I tried with below PQL code but it is not working, could you please help me on this? I have loaded the file and assigned DATE IN column as STRING.  IN PQL code, I have converted the DATE IN column to date format with (m-d-y) but it is not working :( CASE WHEN ISNULL ( TO_DATE ( "DATE_xlsx_Sheet1"."DATE IN" , FORMAT ('%m-%d-%Y'))) = 1 THEN 'INCORRECT'ELSE 'CORRECT'END     

The pricing model for C4C+ Execution is Business Users and Analysts. For customer "Analysts" what access is provided? Are they able to maintain the system or does that require another level of access? If another level of access is needed, is there a pricing category for this in C4C+ Execution?

We have a ServiceNow analysis and the business would like to know how long tickets are spending in a series of states. We are trying to analyse if we are putting calls on hold for too long. We are looking to do two things. For any set of tickets give me the total time this ticket has spent in a particular activity. So the event time of this activity until the next activity. The ticket may be in this state more than once through it's process journey. There are more than one of these states. Report on any tickets that have exceeded a specific threshold of time in one of these states. So the flow might go Ticket Created - Time 1Ticket On Hold - Time 2Ticket Active - Time 3Ticket On Hold - Time 4Ticket Active - Time 5Ticket Resolved - Time 6 I'm looking for the total time between Time 2 & Time 3 added to the time between Time 4 and Time 5. I cannot see a way to do this. Any ideas greatly appreciated.  

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