Solved

Hi Community,I have a question : I'd like to use LIKE operator in CALC_THROUGHPUT function like this.​---FILTER (CALC_THROUGHPUT(LAST_OCCURRENCE[LIKE 'A_%']TO FIRST_OCCURRENCE[LIKE 'B_%'],REMAP_TIMESTAMPS("TABLE"."TIME_STAMP", DAYS))) <= 7 /* only within 7 days duration.*/​---but this doesn't work and I found the page* that is similar to my question.​This page is helpful, but in my case, the first half of the first argument(LAST_OCCURRENCE[LIKE 'A_%']) requires LIKE operator as well. ​Please let me know if you have any ideas.Thanks.​*Reference : https://www.celopeers.com/s/question/0D50700000GC6lJCAT/using-ldquolikerdquo-in-process-functions-as-calcthroughput?t=1645409602164

Hi all! Anybody knows or have information if there is a connector for a3ERP?

I want to create an alert which sends e-mail to a group of recipients when the Data Load is successful. Is it possible to trigger an alert directly from Celonis? I can subscribe to a data pool to get alerts on reload failure but not when It is successful. In addition Is it possible to get the Log history of the reloads for analysis?

I want download 2022-01-13-JDBC_Extractor_Package.zip to verify connection with onpremised system. I tried download this URL, but I get only downlaod.html.https://academic-*****.eu-2.celonis.cloud/help/display/CIBC/Downloads+and+Version+HistoryHow can I get JDBC_Extractor_Package.zip?

Hi everyone, I need to use load script filter for some pages in which the process has to be flow to this step 'Deputation letter generated'. I had tried,  FILTER PROCESS EQUALS '<%=activity_name%>'FILTER ISNULL(PU_LAST("Table_name",ROUND_DAY("Activity_Table"."EVENT_TIME"),"Activity_Table"."ACTIVITY"='Deputation Letter Generated')) = 0; But it is not working. Kindly help me to solve this please

Hey,I want to measure the lead time between two activities, but which must contain a certain (variable) attribute. I tried this with the function "BIND_FILTERS" but fail. Does anyone have a solution for something like this? MEDIAN (  CALC_THROUGHPUT (    FIRST_OCCURRENCE [ '<%= Step_1 %>' ]    TO    FIRST_OCCURRENCE [ '<%= Step_2 %>' ] ,    REMAP_TIMESTAMPS ( "_CEL_SCHUTZBRIEF_ACTIVITIES"."EVENTTIME" , MINUTES )  ),  BIND_FILTERS ( "_CEL_cc_claim","ANS_KNZ_Mapping_csv"."ANS" = '<%= ANS_01 %>' ))

Hi all, We are looking for a way to automatically obtain data from teams regarding the number of active users and APC used. Via PyCelonis would be ideally, but unfortunately we didn't find it implemented. Has somebody any idea how to do this?  Kind regards,Jan-peter

Hi, we are working with a MySQL database as a source of our process data. After analyzing the process we have added projects to the action engine. Now we like to write back data into the MySQL database by executing UPDATE/CREATE (e.g. to set blocks or discounts for upcoming processes for a customer which are stored in a specific database table). How can we do this? We just found SAP HANA as a database to post SQL statements but not MySQL. Best,Clemens

Hi peers,  I am wondering if it is possible to schedule the automated load of Data Model, not Data Job.I understand we have Scheduling in advanced setting and Rest API for Data Job, but not for Data Model.Reference indicates that the LiveReload from Analysis side is not the trigger of Data Model change.Does anyone have any idea to automate whole process of Data Job => Data Model => Analysis? Thanks.

Hi all, I am wondering if I could give default value in the component Throughput Time Search other than using Filter. Do you have any idea to set following criteria e.g. as below so that the analyst confirm the crop selection is applied to this component?

I have one saved formula that I want to apply to data from different tables. the data within the tables is different but the underlying logic and structure is the same. Therefore I would like to know if and how I can use parameters to replace a part or the complete table name with parameters.  I tried already to use a text parameter {p1} with the name STREAM, but received syntax errors. Can someone help out on this matter? I couldn't find anything about this in the official documentation.  Thanks in advance!

Hi there, wasn't there an option to export transformation scripts or am I in the wrong location? Thanks,Saša    

Good afternoon everyone, We've been looking at our Delta Loads and Full Loads runtimes to try and optimize our Data Consumption and we've noticed that the Delta Loads always take more time than the Full Loads. Is there a reason for this? Is there something we can do to have them be faster? In the below Image you can see some examples of /COCKPIT/THDRV and CDPOS tables which are quite large  Please advise Thank you in advance for your support

Hi there, I am getting a run time error creating a table and I am wondering if this concerns only the editor or also a scheduled transformation job?  Kind regards,Sasa  

Hi All, may I know is it possible to get the data set used in the Procurement TryCelonis Demo? That will be really helpful when we let our users to know what exactly they may need to provide in order to perform process mining. Thank you!

Hello, We are currently in the midst of migrating all our Analyses and Action Engines to Studio. Celonis provided with a functionality to seamlessly migrate the analyses to Studio. Is there an easy way to migrate Action Engine Skills to Skills within Studio?  Thanks

Hi all, I try to add a data service link to a OneDrive folder automatically searching for the PO number. SO I've did the following:Created normal variable "PO": "EKPO"."EBELN"Added data service link to an OLAP table with: OneDrive Link...414D1&view=7&q=<=%PO%> (so added the variable add the end to search for that problem: Opens OneDrice and searches for "EKPO"."EBELN" as text but not the Purchase Order number When I use a static variable then it is searching for a Purchase Order number, but not the right one, it is a static one. How is it possible to search for the Purchase Order number for that line in the OLAP table? Thx and brDaniel 

This question is being asked because it is one of the requirements in a university medical center RFP for Celonis-like services. Thanks! 

Genesys Bold 360 is the Service Now chatbot

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

I have an activity (Claim Denial,) here I'm trying get the count of activities got paid after the Claim Denial,. payment happened before Denial and after denial as well, but I need to consider the first payment made after the Denial,  it can be many payment as well and payment activities we have 5 different type. also payment span should be >= 60. days between(First Denial date , first payment date(after the denial)>=60payment A- 01/01/2021Denial- 02/01/2021Payment B-03/01/2021 PU_FIRST works for First Denial but for Payment if we use PU_FIRST it will look for the Payment A but it should take Payment B date

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!

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 there,I am getting this strange behaviour and was wondering if somebody can explain this?I want to create an activity for when NETPR in CDPOS changed to 0 but when I look for 0s the table is empty. Query 1: My first entry happens to be a case that I am looking for.    SELECT DISTINCT FNAME,VALUE_NEW from CDPOS    WHERE FNAME = 'NETPR'   ORDER BY VALUE_NEW   LIMIT 1    FNAME  VALUE_NEW   NETPR  0.00 Query 2: But I get an empty table when I use these conditions.     SELECT DISTINCT FNAME,VALUE_NEW    FROM CDPOS    WHERE FNAME = 'NETPR' AND VALUE_NEW = '0.00'    FNAME  VALUE_NEW   - Next I wanted to see if my VALUE_NEW = '0.00' might be wrong somehow.    Why do I get different smallest values '0.000' and '0.00' from query 3 and query 4 respectively? Query 3   SELECT DISTINCT VALUE_NEW from CDPOS   ORDER BY VALUE_NEW     VALUE_NEW    0.000    1.000 Query 4   SELECT DISTINCT FNAME, VALUE_NEW   FROM CDPOS   WHERE FNAME = 'NETPR'  ORD

Hello All, Is there any way to get the sum of the Throughput time other than what is there. For example want to group by with some activities, the throughput only available for the avg, median and mean. If we can get the sum of the same.