Skip to main content

Process Analysis

In the Process Analysis topic, you can ask questions and start discussions about systematically examining workflows to identify inefficiencies, capture value opportunities, and get recommendations for improvements using Process Mining and AI.

  • 589 Topics
  • 1,561 Replies
587 Topics
A
Level 2
alex.giorgLevel 2
posted in Process Analysis
Studio Views are very powerful with data and actions but, by default, they are not aesthetically appealing like Process Analitycs.

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. 

10
A
Level 2
A
Level 2
anushmita.rcLevel 2
asked in Process Analysis
Error in Utilizing Variables from Knowledge Model

Created a variable in the Knowledge Model but unable to call it from the Process Analysis within Sudio. Used ${} format for calling it but shows error. Also does not show up in the variable list.

10
D
Level 1
.
Level 1
.146001222Level 1
posted in Process Analysis
How to setup View with Action to send email from the selected case/ID as a variable/parameter? Appreciate if someone can share complete documentation.

How to setup View with Action to send email from the selected case/ID as a variable/parameter? Appreciate if someone can share complete documentation. Thanks in advance.

70
.
Level 1
C
Level 2
christopher.k11Level 2
asked in Process Analysis
Hi guys, i was wondering if anyone was able to actually reference 2 different Knowledge Models from 1 single view as explained in the Celonis Cloud Help (xxx.celonis.cloud/help/pages/viewpage.action?pageId=41196721)?

60
C
Level 2
P
Level 3
pritam.roy20Level 3
asked in Process Analysis
How To Backtrack The Connection Details From The Extraction Jobs

How to get the connection details used by the extraction. We have the below scenario. There are numerous connections being established with different sources, and some are duplicated connections were created depending on the need of different credentials with different of permissions of a particular source. Now the permissions have been sorted by the DBA, need to clear out Data Connections which are no longer in use. Stating the IBC is being treated a PROD and any fail schedule will be treated as a downtime needed to identify the connections which are in used by the current extraction process.

00
gabriel.okaba11
Celonaut
A
Level 1
aakash.aakasLevel 1
asked in Process Analysis
Value addition to Company on Procure to Pay data

Hi Team, I need to create some dashboard which shows the value added by Celonis in the organization based on Procure to Pay data. Do you have template/analysis which should help the organization to understand the value addition from Celonis. This will help to get the idea about what I can implement and show it to management. Thanks, Aakash

20
gabriel.okaba11
Celonaut
.
Level 3
.14600905Level 3
asked in Process Analysis
PNG Download of Process Flow Truncated

Hello Team, Im downloading the Process Flow from the Process Explorer as a PNG Output. Unfortunately the left most part of my PNG output is getting truncated. Are there any settings whereing I can specify the width, so that the PNG download is not getting truncated. Attached is the leftmost part of my process flow which shows the TP time as 81 Minutes. But in the PNG download, it shows only the Connection line with only minutes without 81. Kindly advice. Warm Regards, Jayanta Borkakoti

20
gabriel.okaba11
Celonaut
dennis.albre
Level 2
dennis.albreLevel 2
asked in Process Analysis
Filter Cases on multiple activities and conditions

How could be a filter realised with the following condition: Activity_1 was performed by Division A and a following change Activity was performed by Division B We started with: FILTER (ACTIVITIES.ACTIVITY = Activity_1 AND ACTIVITIES.DIVISION = Division A) AND (ACTIVITIES.ACTIVITY LIKE %Change% AND ACTIVITIES.DIVISION = Division B); Which resulted in a empty OLAP-Table. Does anyone have an idea how to realise this filter?

60
gabriel.okaba11
Celonaut
L
Level 1
lisa.schad11Level 1
asked in Process Analysis
Variable filter on throughput time search

Hi all, Im looking for a way to use variables to restrict the standard component " Throughput Time Search". As an example: I want the standard component to show me the average lead time of the process steps C-F. I have tried a filter on the component and used the following code: (CALC_THROUGHPUT(FIRST_OCCURRENCE[<%=dlz_start%>] TO LAST_OCCURRENCE[<%=dlz_end%>], REMAP_TIMESTAMPS(WFMT_EVENTS.TIMESTAMP, DAYS))) Unfortunately the filter does not change anything. But I do not get an error message either. Is my code wrong or does the standard component not provide this possibility? Thanks for your help!

30
gabriel.okaba11
Celonaut
U
Level 2
urszula.jesseLevel 2
asked in Process Analysis
Happy path showin 0 cases

Dear community, I have created my own eventlog from sap (field names are the same as in celonis eventlogs) and imported it to default analysis. I do not have problems with process explorer nor with process variants. However when I open Process Overview I can see some happy path but with 0 cases: Bildschirmfoto 2020-09-27 um 16.55.4725101336 249 KB Througput times and activities are displayed correctly. What could be possible cause for this strange behavior. Greetings, Ula Jessen

00
gabriel.okaba11
Celonaut
maximilian.hoffm13
Level 3
maximilian.hoffm13Level 3
asked in Process Analysis
Map Component - Threshholds based on KPI

Hi Community, Im currently building a Map in Celonis that shows the number of events per Location or Country. The calculated KPI uses a regular COUNT Function and is shown perfectly fine on the component. Now I want to apply coloring threshholds according to the data shown on the Map. The highest thresshold is supposed to be the maximum the KPI on the Map. Lets say the marker Germany has the highest number for the calculated KPI, e.g. 1000. Then the thresshold for red should be 1000, 800 for orange and 600 for yellow. Sounds easy, right? Well, it isnt. Although you can generally use functions to calculate the threshholds, you cant accomplish this behaviour in a consistent way: Wed need to manually aggregrate the KPI towards the Location, then take the MAXThe way do determine the MAX per Location would be to use MAX and a PU-Function inside (with a Domain Table for the Location).This works if youre not applying any selections. As soon as you filter your dataset, that function will no

40
gabriel.okaba11
Celonaut
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
CONCAT with date

Hi all, I want to compare/concat a string (e.g. SupplierName) with a date/day. Target: Are there days where I have used more than 5 suppliers. My formula suggestion: FILTER COUNT(DISTINCT SupplierName||Date)>5; Nay ideas? Many thx and br Daniel

00
gabriel.okaba11
Celonaut
T
Level 3
takayoshi.ichikLevel 3
asked in Process Analysis
Ranking the identical number as identical rank

Hi Community, I am trying to make ranking olap table. As rank, I use INDEX_ORDER() with desc tentatively, and it returns sequential numbers to identical values. Id like rank like DBMSss rank function like in MSSQLServer or Orale that returns identital ranks to identical values. image865452 16.6 KB Is there any ways to do above? Thank you,

50
gabriel.okaba11
Celonaut
U
Level 2
urszula.jesseLevel 2
asked in Process Analysis
Calculate Ratio of deleted purchase orders to all purchaseorders

Hi everyone, I have a table with activites that are created at the purchase order item level. Each purchase order have a supplier. I would like to see what ratio of activites is deleted for given supplier. But not at the line item level but at the purchase order level. I work with EKKO , EKPO Tables (EBELN, EBELP) and have both EBELN (Header) and EBELP (Position) in my activites table for example:: PO Nr Position Supplier Activity PO Deleted 101 10 A X 101 20 A X 101 30 A X 101 40 A X 102 10 A - 103 10 B X 104 10 B In that Case on Line Item level I get the Ratio for Supplier A - 80% Deleted and for B 50 % deleted. Actually the purchase order would always be deleted at the header level . So both A and B should have 50 %. I have tried that with pull activities but I do not get the right results. I thought something in the direction: PU_COUNT_DISTINCT(EKKO, MATCH_ACTIVITIES(NODE_ANY[PO deleted] )) and to bind it to supplier in the table. Any help would be apprecia

10
gabriel.okaba11
Celonaut
T
Level 2
tamanna.tamanLevel 2
asked in Process Analysis
Ranking based on aggregated columns

Hi, I have a table of Agent who first performed an activity A calculated using (PU_FIRST(Case,Activity_Table.Agent_Name,Activity_Name"="Activity_A) and KPI of Number of times a particular activity was repeated within 7 days using : SUM(CASE WHEN DATEDIFF(dd,LAG(WorkOrder.CreatedDate,ORDER BY (WorkOrder.CreatedDate), PARTITION BY (Case.CaseNumber)),WorkOrder.CreatedDate) < 7 THEN 1 ELSE 0 END) . I want to rank the agents based on this KPI as another column. Can you please guide me on how to do the same ? Thank you for the help

50
gabriel.okaba11
Celonaut
G
Level 3
gopinadh.kanch12Level 3
asked in Process Analysis
Celonis Analyses process explorer showing message “all existing activities are hidden”

We have created multiple Authorization objects on sales org from VBAK table and applied on data model and provided analyses access to users by adding the authorizations objects to the users and data model. when users try to access the analyses process explorer, they can only see the message all existing activities are hidden and no data displayed in any sheet of the analyses. There is no issue if i add only one sales org. auth. object to user. if 2 or more sales org. auth. objects are added to the same user, the analyses is not showing data and showing message as all existing activities are hidden . Could you please suggest the possible root cause an fix of this issue! Thank you for your support. Regards GopiCelonis authorization issue.pdf (75.2 KB)

00
gabriel.okaba11
Celonaut
.
Level 1
.14600917Level 1
asked in Process Analysis
KPI returns different values in Number and OLAP components when filtered by same dimension value

Hi everyone, Ive created an Approval ratio of cases by using out-of-the-box KPI Ratio of cases flowing through an activity = KPI(Ratio, MATCH_ACTIVITIES(ENDING[Approved] ) = 1). It works as expected, out of 243343 cases 108698 of them are ending with Approved task which gives rounded up the value of 45% visualised as a Number single KPI component. However, when the KPI is added to the OLAP table and sliced by example Sales Channel dimension the result in OLAP and Number visuals is different. In the OLAP table Approval rate is 52% (wrong result) and in Number single KPI component is 31% (correct result). It turns out that in the OLAP table the KPI is switched to count activities instead of cases, hence the result is 52%. celonis different result1159530 61.2 KB Is there a catch how to get the same correct % in the OLAP table? All data is contained within a single table. Thanks, Ivan

20
gabriel.okaba11
Celonaut
M
Level 3
miriam.luttrLevel 3
asked in Process Analysis
Action Engine Migration to Studio Skills

Hello, We are currently in the midst of migrating all our Analyses and Action Engines to Studio. Celonis provided with a functionality to seamlessly migrate the analyses to Studio. Is there an easy way to migrate Action Engine Skills to Skills within Studio?  Thanks

10
M
Level 3
P
Level 2
patrick.flößLevel 2
asked in Process Analysis
Vendor Invoice Managements fully automated and manual documents

Hello all, I try to find out, how to best measure fully automated vendor invoice management documents (can also be any other document head). I found a way to measure measure documents, that contain at least one manuel user interaction: COUNT(DISTINCT CASE WHEN CASE WHEN "_CEL_VIM_ACTIVITIES"."USER_TYPE" IN ( <%=manual_user_type%> ) AND "_CEL_VIM_ACTIVITIES".ACTIVITY_<%=language%> NOT IN (<%=whitelist%>) THEN 1 ELSE 0 END = 1 AND MATCH_ACTIVITIES("_CEL_VIM_ACTIVITIES"."ACTIVITY_DE", NODE['Gleiche Rechnung aus (VIM)']) = 1 THEN "/OPT/VIM_1HEAD"."DOCID" ELSE '' END ) This works as single kpi and on a line chart. When I try to apply a somewhat similar logic for automated documents, I get the expected results as single KPI, but in the timeline I get like twice the documents. COUNT(DISTINCT CASE WHEN MATCH_ACTIVITIES("_CEL_VIM_ACTIVITIES"."

70
P
Level 2
J
Level 1
jia.dingLevel 1
asked in Process Analysis
SUM unique table column values

Hello ALL, I am working on pulling sum of values from a particular table column in Celonis using PQL. I try to the sum of distinct values of the table column. However, when I do SUM(Table.Amount) it is giving me sum of all the values in the column and not the unique ones. I want to get the 30000000 + 7500000 = 37500000. How to sum the unique colunm values? thank you.

80
K
Level 1
M
Level 1
markus.herdiLevel 1
posted in Process Analysis
Hi all,

Hi all, Can PQL Statements be used in variables in a knowledge model? In Process Analytics that works like in this example:PQL Statement: CASE  WHEN <%= PROCESS_GRANULARITY %> = '<%=PE_CENTER_ACTIVITY%>' THEN <%= PROCESS_GRANULARITY %>END Variable <%= PROCESS_GRANULARITY %> :  CASE       WHEN PU_FIRST("TM_Activities", "TM_Labeled_Data"."AppView") != 'Unlabeled'      THEN PU_FIRST("TM_Activities","TM_Labeled_Data"."AppView")END But I can't find a way to do this in a Knowledge model. Is there a way to do this with KM Variables or KPIs?Thanks a lot!

33
K
Level 1
U
Level 2
ugurcan.aydem12Level 2
asked in Process Analysis
How can I create a PDF report from Studio Skill for my analysis in the Studio

Hello, I try to create this skill in the Studio, in the sheet section( I marked it in the screenshot) there are no options for my sheets of analyses that’s why I cannot selected any.    Even if I have 3 sheets in my analysis (called “deneme”), I cannot selected these in my skill settings. How can I select these?    

20
K
Level 1
.
Level 2
.146001160Level 2
posted in Process Analysis
Hello,

Hello, I've created a view and a profile view in Studio. I need to be able to select individual lines in profile view, however selecting any line makes all lines selected. I was trying to play with record identifier of knowledge model, but that doesn't seem to make any difference. Is there any way to fix this behaviour? Do you guys have any clues? Thank you :) @mateusz.błażk​ 

63
K
Level 1
A
Level 3
axel.bühle11Level 3
asked in Process Analysis
How do I export a table from Business View into Excel that respects user selected columns? How do I export a properly formatted date?

e.g. including hidden columns manually selected by user to be visible (currently columns with attribute hidden: true do not seem to export irrespective of user selection) 

60
K
Level 1
P
Level 2
pritam.roy19Level 2
asked in Process Analysis
How to know the email sending limit for a team from Studio smart sensor

We have implemented a smart sensor which will identify some data with filter statement followed by dropping a mail to the predefined users. For today we had 54 signals created among them 28 have been executed by dropping the mail rest are having the below error message. "message": "429 - \\"Team limit for executing Email by Celonis has been reached\\""

130
K
Level 1

Badge winners

  • Qualified to Prove Celonis Value
    schahram.hamrahas earned the badge Qualified to Prove Celonis Value
  • Qualified to Create and Deliver Demos
    erick.matoshas earned the badge Qualified to Create and Deliver Demos
  • First Post
    Inahas earned the badge First Post
  • Value Realization Expert
    yukihiro.satohas earned the badge Value Realization Expert
  • Value Realization Expert
    yohei.kasaihas earned the badge Value Realization Expert
VIEW ALL
Community Code of Conduct