General Product Q&A

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,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

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, 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

The initial idea was to view some Celonis Pages (Process analysis or analysis form Studio) from another tool which is hosted in AWS. Embedding of the Celonis page on that tool. But when we are sharing the link (not the public link) getting the below error message.<<IBC Cloud >> refused to connect. The issue with the public link is when enabling the celonis public link anyone can open the analysis with high confidential data to everyone, although in non editable mode but cases with confidential data will be visible

Oracle Fusion O2C Cycle:We are not able to find the Pick Confirm Table.  Order to Cash Flow:1.Create Sales Order Header2. Create Pick Wave3. Print Pick Slip Report4. Confirm Pick Slips --->( Not able to find the Table for the Confirm Pick Slips)5. Ship Confimed  Please Help on which table we can find this link.

Is there only Cloud solution is available or is there any software as well ? And if it can be installed , can we install it on virtual desktop for process mining ?

How to get activation code for Training team access?

Hi,  I am a student using a academic licence and tried to use the Celonis Push API to upload a csv file into a data pool.  When using the Python sample from the documentation HTTP 403 - Permission denied occurred when I made a request.  Before I will further debug my code I want to know whether I can use the API at all. Thanks 😀

Hi,I am facing some problems with the Demo Sandbox. It says that all the data models are unavailable for some reason. I tried to reload them, but when I go to the workspace, it still says that they are not available.

What it means exactly with 'Execution Apps' and 'Execution Instruments'? Is there a clear definition? Thanks.​

I have a delta load schedule applied for every hour and every day and I have implemented a action engine skill with Machine learning bench for Duplicate checker on some source tables . But for the 28th Jan , I have some records but they haven't ran on 28th delta load schedule as well as on 29th . But they ran on 30th delta load and a signal is created on 30th . Now I need help on why that 28th data haven't loaded on 28th and 29th but on 30th ?

Do we have any Cloud extractor to connect to SAP HANA neo cloud database?