Product Q&A

Hi everyone, at the Plansee Group we do Inventory Management with Celonis. After three months, we have setup a new data model with most of the business requests covered. We do also calculate the Days Inventory Outstanding (DIO). This works well. Now, wed like to add the evolution of the DIO with time. However, there are three tables (A,B,C) involved with A being the parent node and B and C being a leaf of A each. The relations are 1:N (A:B) and 1:K (A:C). In order to calculate the DIO, we use PU_FUNCTIONS to pull data from B and C on A. Thus, the N:K relation is resolved. Now, wed like to represent the Evolution with time by a date which is only given in table C. While, we could choose a data in the first approach within the condition of a PU_FUNCTION, this doesnt apply if we choose the data to be a dimension of the component. Id appreciate your input from a developer perspective very much and I am looking forward hearing from you. As the logical connection is quite complex, feel free

When I select the manual tick count on the Dimension Axis I would expect a behavior similar to the one I see at the KPI Axis. However it apparently does nothing. Example: When presenting a series of dates, lets say the daily position of a customers credit for a whole year, I filled in 12 in the Ticks count field, expecting it to show only one tick per month, instead of on per day. But nothing happens. Am I interpreting wrongly the way this should work? It would also be nice that data labels would only be displayed where the ticks are shown. Thank you, Joaquim

Hello Team, How to auto forward the signal List mails from Action engine when recipient mail is not responding. Senario: If the employee mail has been revoked or mailbox full error is coming the Action Engine Signal will move to his/her manager/sponsor. Auto forwarding the mails to another mail on receiving the failure acknowledgement from the routing rule defined mail

Hey everyone, Im trying to put my head around the process AI feature for the first time, but have not got really far until now My process is linear, as Ive used process mining to analyse the performance of a purchasing process to detect what was causing higher than expected throughput time of a PO item, and also redundant POs released to a supplier. Having a target throughput time of 2 days, can I leverage process AI feature capabilities to detect most probable root causes (taking into account the characteristics of each event log, product reference, department, price, etc)?

Hello Team, My team is using Celonis C4C Enterprise Version and we are creating some dashboards for Purchase To Pay for our customers. There is a requirement where we need to increase the Threshold of Self loops. Im trying to increase the threshold to 500 but it resets to 100 after saving the analysis settings. Just asking if 100 is the threshold limit? Eagerly waiting for a response. Thank You. Warm Regards, Jayanta Borkakoti

Hey, I want to create an OLAP Table, which has the Activity Name as Dimension, Count of other Table within a specific time and the mode of the count as KPIs. Both tables have timestamps and the same ID (see attached image with explainationCelonis_Questions729848 43.2 KB ). Unfortunately, I have no idea of how to do this with the PQL statements and tried various things but none were successful. Im using Celonis on-premise 4.6. I would appreciate any help here.

(topic withdrawn by author, will be automatically deleted in 24 hours unless flagged)

Hello all, how can I format my colum chart based on this formula? CASE WHEN '<%= unit %>' IN( 'YEAR') THEN '%Y' WHEN '<%= unit %>' IN( 'MONTH') THEN '%Y-%m' WHEN '<%= unit %>' IN( 'WEEK') THEN '%Y-%m' WHEN '<%= unit %>' IN( 'DAY') THEN '%Y-%m-%d' END The formula doesnt work in the format space. image1321124 6.54 KB Thank you in advance.

Would it be possible for Celonis to process real time high volume data from PLCs. Most use cases I see have to do with administrative processes. How about PLC data processing? Anybody with experience on this topic?

Hi All, I have full AP data and I am trying to write a formulae in Celonis to showhow many are PO Invoices and another one to say how many are Non PO Invoices. What will be my PQL query be. Thanks Sudip

Hi,i do have trouble implementing implenting a filter. I want the to give the business user the chance to filter for a value range.the column looks like:x001x002x003y001y002z001At the moment there is a button dopdown - but there is the need to look up a range, e.g. x050-x080 which are to many values to be selected manually.My idea was to let the user set the minimum and maximum value via input fields and use those values as a sheet filter but variables can not be used in sheet filters.Does someone have an idea?Best regards,Jan

Hello, in the ML workbench, as the R language is available, is there a way to push and pull data from a data model using R kernel? Or is it possible only in Python using the pycelonis package?

Hi team,i have an activity table as follow:activity_table(Case ID, Category, Activity, Timestamp)A, Red, Activity 1, Jan 1 2020A, Red, Activity 2, Jan 2 2020A, Red, Activity 3, Jan 3 2020A, Blue, Activity 4, Jan 10 2020A, Blue, Activity 5, Jan 31 2020B, Red, Activity 1, Jan 5 2020B, Red, Activity 2, Jan 10 2020Is there a way that i can aggregate the average throughput time per category to get the following result:Red --> (3 + 5) / 2 = 4 daysBlue --> 21 daysBest,Dominic

Hi All, In celonis transformation I would like to use Dynamic parameter to store the select query output and the same parameter i need to use in upcoming queries for further processing.  Could you please help me with option for the same? Thanks in Advance.

Hi everyone,Im having some trouble finding out how to implement a throughput time KPI.How do i calculate, for example, the throughput time from the first occurence of an activity to the second occurence of another activity?The goal with this would be to compare activity changes and check which take the most time.Thanks a lot in advance!Joo

Hey there! is it possible to extract the saved variable values in a specific analysis using pycelonis/ML workbench? Any insights on this is appreciated. Thanks in advance!

When sending an email using "Email By Celonis" using a Smart Sensor in Studio, how does one create/specify/add an attachment to the email? Can it be an external document or only information that is stored in the knowledge model? Thank you.

As a Business View user I would like to re-arrange columns in a table and show/hide columns and save these configurations as a favorite or pre-set so that I can always return to my customized view

Hi Team , I am trying to connect with Oracle Database from Celonis ML using cx_Oracle python Package but getting error as : cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: libclntsh.so: cannot open shared object file: No such file or directory. See https://oracle.github.io/odpi/doc/installation.html for help . Any help or information about this would be highly appreciated . Thank You, Amruth Muddana

Hi,I was trying to set a schedule for my action flow, but on the time icon scheduling mode option, I only have this option: According to scheduling. And I cant find where that scheduling is. Is there a new way to schedule action flows?

Does anyone has sample Event log for the beginner to analyze it in Snap ? If so please share. Thanks in advance for your help.

Creating a drop-down field that will change the dimension of the first column in a table. E.g. I want to be able to switch between dimensions like, country, regions, Vendors, etc.To display in a chart the top 5 values (like Top 5 Vendors) with the possiblity to scroll beyond the top 5 (adding a scrolling functionality).  Normally it’s quite straight forward but within Views I can´t find the solution.  Many thanks and best regards, Manuel

I have setup a ML Duplicate Checker model that runs daily, it is connected to the Action Engine and generated a Dashboard Report as well. Whenever there are new duplicates I receive signals alerts and the information gets pushed to the Dashboard report as well. How can I include the signals creation date to the reporting Dashboard in Studio?

Is it possible to color code the unwanted connection?

Hi, we are using Celonis Version 4.5 on premise. Is there any chance to configure Database connections parameters at one singel Point? At the moment every project has its own definition. Because our Database user password has to be changed frequently this is quite unhandy. kind regards Benedikt