Process Analysis

Dear All, I am looking for a similar functionality to sparklines in excel. This means I want to look at the trend for the sales price value development. But this should be represented as a single KPI for example using a math function. That gives us the gradient of the trendline. Thank you

In conformance history, we have the month wise intervals based on the selection criteria in the top. Need to know how to get the history on a daily or weekly intervals. image1735646 60.4 KB

Hello, has anyone had any experience in payroll process mining? The data is in Mepco software. I could not find any apps in the app store rather than recruitment process in HR. What I am interested in is mining the payroll process of HR from Mepco. Thanks

Is there an inbuilt process connector for SAP Success Factor in Celonis IBC

Please help from which table we can get the Comment section of the Action Engine, please find the attached screenshot. The Commented Text, the user commented and the timestamp it has been posted Background for this requirement: To understand the usability of the Action Engine created an Analysis taking the help of the Action Engine Tables like Event, Signal Attributes, Skills and others. Need to capture the Comment added by the user in any particular signal.

Hi all, I have the following issue: I have 2 tables Table1: articlenumber, Table2: articlenumber, I have no key defined in data model due to other reasons. Is it possible to define the key in the analysis, e.g. by using the pullup function so use both tables together (e.g. to find out how many articles are in table1 but not in table 2? Many thanks and br Daniel

Hi, Im getting a graphical bug where a table with horizontal scrolling in a fixed width sheet wont scroll to the end. Here is what it looks like. Untitled picture918358 6.82 KB Does anybody have a solution?

Hello, I am trying to filter observations in particular column which begins with SYS or ENG while counting (Number KPI). How can I do it with Celonis? I have read about MATCH_PROCESS_REGEX, but did not quite get it. Please help

We are trying to build a dashboard to calculate throughput time between two activities. Create SO Item with no block ( ')First Delivery Block (ZX) We are using the following PQL query is returning no values. Can you please guide us whether the pql query is correct? AVG (DAYS_BETWEEN( PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= start_activity_SO %> AND _CEL_O2C_ACTIVITIES.CHANGED_FROM = '), PU_LAST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= change_dev_block %> AND _CEL_O2C_ACTIVITIES.CHANGED_TO = ZG) ))

Hi, In the AP process, is it possible to do a search with all references that contained a space ? EX : DATA Reference number 12345 $5 1 2345 $10 23 451 $5 I would like to see only reference number with a space thanks in advance Thanks in advance. Audrey

Hi, a fairly basic question from a new user I expect! Im currently carrying out the Implementation Professional training. When I Execute an extraction it seems to stack a new data set on top of the first. My initial response was to make the Execution a Full Load rather than a Delta Load, but when I ran this, it ran for 2.5 hours without finishing and I had to close it down. Can anyone provide advice on next steps? Thanks! Dan

Hi, I am trying to show the number of cases devided by variants of process using following dimension and KPIs. Dimension DISTINCT (VARIANT("_CEL_MM_ACTIVITIES"."ACTIVITY_JA")) ACTIVITY_JA contains the name of activities KPIs COUNT_TABLE("_CEL_MM_ACTIVITIES_CASES") Only the Bar Chart is refused to show the result showing following error. OLAP and other types of graphics elements show successfully what I want. I believe the code is pretty simple, I cannot understand why the code does not work only in the Bar Chart. I have tried following things already, fyi; writing without DISTINCTwriting with SHORTENDcounting other things e.g. ACTIVITIES Please let me know should you require additional information concerning this issue. Best

Hello, I am quite new to Celonis, so perhaps this is a stupid question. I am investigating a process with a lot of different activities and a huge number of variants. To make some sense of it all, I am grouping a lot of the activities. However, whenever I close the analysis and reopen it later, the group definitions are gone and I have to redo all the work. Is there a way to save the activity groups? Thanks for the support!

Hello, I have a table to aggregated values that we are trying to bucket within a dropdown. Currently when we bucket the values it filters on the line item level, but we want to filter on the aggregated value level. When we try to use a sum within our case when statement we get an error Aggregation dimension sum cannot be used together with a dimension input {AC0AD37E-4292-4773-A85D-4272482940D6}.png990187 20.2 KB {637ABF08-9E0E-4217-80FE-44EDFEA9D10D}.png802297 38.1 KB

Dear all, I have connected two table via a key, example Table 1 T1.Banf T1.Pos T1.Wert 123 10 X 124 10 Y Table 2 T2.Banf T2.Pos T1.Wert 123 10 X 124 10 Y 1235 10 Key: Banf, Pos In Table 2 I show the values of Field Wert from Table 1. For Banf 123 and 124 it works as the key is working. For 1235 it does not work. The whole case is not visible. I want to show the case, just the value of T1.Wert should be empty or any text like no value. How ist that possible? With CASE WHEN ISNULL it did not work. Many thx and br Daniel

I am getting the error while creating the below KPI. Here KPI ABC_A/B/C is calculated KPI which uses SUM function. CASE WHEN KPI(ABC Categorization by Reporting Currency) = A THEN KPI(ABC_A) WHEN KPI(ABC Categorization by Reporting Currency) = B THEN KPI(ABC_B) WHEN KPI(ABC Categorization by Reporting Currency) = C THEN KPI(ABC_C) ELSE Vendor with no spend END

Dear process miners, I am playing with P2P process and I have PR item as case ID. When I am trying to create conformance ratio as a KPI in the transformation center, I am not sure whether I should BADAT field in the EBAN table or Eventtime field in the activity table. Does anyone know? Kind regards, Meyi

In this particular case I want to select one of the flags and the selection will filter the process explorer for some activities

Where can I find details about this, please?  Thanks,Maarten

I have a query regarding sending reports for critical KPIs using transformation center. I tried to navigate through transformation center but couldn’t find any such option where I can scheduled reports.  even tried to check help support section of Celonis Below screenshot is perhaps of the older version of transformation center which is there on the help page.   It seems older version of transformation center was having different interface and there were these option of sending weekly, monthly or daily reports.  Note : There is a possibility to use the Action Engine to create reports but would prefer to use the report function of the transformation center.  Any help will be appreciated.

Hi,Is there a way that my filters from one dashboard can also be applied to another dashboard? For example, in my first dashboard, I filtered 2-3 dimensions and now I wanted to analyze in another dashboard those dimensions again. It could be placing a button to navigate to the link in the 2nd dashboard, but the selections filters are left behind in the 1st dashboard.

Like the Title says, I have 18 Queued Executions of a Studio Skill that have been pending for 30m Here is a picture of the flow: Does anyone know how I can cancel / restart?It was running fine when I had just a couple of columns being written to the table, I've since added a number of columns and changed the Table Name  Thank you in advance!

What is the maximum number of rows we can export from any OLAP irrespective of the maximum rows we provided in the setting.

Hi everyone, I set up a bpmn model for my conformance checker, but the gateways does not seem to work. Example: Here I can see, that the movement from "Erstanlage Schaden" to "Manuelle Deckung geändert" is possible. However when i look in the Conformance analysis it lists "Erstanlage Schaden" followed by "Manuelle Deckung geändert" as one of the most common violations.   Any ideas what i can do about it?  Best,Maria

Hi there, our client hast 20+ activities that she has to drag and drop into the activity selection. Is there a less tedious way of doing this? One solution would be to create a new activity during the transformation step in the Event Collection.   But is there another way in the Process Analytics? Kind regards,Saša