Product Q&A

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

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

We are doing a project for migrating data transformations from On-Prem to EMS.SAP HANA is used for On-Prem transformations. We have a blocker where a function -> DATS_IS_VALID() is used in the transformations in On-Prem.The purpose of this function is to check if a particular date value (in the format YYYYMMDD) is valid or invalid.For example: 20211130 is valid (Nov 30 2021) whereas 20211131 is invalid (coz November doesn’t have 31 days) Now there is no direct syntax in Vertica to perform this operation as per our research.Since we have many transformations using this check, we would need your help in finding out a better way to solve this problem. Our conditions are mostly like, if the date is valid then take that specific date field and if the date is invalid then treat it as NULL.Invalid dates are present in Production data as well as there are some manual invoicing being done hence we cannot remove or ignore this check.

Does Celonis have any documentation of the algorithms they use in the process discovery and conformance checking? I need to have references for the master thesis

​

Hello everyone,I am asking for support here for an application that I would like to do.I have a CASE TABLE in which calls to a call center are recorded. Each line represents a received call.The goal is to count the Recallers, i.e. those numbers that call several times in the period considered, and their frequency.In other words, I would like to see how many people call twice, thrice, four times, etc.I made a drawing to make better understood in which I recorded 9 calls made from 4 different numbers: I want to put them in a table or graph that shows me that there are 2 numbers that called 2 times, one number that called 4 times and a number only once. (I don't care about the phone number, I put up numbers just to show what I have available and what I want). Could anyone help me set up a component with PQL? Thanks  

Hi there,i'm farely new to Celonis and struggeling with some basics.I'm trying so get the time between events (not only directly followed).For example: i have events A, B, C, D, Etime between B and C should be less 1hgoal: get all cases to which this appliesI really tried to figure it out, even with OLAP tables, but i think for something this basic there has to be another way. Thanks in advance, looking forward to your answers.Steph

Currently the IT landscape is based on Legacys no ERP or Market solution.  This company decided years ago to develop all their technology and now are facing obsolescence and process issues and difficult to improve as there is no documentation, etc. The discovery process for an improvement project takes a lot of time and we want to improve the discovery process.  

Good afternoon, I would like to test process simulation capabilities. Could you please let me know how to start with it with a partner account? Best, Dmytro

Hello,  I'm trying to optimize very long-running queries (few hours):We want to change user type for all activities done in span of 10 seconds (so for specific activity if there's any other activity done in 5 seconds before or 5 seconds after by same user and with same activity name the user type should be adjusted). I've marked red a rows that won't be updated due to failing match (Different user_name, activity_name or exceeded time span).  Do you have any ideas? Right now I've got 2 queries:A) Alter table - add integer columnB) First assign row numbers by just updatingC) Make selfjoin based on row numbering with just update I know it could be easly done with LAG/LEAD analytical Vertica 10.0.x functions, however these are not supported. Only other idea is to not assign row numbers but to use identity and try also to use MERGE.  help would be highly appreciated Best Regards,Mateusz Dudek

Is there a possibility to copy Variables defined in one analysis into another. Celonis 4.5 Version. Regards Naveen Gupta

Hi, I am currently trying to calculate the averages days from process start to the end of a specific activity using the following code:AVG(CALC_THROUGHPUT(CASE_START TO LAST_OCCURRENCE['Confirm Order'], REMAP_TIMESTAMPS("DATA_csv"."START_DATE", DAYS))) However, I now want to be able to configure the above code so that the KPI filters based on any activity I select but NOT take into account process end. The problem I'm having right now is that it instead calculates the time difference between start and end of process whenever I pick any activity. Thanks,Terence

Hi,can anybody help me understanding how the activity Invoice Due Date Passed is defined?I have a few cases, where this occures more than one time in the process and I wonder how this is possible.image1036535 32.9 KBThank you for your help!Best,Carina

Hi, I am currently preparing an order management demo and wondered how to include a client logo in the demo. Could anyone help out? Thanks. 

is CURRENCY_CONVERT_SAP function need TCURF , TCURX table in datamodel ? or without any reference (currency) table can we use this function? .

and i want only month part should be extracted from the column that i have and there are various year in the same column, but i want to make their chart according to their months