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.

  • 588 Topics
  • 1,561 Replies
586 Topics
P
Level 3
pritam.roy20Level 3
asked in Process Analysis
In OLAP header and OLAP’s Fields header not able to use dollar ($)

Hello Experts, In OLAP header and OLAPs Fields header not able to use dollar ($), When I use the ** symbol, for example, if I give **Amount then it turns as "#{Amount $}".

00
gabriel.okaba11
Celonaut
A
Level 3
alexander.kwaukLevel 3
asked in Process Analysis
Variable number of KPI’s in a column chart

Hi Community, is there a way to build a dynamic column chart with 1 dimension but several, variable KPIs? The problem is, once I include all possible KPIs the bars wont be displayed anymore. In most cases only a certain number of those KPIs is necessary. For example: CASE A: Dimension (matnr.1): KPI1 (2), KPI2 (0 or -), KPI3 (4) CASE B: Dimension (matnr.2): KPI1 (0 or -), KPI2 (1), KPI3 (0 or -) In Case A only the KPIs 1 and 3 should be displayed in the column chart. In Case B same for KPI 2. Is it possible to change the visibility of KPIs on the basis of the CASE (A or B)? Maybe by using a parameter? Thanks for your help! Alex

10
gabriel.okaba11
Celonaut
K
Level 3
kayla.ledbeLevel 3
asked in Process Analysis
Is there a formula that can be used to identify duplicates in a data set?

Hi Everyone! Hoping someone can provide a formula or an idea on how to tackle the two issues below.  Some of our customers (most often EDI customers) order with their specific customer material numbers. Customer material numbers are entered in their CMIR table under their customer number (or payer #).  Issue 1: Customers who have been set up on EDI for years with no issues are now having orders fail resulting in an IDOC. This is because of mass uploads to update CMIRs (several without checking duplicates first by mistake). We need a way to identify these errors and remove the duplicates without having to pull reports for hundreds of customers out of SAP one-by-one to identify the errors. Also, we need a way to monitor moving forward to avoid duplicates.  Issue 2: EDI orders are failing because multiple customer material #s have been entered into the customer's CMIR table tied to only one of our part #s.

120
K
Level 1
S
Level 2
shruti.gupta16Level 2
posted in Process Analysis
Hi All,

Hi All, I am facing issue as follow. In our main analysis the total count of cases are showing lesser than the duplicated copy of it.The duplicate analysis showing more case count which is actually correct but the main analysis is having lesser records.The data model is same for both. In the process data model logs also it is showing the count same as duplicate Analysis.Any idea what is happening wrong here?

73
K
Level 1
B
Level 2
benedikt.tiege11Level 2
asked in Process Analysis
"Data Service Link" so SAP

Hello,we would like to use the "Data Service Link" funktionality to jump directly into our S4 System.Does anyone has already done that or knows how to implement that?Kind regards Benedikt

30
K
Level 1
M
Level 3
marcel.marceLevel 3
asked in Process Analysis
KPIs changing for the past

Dear Celonis Community, we faced a problem with our KPI calculation based on Sales Order Creation Date. In our graphs we usually show the KPIs (# of SalesDocuments, AutomationRate, etc.) agregated on Sales Order Creation Date. We have some countries having orders open for several months (e.q backorder handling). If now an order was created in january, all its activities are considered in the KPIs that belong to january. Even (due to the topic i described above) the activities from february to march. Looking end of january you will see different KPI values than in march, because february and march activities for this order happened and are now considered in the january KPIs. We know there is a possibility to switch to Eventtime, but we didnt find this a good solution either. I do not really ask for a technical solution, but just for an idea on how other customers handle this topic (do they even noticed it?, do they even face it?). Thank you very much for a response.

20
K
Level 1
K
Level 2
khushboo.khushLevel 2
asked in Process Analysis
Calculate % Perfect PO

Hello, I want to calculate the percentage of Perfect PO, For that I have to consider certain criterias like - Out of a list of WFs, I have to include only 1Payment should be on timeNo manual changes after PO orderedSome more criterias I am struggling to calculate this percentage, could anyone help me with this? Thank You. Best Wishes Khushboo

30
K
Level 1
A
Anonymous
asked in Process Analysis
N : K relation in a node with two leaves in the Inventory Management Process

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

00
K
Level 1
N
Level 3
nogueira.nogueLevel 3
asked in Process Analysis
Charts: Tick count on the Dimension Axis not working as expected

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

00
K
Level 1
P
Level 3
pritam.roy20Level 3
asked in Process Analysis
How to auto forward the signal List mails from Action engine when recipient mail is not responding

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

00
K
Level 1
F
Level 3
francisco.da.siLevel 3
asked in Process Analysis
Process AI to detect which variables are leading to a throughput higher than X days

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)?

10
K
Level 1
.
Level 3
.14600905Level 3
asked in Process Analysis
Threshold of Self Loops while using C4C Enterprise Version

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

00
K
Level 1
L
Level 2
lennart.lehma12Level 2
asked in Process Analysis
Get Count of two temporal related Tables

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.

00
K
Level 1
T
Level 2
tomasz.wrobe11Level 2
asked in Process Analysis
Can’t export from table in analysis

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

00
gabriel.okaba11
Celonaut
.
Level 2
.14600951Level 2
asked in Process Analysis
Formatting based on Formular based on year, month, week, day

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.

20
K
Level 1
R
Level 2
rob.buijtLevel 2
asked in Process Analysis
Processing high volume data from PLC’s

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?

10
K
Level 1
sudip.dutta
Level 2
sudip.duttaLevel 2
asked in Process Analysis
PO Vs Non PO Invoice

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

20
K
Level 1
S
Level 2
stephen.humphLevel 2
asked in Process Analysis
How can I calculate the total time a case spends in a particular set of states

We have a ServiceNow analysis and the business would like to know how long tickets are spending in a series of states. We are trying to analyse if we are putting calls on hold for too long. We are looking to do two things. For any set of tickets give me the total time this ticket has spent in a particular activity. So the event time of this activity until the next activity. The ticket may be in this state more than once through it's process journey. There are more than one of these states. Report on any tickets that have exceeded a specific threshold of time in one of these states. So the flow might go Ticket Created - Time 1Ticket On Hold - Time 2Ticket Active - Time 3Ticket On Hold - Time 4Ticket Active - Time 5Ticket Resolved - Time 6 I'm looking for the total time between Time 2 & Time 3 added to the time between Time 4 and Time 5. I cannot see a way to do this. Any ideas greatly appreciated.  

30
S
Level 2
J
Level 3
joão.francLevel 3
posted in Process Analysis
Hello,

Hello, In the process explorer analysis the dropdown component supports multi value paste, is it possible to do this in the studio (even if using a diferent component). Exemple: Use case: the user copies a number of clients from a diferent aplication, pastes these in the dropdown and the analysis is filtered for thoses clients. Kind regards,João

22
J
Level 3
M
Level 3
marco.messnLevel 3
asked in Process Analysis
Spark Line funktionality

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

20
J
Level 1
P
Level 3
prakash.k14Level 3
asked in Process Analysis
Conformance history

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

10
J
Level 1
S
Level 2
sezin.yaman12Level 2
asked in Process Analysis
Payroll process mining

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

40
J
Level 1
M
Level 2
meenakshi.chorg12Level 2
asked in Process Analysis
Process Connector for SAP Success Factor

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

30
J
Level 1
P
Level 3
pritam.roy20Level 3
asked in Process Analysis
Action Engine Comment Section Details

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.

10
J
Level 1
D
Level 3
daniel.diers12Level 3
asked in Process Analysis
No common parent: Solution with Pullup possible?

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

20
J
Level 1

Badge winners

  • 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
  • Value Realization Expert
    vartika.jaisw11has earned the badge Value Realization Expert
VIEW ALL
Community Code of Conduct