Product Q&A

Is it possible for an user to retrieve a signal that has been resolved? In other words getting the signal back in the signal list from the history section.  Use case: end users are completing signals, but if/when they mistakenly resolve the signal they would like to retrieve it back to the signal list.  Best,Selma

My data-model is loaded twice a week: currently a complete reload from source is done for all tables on Monday and Thursday.I would like to exclude one given table from the Monday reload, because this table is empty at this time, due to the process.I did not find any option to do that. Do you confirm?The Celonis version is 4.6 (on premise)Thank-you for your supportJulien

There are challenges in getting data again from customer.

Hi, the link "Please reload and link the data models as stated in this guide" leads to a protected google drive ressource and is therefore not available (I requested access with my gmail account, but nothing happened the last days)What needs to be done?Thanks in advance!

Hi all, First post here. Pleasure to meet you.  I just finished the Solution Professional Track and would like to start taking the exam soon, but one thing striked me as curious.  Except I have been missing it, VSQL was not included in the training except the "Best-Practice" module. That was like being thrown into the cold water, since I do not have a technical background. The Exam Prep mentiones SQL knowledge as prerequisite for the exam.  Since the academy does not seem to provide for a course, is there anyone who could tell me the depth which is needed to pass the exam and where I could learn that (i.e. youtube)?  Ideas would be appreciated. If someone is willing to do a personal exam prep and offers on fiverr or similar, feel free to shoot me a message. Best wishes  

Hi all,we are currently playing with Pycelonis in our CPM environment.The main use case will be the automatic export of OLAP tables already prefiltered with PQL Filters we are using in the Python Scripts.So far we managed to implement most of the PQL Filters we need.Now we want to extract data of a table that contains cycle times based on activities the users are able to select themselves within the analysis. So via dropdown that is wrinting the selected activity into a variable. With Python we now want to extract this table setting a specific activity into a variable before extracting the data, in order to get the correct cycle times. So far I haven't found a way to update/overwrite the variables current value with the activity name we want to use.The Pycelonis documentation is ok but in my opinion not giving so much information and examples than the basic stuff. Thank you very much in advance. BRDennis

Dear All, I would like to upload a JSON file in Event Collection which contains key:value pairs that are filled with dates. I have a "CancelDate" key, which sometimes contain null value (Date is not null here in the data if some conditions are met).E.g. [{"CancelDate":null},{"CancelDate":"2020-11-10"}]The datatype is set to DATETIME. After clicking the Finish button, i get the error code: „Processing Errorjava.lang.RuntimeException: java.lang.NullPointerException caused by null” .If i set CancelDate to DATE, i get: Data type conversion error for column "CancelDate", value "2020-11-10". Cause: Can not cast value "2020-11-10" to type DATE in column "CancelDate". I also tried DATETIME, as yyyy-MM-dd format, but the error code is the same. The only way i don't get an error code is if i set the datatype to STRING or if all the json objects keys contain values that are not null. Is there anything i can do so

After successfully loading a new Excel with "name mapping" on my data model, I don't know how to set up the "language key" in my studio views. What step am I skipping" Thanks for your help.

Hi, recently, we have been registered as a partner. Where can I download the on-prem agent for the data extraction of an on-prem system? best regards

Basically we would like to be able to track Skill Execution, is there a way to massively extract User Names and Timestamps of the Users running the skills? Thank you in advance! Best Regards,

I have a use case where I need to create separate views for different business functions using the core process data. Is there any way I can built an analysis just that for each view I am able to exclude certain activities (filter them out of the analysis

Using celonis for O2C mining of Oracle EBS system. In one of the view, I go to edit, select on component and then go to component options. For the units, I see it configured as <%=currency_symbol%>. Can you please let me know where I can find this parameter/variable defined. I find the value as Euro, where as it should be $

syntax[A]=1,syntax[B]=934patern1: syntax[A]/934=0.0010706638115631692patern2: 1/syntax[B]=0.0010706638115631692patern3: syntax[A]/syntax[B]=0.023554603854389723​Only patern3 will give different results...Please tell me the solution.

Affected rows: kickstart.messages-panel.more-than-100

Were can I found the latsted Step-by-Step guide for setting up Celonis on-Prem Agent?

This Action Flow's purpose is to produce a CSV file to be sent via e-mail to a few business users. I have already been able to filter out the records completely based on the condition I want, but instead of stopping the e-mail from being sent, it just delivers the business users a CSV file with 0 records. I have tried to do it with the filter I show in the images. The 'Variable Value' in Set Variable - 39 is exactly the same that is being used to filter out the records in the first stage (Query Data - 10 - which produces the records basically).  I have tried multiple approaches with this solution so I guess there should be another way around the problem I'm facing, which I don't know. Thank you

Good day, is anyone else struggling to access the Knowledge Model in Studio? I can not create a new Knowledge Model. My collegue has the same issue. If I try to create a new Knowledge Model and I click "Create", then the program is hanging.

Hello,I need a Help on a KPI about OTC . I want to calculate time by hours between,(Cases which goes through "Lead Status Set To: Open" and does not go throught "Lead Status Set To : Assigned".) and current time. Or can you say what is wrong with my code ? HOURS_BETWEEN ( CASE  WHEN MATCH_ACTIVITIES ( NODE [ 'Activity Status Set To: Open' ] ) and NOT MATCH_ACTIVITIES ( NODE [ 'Activity Status Set To: Assigned' ] ) THEN "ACTIVITIES"."EVENTTIME"  ELSE   -TODAY ( ) END , TODAY ( ))

Hi there, The Activity Selection filter has an option where we can filter cases that flow through all or any multiple activities.I want to select a bunch of activities and filter cases that flow through any of them. Since this filter is used frequently I created an OLAP table with one category per row.   I assumed that, selecting a row and inverting the selection would give the same result as activities flow not through ANY cases in the Activity Selection. However the results are not the same. In fact, inverting the selection does not change the total amount of cases.  So this raises some questions. What does the invert selection option do and where can I read about it?Can we get the same functionality as in the Activity Selection filter (multiple activities flowing through any ) in an OLAP table?I used a CASE WHEN statement to create the categories in the OLAP table. Is there another way of doing this?  CASE  WHEN "_CEL_O2C_ACTIVITIES"."ACTIV

Hi everyone, looking for advice from Celonis customers. How did you work with your internal IT team to grant permissions to allow Action Flow emails using a company email address? I've got a functional ID set up with a mailbox to manage security. My internal IT group is struggling to understand what to do. Appreciate how you navigated this with your IT group. Thanks!

Hello,I am preparing an automation sheet on studio and I need a KPI like, if a user type is not selected calculate ratio as activities done by "B,C,S" type user divided by all activitiesBut if a user type is selected calculate ratio as activities done by user which selected user type divided by AGAIN all activities. So, If I use simple dropdown it filters all activities and my numerator is also filtered with my denominator but I don't want this.furthermore, I tried to use dropdown button and write selection to a variable. So I could control KPI formula and I could calculate however I want but, I cant choose how to control if a user type is selected or not. I am trying to control is variable NULL or not. is My way wrong ? I can do it neither on code either nor visual editor. Here is a SS to explain myself. Any help will be appretiated.Best Regards. 

Formula : COUNT(DISTINCT CASE WHEN KPI(TAT) < <%=SLA%> THEN "PurchasingExample_Test_csv_CASES"."CASE ID" ELSE NULL END) Error : Syntax error near [THEN] after reading [ TABLE (COUNT(DISTINCT CASE WHEN KPI(TAT) < ] at line 1. Please refer to PQL documentation for available syntax.

Hi there, I have the supplier names (LFA1.NAME1) and the order value (EKPO.NETWR). I want to create the statistic, how many suppliers are relevant for 80% of the total order value. How is that possible. I tried to do that with ABC, but failed. TOP X suppliers do 80% of total order value TOP x% of the suppliers do 80% of total order value Would be really great to find a solution. Thx and br Daniel

Hi,We are trying to create a deep dive analysis for calculating throughput time. Is there a possibility to calculate TPT without Rework/Change activities? We tried to do it with the help of component filter where we attempted to use the NOT_IN operator in order to ignore rework activities. Is this the right way or does Celonis support any special PQL query for this. Suggestions, ideas would be highly appreciated

Hi, Currently I am using this formula: AVG(CALC_THROUGHPUT(CASE_START TO LAST_OCCURRENCE['<%= Activity %>'], REMAP_TIMESTAMPS("DATA_(7)_csv"."COMPLETION_DATE", DAYS))) This formula works well, however I would prefer if I could actually calculate the dates between two columns, rather than just from one column. Something like this: Start Date - Completion Date Example : Thanks,Terence