Product Q&A

​

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

Error in the Default Pipeline Script for assembling & pushing tables to front-end. Has anyone run into an error when running the default pipeline ML script where you get: "Could not execute foreign key join: There are duplicates on both sides of the specified key relationship. Table: Tm_Activities; Key("CaseID")"?  Not sure why this arose out of nowhere.

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.

I was able to find a p2p best practices for SAP in the partner asset library. We are interested in building the activity table for P2P on oracle cloud. I wanted to get a sense of what tables and columns are need for various activities such as Create Req, Modify PO etc along the P2P process. Any help is greatly appreciated.

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?

First, we have created O2C process and added tables that are required for AR process. The extraction part is done, but we have stuck in the data model. The connection between vbap and vbfa may be failing. 

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.​

"EventLog_ACME_TeachingCase_csv"."TIMESTAMP" --> this gives me all the timestamps"EventLog_ACME_TeachingCase_csv"."TIMESTAMP" LIKE {t '00:00:00'} --> things like this do not work Thanks a lot! Greetings, Ronja 

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 ?

Studio Views are very powerful with data and actions but, by default, they are not aesthetically appealing like Process Analitycs. For example I dont find this functions: change colors or backgroud colors (and transparency).change borders and borders type.use KPI dedicated components like Gauge tool menu to guide inside big applicationsIntegration with third parts javascripts components....and so onIs there a way to do this things?Thank for every suggestion.