Product Q&A

Hi all, Our use case: We would like to allow our end-users of the Celonis analyses to test hypotheses themselves (does attribute X correlate with KPI y?). Question: As we are currently still on-premise we are investigating connecting Celonis to an R-Server to enable the RCALL function. This would allows us to dynamically build the data set to pass to R and then present the result in a user-friendly way. However, as we might move to the IBC in the (near or far) future, we wondering if such analysis <-> ML interaction is also possible with the ML Workbench. Concretely, can we pass parameters from the analysis to a stored ML function/notebook which then returns the results to be presented in the analysis? An alternative would be to pre-calculate every possible combination of attribute (sets) and KPIs, which I guess is not handy. Looking forward to some inspiration! Cheers, Joos

Hey community Id like to create a cluster in form of a OLAP table in Celonis in which I can select the right process, but also those IDs that go wrong through the process. for example: I have problems with the coding Now something about the Process: My process looks like f.ex. Activity A Start>Activity B -->Activity C -->Activity D -->Activity E>Activity F END For our department activity C and activity E is important. The other activities can be neglected. The right process is when activity C comes first and activity E comes later, not the other way around. The wrong process is, when activity E comes first and activity C comes later, exactly the wrong way round,if activity E is completely missing, I think I need something like this, but it is not yet thought through to the end DISTINCT(CASE WHEN PROCESS EQUALS Activity C TO ANY TO Activity E --the order is still missing here THEN right process WHEN MATCH_ACTIVITIES(NODE[Activity C] EXCLUDING[Activity E]) OR PROCESS E

Hi everyone, currently in the Data Service Link for an OLAP-table you enter the column used for the hyperlink via a local variable <%=colX%> with X = the respective column number. Sadly this is messed up very fast if a user hides/unhides certain columns or changes the order via the small eye-icon of the table. From my point of view, it would make more sense to provide the name of the column as the local variable so the position of the column and if its hided/unhided doesnt matter any longer. Additionally at the moment the icon for the link is always after the entry of the first column, even though your local variable is in a different column. If the entry in the first column exceeds the width of the column, you are not able to click the icon for the hyperlink as it is cut as well. Thus the icon should not be related to the length of the entry in the column. Best regards, David

Hey there!Hope you are doing fine.I was wondering if it is possible to consider only weekdays in a normal throughput formula, or even right from the get go, in already built-in dashboards such as the follow one:image1269361 15.3 KBIs there already a pre-built formula for this problem?AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Consumption] TO LAST_OCCURRENCE[Purchase Order Release], REMAP_TIMESTAMPS(Consigned_EventLog_xlsx_Consigned_EventLog.TIMESTAMP, DAYS)))For example in this formula.Looking forward to hearing from you Best,Francisco

Hi All,I would like to create query-definitions.xml.sample file and upload to application server to get the values for authorization objects.Could someone provide an example file for query-definitions.xml.sample!Thank you.

We are using Celonis provided tool to transform the data files extracted from SAP ECC and upload into IBC cloud. Since this process is time consulting, we wanted this to be done by multiple people in our team. We are having issues in installing this tool in our client provided laptops. Everyone in our team is facing same issue. During installation we see error installing module names pyxlsb The error description shows "Maximum retries exceeded with url SSL Error - SSL Certificate Verify Failed During actual upload - we get error No module named Pyxlsb Did anyone else encountered this type of issue before? What do you think is probably solution? Thanks, Vilas Kulkarni NTT Data, McKesson - Celonis implementation project

Hello,I want to calculate a Number KPI that will return me an percentage value of the cases covered by the 5 most common variants. The code should be similar to the % of cases covered in the Variant Explorer, but will always select the 5 most common variants in respect to the selection.Neither the Number of variants function nor the PQL references help me with my problem.Can someone help me out?Thanks in advance!

Hi Community,Hope everyone is staying healthy.I would like to build up our KPI statement but am having trouble making the formulas work as they should.I would like to count certain activities from the activities tables, but also exclude certain cases if they also pass through for example Changes to Document activity.For example:COUNT(DISTINCT CASE WHEN (ACTIVITIES.ActivityEN = Start of FI Non-Compliant Approval AND ACTIVITIES.ActivityEN != Changes to Document)THEN CASES."_CASE_KEY" ELSE NULL END)When applying the above formula, i get the same result regardless if I included the the "!= Changes to Document or not.I have also tried using a PU_COUNT formula but receive an error message:PU_COUNT_DISTINCT (CASES.ACTIVITIES.ActivityEN) IN Start of FI Non-Compliant ApprovalAND PU_COUNT_DISTINCT (CASES.ACTIVITIES.ActivityEN) NOT IN Changes to DocumentTHEN CASES."_CASE_KEY" ELSE NULL ENDPlease help.Cheers,Anna

The PTP model which we are working on has several major processes such as Standard ProcurementStock Transport OrdersDrop Ship purchase orders (originated from Sales orders)Returns Purchase ordersInter-company purchase orders etc.International purchase orders etc. In order to see these processes separately under Celonis IBC cloud., we can develop Custom transformations. However we want to understand what is the best practice or recommended approach. To elaborate the question - Let us consider example of one activity Create purchase order item Is it recommended to create multiple activities - one for each process such as Create standard purchase order itemCreate stock transport order itemCreate Drop Ship purchase orders itemCreate Returns Purchase order itemCreate Inter-company purchase order itemCreate International purchase order item etc. OR Is it recommended to just use the common activity name Create purchase order item for all the above processes and use attributes such as docume

Hello Celonis community, I would like to create a bar chart with a trendline. Is there something similar to the excel trendline option? image.png335628 13.5 KB Thanks in advance for your support. Kind regards, Francesca

Hi All, Could you please clarify the below query! Will new Process Model in Conformance change the initial view of process explorer in analyses? We have a requirement to change the initial view of process explorer with a certain list of activities given by the user. And the further expansion of the activity list should show the remaining activities. Thank you.

Hi,Id like to create a component filter to filter a dashboard sheet and its KPIs for a Subprocess.E.g. our KPI Touchless Order Rate should only be calculated for the subprocess process start to create delivery.I can get the right result, if I use the crop selection but I want to have this as a component filter.Can anyone help me with the right PQL filter formula?Thanks ,Carina

Hi, i am trying to connect to a Postgres Datasource via jdbc. It is not possible do get a connection. I always get the information unable to connect. With our Hana Source everything is working fine. Any advice? Beneditk T.

Hi Team,I have a rather complex OLAP table that I am looking to build and need your help. Its a two step issue that I am hoping that someone has some guidance.Part 1.We have a table in the back end that contains pmt term information. We have ranked the payments terms from 1 best to 30 worst. I have also created a drop down variable for the user to be able to select 1, 2, or 3.Essential, what i need to happen is, based on the current payment term that we have for the invoice, if a user selects 1, in the variable, then the next best pmt term will be populated in that column. if they select 2, then it would skip to the 2nd better pmt term that is on that list. so on and so on.image697258 7.47 KBCan you please advise if you can help me solve this issue.Part 2:Given that the first part can be done.The next part would be to calculate the days difference between the net due date of the original pmt term and the new payment term net due date. The original payment net due date we already pull i

Hi, is there a possibility to show the last load date of a process model in the analysis? Reason: The viewer should know when the last load of the process model took place. Thank you in advance Steffen

Dear Colleagues,I have a problem: I am calculating days with CALC_THROUGHPUT function. For some events I need to use LIKE function. But As I see, it is not possible to use one, only in func. FILTER or CASE WHEN. But How to apply event in CALC_THROUGHPUT when you need to cut a part of name?For example.AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Event1]TO LAST_OCCURRENCE[Event2:%],REMAP_TIMESTAMPS(EVENTS_EVENT.EVENT_DATE, DAYS)))Or maybe it can be done by another function of Celonis.Thanks

Dear community, I would like to create an OLAP table to calculate throughputs from Process Start to"Process End" of each client. My data model is single eventlog, Case_table, which consists of Process group, Activity, Time stamp, and Client. Every records of case table have client name( client1 - 4) in client column. I tried to make OLAP table like this. DIMENSIONS (1)Cient: CASE WHEN Case_table.Client = Client1 THEN Client-01 WHEN Case_table.Client = Client2 THEN Client-02 WHEN Case_table.Client = Client3 THEN Client-03 WHEN Case_table.Client = Client4 THEN Client-04 ELSE END KPIS (1)Throughput: AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(Case_table.Time stamp, Seconds))) It looked working, but the result was wired. The throughput of each client is higher than average throughput. When I delete dimension, OLAP table shows average troughput lower than each clients throughput. Does anyone know how to solve this problem? Thank you for your support. Sugano

Hi Celonis Team, Do we have an option to calculate the approximate time to be taken before extracting data from external sources /tables ? It will help us to plan the time accordingly and if needed, to skip the mammoth data and continue with rest OR schedule specific tables extraction during non-working hours. Attached example: DD03M takes a day to complete the extraction. Log file21191080 151 KB

Dear community, I would like to create an OLAP table which counts cases with/ without specific activities. In this case, Id like to count cases which through both Confirm Reservation and Sell Ticket. tickets_log524644 11.8 KB Id like to get the result like this. Confirm Reservation (Booking Number) : 1 Confirm Reservation (QR Code) : 2 Else : 2 *D-004 is treated as Else because D-004 passed though only Confirm Reservation The name of activity is different from my raw data, so please dont use wildcard like "Confirm Reservation" If I could, Id like to show the result as pie chart. Thank you for your support. Sugano

For a throughput time prediction I have to get the next-to-last activity (the last activity is a running one). How can I do that? I thought about doing it in the data transformation with python but Id rather use Celonis directly.

Hi, I have a table that can either show Volumes or Ratios of Sales Orders fulfilling a particular criteria. I have a drop-down which allows the user to select Volume or Ratio and the numbers in the table update accordingly. The issue is that when I flip to Ratio, I am not able to dynamically format the numbers as a %. Is there any way to specify the number format within the function editor?

Hello All, I would like to compare the #of sales orders created (with special condition) VBAP TABLE in june 2019 with number of goods issues created in june 2019 LIPS TABLE Thanks upfront.

Hi Team, I got doubt while loading data model. I have created a data model and added only activity table and stated loading from hana to data model. But data model loaded case table along with activity table without adding the case table to the data model. Is the case table loading automatic if we add and load only activity table to the data model?

Hi, We are using Celonis 4.5 on premise and we have implemented ECC-O2C data model. To get further, we would like to implement ARIBA-P2P data model, but we dont know which is the correct approach to extract the data to Hana. Do you have some technical information about how to extract this data? Thanks in advanced! Diego

Hi Team, Greetings! I have a Celonis Sandbox instance (https://ey-in-sandbox.demo.celonis.cloud/process-mining/ui) and we are trying to connect this to HANA DB and SQL Server by providing the credentials but are unable to get the connection working. Below are the details. 1>>The HANA DB is on Azure Cloud, we had selected database type SAP HANA and entered the other details which didnt work and we got a simple error message unable to test the connection . What other configuration needs to be done (please specify the details) 2>> The SQL Server 2012 is deployed on a Windows server system (on Azure cloud), we opened the TCP port 1433 at both the OS level and the Azure level for the same for this but the connection has not worked. Could you please help.Thank you!