Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3045 Topics
R
Level 3
robin.pianeLevel 3
asked in Process Analysis
Throughput time between activities followed directly

Dear all, How can we calculate a throuput time between 2 activities, but only when the activities are directly linked ? An example: I need to calculate the lead-time in orange. With this formula the result is not correct, because there is an other A2 activity later in the process (it could also happen that this additional A2 activity, not directly coming from A1 occurs before in the process) AVG(CASE WHEN (PROCESS EQUALS A1 TO A2) THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[A1] TO LAST_OCCURRENCE[A2], REMAP_TIMESTAMPS("_CEL_ACTIVITIES_NC".EVENTTIME, HOURS)) ELSE NULL END) Thank you for your help, Best Regards Robin Celonis_Help.png87681 1.94 KB

00
P
Level 1
5 years ago
.
Level 3
.14600836Level 3
asked in Process Analysis
Automation rate

Hi all, were currently only considering user types to define which activities have been done automatically (batch user) and which have been processed manual (all other user types): 100.0*AVG(CASE WHEN _CEL_P2P_ACTIVITIES.USER_TYPE IN (<%=auto_user_type%>) THEN 1.0 ELSE 0.0 END) However, for our MRP runs which shall be also considered automated there is always a manual user in SAP. We can identify MRP runs by the doc type (EP) in combination with the PR creation indicator (B). Any suggestions how we can adjust above formula to also consider EP in combination with B as automated? Thanks Oli

10
.
Level 3
5 years ago
D
Level 1
david.beche12Level 1
asked in Entry Products (Celonis Free Plan & TryCelonis)
Snap User Story: Formula 1 Analysis

I like motorsports, I like car racing, I like to go to race tracks or watch races on TV. So I thought "How cool would it be to analyze Formula 1 seasons, races, and drivers like polish Grand Prix legend Robert Kubica? Although Im a Celonis employee, I of course couldnt use the software for private purposes like this. However, that changed with the release of Celonis Snap, which is free to use for everybody. Heres how I created this Analysis using my personal Snap Account. First of all, I needed to get data. I found a very nice dataset on https://ergast.com/mrd/db/ . The dataset consists of multiple tables containing up-to-date F1 race data from the very first Grand Prix in 1950 until today. I created the tables in my Postgres database based on the schema information provided on the website, and dumped the csv files into it. I dumped them into a relational database instead of uploading them directly to Snap because I needed to do some transformations before, for example, I wanted t

50
D
Level 1
5 years ago
.
Level 1
.14600865Level 1
asked in Data Ingestion & Infrastructure
Average throughput time for a specific sequence of activities in perfomance analysis

Hello!For the sake of performance analysis, I want to create an OLAP table to cover the following aspects of a certain part of a process (Activity 1 -> Activity 2):PerformerTaskThroughput time, daysPercentage from a total workloadATask 1520%ATask 2180%BTask 1120%BTask 2270%BTask 3710%There are a number of encountered problems however.First, a standard THT KPI formula calculates only a difference between FIRST / LAST occurrences of an activity, thus it does not work for measuring time strictly between two activities taking into account all rework and process deviations (like Activity 1 -> Activity 3 -> Activity 4 -> Activity 2 ).To overcome this issue, I used SOURCE / TARGET function, and it works when I just calculate the THT KPI only, but I have not managed to add other dimensions in the table (no common parent between tables could be found).Second, to determine the ratio of a specific task among all of other tasks I again - need to clean the number of cases as it turned o

10
B
Level 1
5 years ago
E
Level 1
erin.ndrio11Level 1
asked in Entry Products (Celonis Free Plan & TryCelonis)
How is snap different from enterprise version of IBC?

Celonis Snap provides you with great tools to analyze your processes data. Want to take it to the next level? Then you should check Celonis Enterprise, which provides many more features for more advanced use cases. Celonis Enterprise features that are not available in Celonis Snap include: Data Uploads over 500MB: Schedule unlimited data loads as frequently as by-the-minute, or as a one-time event.Process Automation - Automatically update the data in your underlying systems to enforce optimal processes across your technology estate.Transformation Center: Track the impact of process enhancements over time. Use collaborative tools to bring your whole organization together and focus on making continuous and lasting improvements.Machine Learning Workbench: A python development platform to help data science teams create business impact by leveraging process data and the python ecosystem.

00
E
Level 1
5 years ago
E
Level 1
erin.ndrio11Level 1
asked in Entry Products (Celonis Free Plan & TryCelonis)
What can you do within your snap team?

Curious what you can do with Celonis Snap? Celonis Snap is the worlds first free and open process mining software. Once you have signed up and activated your Snap team you are able to: Use our Quickstart to upload up to 500MB of your own event log data from a CSV file and start visualizing the way your processes really work. Connect your ServiceNow Incident Management Process for free and with no installation required. Gain valuable insights instantly with our pre-built Celonis for ServiceNow apps.Connecting your ServiceNow with Celonis Snap gives you: 100% Transparency: Intelligent algorithms help you to reconstruct, analyze, and understand your ServiceNow processes accurately, so you can focus on the most important areas of improvement. Reduce Ticket Volume & Resolution Costs: Enables you to identify and eliminate the root causes of inefficiencies across your entire service desk operation to decrease costs & volumes. Increase Ticket Resolution Efficiency: Solve tickets f

00
E
Level 1
5 years ago
E
Level 1
erin.ndrio11Level 1
asked in Entry Products (Celonis Free Plan & TryCelonis)
How to get your snap team?

Creating a Snap team is really easy, fast, and free. Follow the steps below: Go to celonis.com/get-started. Once there, click on Get Snap. fwKmIPO_4O_9ZAH0JvsNqSXTskL1EmhtxQ6SJmU7bjP6MvayTzvnUfMQffIxIQN636_uwERFACVU-dl2bnrlOQr0prBZNVUVYcuXrKPHbcZvw1yZorLNqxiYHC2R9hER0VsRCcLL.png1600904 300 KB Youll be redirected to the Snap Sign-up page. Fill it out the form with your First Name, Last Name, your Company email and your Organization and click on Next. Once you have filled out your information and clicked Sign-up we will start creating your team. Dont worry, it wont take longer than 2 minutes, and in the meantime, you can watch our CEO explain the vision and benefits of Snap. Once your team is created, youll receive an activation email to confirm your team membership. Activate your team and you are ready to start process mining! PN2yWA4dZIOnHDXoiDeMZLx5XdMyAODatAJffqbeXVK4SA2I0D2wXNrztXg34Rx2zKjgfxaEzwCz8laZuxHHEBnPdnEGfW-p___P07lhAm0Qhm6KtUSNAwXFaSW83ceibygxWNwV.png1206983 62.3 KB

00
E
Level 1
5 years ago
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Througput time at header level

Dear All, We ahve a througput time caclulated as below CALC_THROUGHPUT(<%=from_occ%>_OCCURRENCE[<%=From%>] TO <%=to_occ%>_OCCURRENCE[<%=To%>], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, <%=unit%>)) THis gives us througput time at line item level (Case key). How can I calculate the same at header level. Say at VBAK level. Thanks Naveen Gupta

00
B
Level 1
5 years ago
.
Level 4
.14600833Level 4
asked in Data Ingestion & Infrastructure
Variable as Manually Defined Categories

Hi,I am trying to allow a bit of Text Mining in my analysis and do smth likeCASE WHEN table1.column1 LIKE <%=Variable1%> THEN table1.column1 ELSE NULL ENDIt works fine with a Variable defined with the help of the Variable Input component with to show thats a text piece. What I would like to do is to manually define some categories as a Variable and use them.For exampleI would like to define Categories like Green, Red and Apples (for example in dropdown) so that i can just choose them without need to type them down everytime I need.Any ideas?Cheers,Maria

00
.
Level 4
5 years ago
.
Level 3
.14600836Level 3
asked in Process Analysis
Amount of price change in Euro

Hi all, When analyzing price changes in Celonis I would like to show in our details tab the Euro amount of the actual price change per PO line. We are already using quite a sophisticated formula to show in a graph the price changes for different thresholds in percentage. I assume I can use this formula partially in order to show the Euro amount of the price change. Following part, I used to do that (which does not work yet): CASE WHEN ISNULL(PU_FIRST(EKPO,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = Change Price)) = 1 THEN No Price Change Activity WHEN PU_FIRST(EKPO, _CEL_P2P_ACTIVITIES.CHANGED_FROM_FLOAT,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN = Change Price) - PU_LAST(EKPO, _CEL_P2P_ACTIVITIES.CHANGED_TO_FLOAT,"_CEL_P2P_ACTIVITIES".ACTIVITY_EN = Change Price) END Any idea how to resolve? Thanks, Oli

00
.
Level 3
5 years ago
C
Level 3
cristian.cristLevel 3
asked in Data Ingestion & Infrastructure
Manage Nulls in KPIs

Hello Everyone,We have some KPIs which are the result of a Criteria over the population. I.e cases that follows directly from process A -> B DIVIDED all the cases that went through AThere are cases where the numerator and denominator are Zero , Celonis manage 0/0 as NULL which is correct, but for my KPI I should present either 0% or No Activities instead of -Can you please advice the effective way to manipulate the output of the KPI to manage the Nulls?Regards,Example:SUM(CASE WHEN BKPF.AWTYP IN (BKPF, BKPFF, BKPFI, IBKPF, TRAVL)AND BSEG.BSCHL = 31AND PROCESS EQUALS Invoice posted TO Pay InvoiceTHEN BSEG.WRBTR_CONVERTEDELSE0.0END)/SUM ( CASE WHEN MATCH_ACTIVITIES(ENDING[Pay Invoice] ) = 1AND BSEG.BSCHL = 31AND BKPF.AWTYP IN (BKPF, BKPFF, BKPFI, IBKPF, TRAVL)THEN BSEG.WRBTR_CONVERTEDELSE0.0END)

00
D
Level 1
5 years ago
.
Level 2
.14600778Level 2
asked in Data Ingestion & Infrastructure
Create Dropdown Filter for PO creation by Fiscal Year

Hello,we want to add two dropdown filters to select purchase order items by creation year.One by calender year and one by fiscal year.The one for calender year would just be YEAR(EKKO.AEDAT).For the fiscal year the dropdown option 2019 should contain all purchase order items with EKKO.AEDAT between 1st of May 2018 and 30th of April 2019 and so on. Can this be implemented?I tried the following, but the error not implemented yet appears.CASEWHEN EKKO.AEDAT BETWEEN 2018-05-01 AND 2019-04-30 THEN 2019ELSE END

10
B
Level 1
5 years ago
F
Level 2
farzana.teymoLevel 2
asked in Data Ingestion & Infrastructure
Wrong value given by division

Hi there,Im getting the wrong values in two different cases when Im dividing in celonis:Case 1:(Sum(CASEWHEN ((EBAN.MENGE)/(EKPO.MENGE)) < 1 THEN 1ELSE 0END)+Sum(CASEWHEN ((EBAN.MENGE)/(EKPO.MENGE)) > 1 THEN 1ELSE 0END))/(1.0*COUNT_TABLE(EKPO))Individually the first sum evaluates to 455. The second sum evaluates to 249. the numerator is then 704. The denominator comes to 3555.The output should then be 704/3555 = 0.19803But the output on Celonis is 0.2068762Case 2:SUM(CASE WHEN ISNULL(EBAN.FLIEF) = 0 AND EBAN.FLIEF != EKKO.LIFNRTHEN EKPO.MENGEELSE 0.0 END)/SUM(EKPO.MENGE)The numerator comes out to 4069455The denominator comes out to 1521749967The result should be 0.0026741The result is 0.0077356Any ideas whats causing the wrong values?

00
F
Level 2
5 years ago
joos.buijs
Level 6
joos.buijsLevel 6
asked in Data Ingestion & Infrastructure
Filter dashboard to only contain cases with activities

Situation: We have a data model with an activity table, cases table, and some other tables.Problem: We would like to only consider those records in the cases table for which an activity exists.Details: This works if both tables are used in the same component, because in the backend the tables are automatically joined from activity to case (left join). However, when for instance counting the number of cases (count_table(cases_table)) all cases are considered. We therefore would like to set a load filter or pinned filter that filters out those cases for which no activities are recorded. Any ideas on how to do this???Ideally we would also like to automatically filter our other tables to only keep records linked to an activity.We are coming from a single table setup where all tables where joined into one large table. This problem did not exist then, but performance (especially when reloading) was sub-optimal. The new setup performs better, but apparently has its limits.PS: I feel the PQL f

00
joos.buijs
Level 6
5 years ago
N
Level 3
naveen.guptaLevel 3
asked in Process Analysis
Saving my selection and coming back to it when I want to

We are looking for an option to save a selection like a variant. For e.g. Saving Sales Org, Division and Mateial groups selections as a variant. With the possibility to come back to that selection. Any suggestion, how to achieve that?

00
N
Level 3
5 years ago
S
Level 2
sebastian.brahmLevel 2
asked in Data Ingestion & Infrastructure
Query settings in config-custom.properties

Hello Community, following config-custom.properties setting is offered: # Query Settings # -------------- # Maximum number of threads used in a query. To use an unbounded pool, use the value -1. By default, 30 threads are used. # query.parallel.maxthreads=30 How is this setting influencing a) end user (frontend) performance? b) backend ressource consumption? Is there a best practice about how to configure this setting? Best regards Sebastian

00
V
Level 1
5 years ago
R
Level 2
rakesh.paul11Level 2
asked in Process Analysis
Hyperlink Issue

Every time an analysis is transported from QA to PROD, old analysis is deleted and a new one is placed in the folder, as a result, the bookmarks are also deleted with transport. How we can get rid of this problem.

00
R
Level 2
5 years ago
joos.buijs
Level 6
joos.buijsLevel 6
asked in Data Ingestion & Infrastructure
Pinned filter in 4.5

Im trying to create a pinned filter (/selection) in a dashboard on Celonis 4.5According to the documentation (https://help.celonis.de/display/CPM45/Filter+Editor) this should work:SELECT PINNED YEAR("EVENTLOG"."EVENTTIME") AS "YEAR" = 2010;However, Celonis then reports that SELECTED is not supported anymore.I therefore triedFILTER PINNED YEAR(EVENTLOG.EVENTTIME) AS YEAR = 2010;But this does not work.How do I create pinned filters in Celonis 4.5?

00
joos.buijs
Level 6
5 years ago
.
Level 3
.14600836Level 3
asked in Process Analysis
Threshold values on PO line item amount

Hi all, were using threshold values based on PO header level in order to filter on low or high value items (e.g. below 100 or above 10k). The formula works on PO header level (EKKO table) but should be based on line item level (EKPO) - the formula looks as follows: CASE WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) >= 0 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 100 THEN a) 0 - 100 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 100 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 500 THEN b) 100 - 500 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 500 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 1000 THEN c) 500 - 1.000 WHEN PU_SUM(EKKO,EKPO.NETWR_CONVERTED) > 1000 AND PU_SUM(EKKO,EKPO.NETWR_CONVERTED) <= 10000 THEN d) 1.000 - 10.000 ELSE e) > 10.000 END I tried to exchange EKKO with EKPO to have PU_SUM(EKPO,EKPO.NETWR_CONVERTED) but that didnt work. Any suggestions how to change properly? Thanks, Oli

10
.
Level 3
5 years ago
joos.buijs
Level 6
joos.buijsLevel 6
asked in Data Ingestion & Infrastructure
Histogram grouped not on case

Hi all,We would like to show a histogram, where the dimension is not calculated per case but per customer.Concretely, we would like to know how many customers have 1 case running, how many 2-4, 4-6, etc.The regular histogram would be great because of its auto-binning feature. However, it automatically assumes that the dimension is calculated per case.Any ideas how we can use the histogram component, or mimic this behavior in a bar chart?

20
joos.buijs
Level 6
5 years ago
D
Level 3
david.werneLevel 3
asked in Data Ingestion & Infrastructure
Exclude NULL from Color Mapping

Hi everyone,does somebody know a possibility to exclude NULL values from the color mapping?I have an OLAP showing Projects in regards their delivery date differentiating between current internal responsiblity and external. For internal we measure against an internal deadline, while for externals this date is empty. So the color mapping should only apply on the lines with filled values, but all Null values are set red:Best regards,David

00
D
Level 3
5 years ago
K
Level 1
katharinacollatz@zeisscom.kLevel 1
asked in Data Ingestion & Infrastructure
Pop-up with detail-information on analysis

Hi all, is there an option to also create pop-ups when a viewer is moving with the mouseover a field or analysis? E. g. there is a button in the analysis that shows a KPI and when I am putting my mouse over the field there will show up the explanation how the KPI is calculated. I only no the functionality to create message buttons but this makes it confusing. Thanks.

00
C
Level 1
5 years ago
S
Level 3
sasan.babaz12Level 3
asked in Data Ingestion & Infrastructure
One Case ID with different cases

Hello,I try to create an OLAP table where I can see the reasons why an invoice is being rejected. Since an invoice can be rejected by more than one reason, how can i display all the reasons?When I do a CASE WHEN it takes the first reason it matches. And is it possible to display more than one reason in one column? E.g. Reason a + Reason b in one column?Thank youSasan

00
joos.buijs
Level 6
5 years ago
M
Level 2
michael.johnsLevel 2
asked in Process Analysis
Measure Booking Process by Order Level

I need to measure the number of orders within the booking process: anything between Create Quotation and Create Sales Order Item. For background, the # of Sales Orders using COUNT_TABLE("VBAK") is 200k. Using either of the below formulas continues to give me 200k Sales Orders. I have also attempted it with/without many different component filters: COUNT(DISTINCT CASE WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Create Quotation','Create Sales Order Item') THEN "VBAK"."MANDT" || "VBAK"."VBELN" ELSE NULL END) or COUNT (DISTINCT CASE WHEN (PU_COUNT("VBAK","_CEL_O2C_ACTIVITIES"."USER_TYPE","_CEL_O2C_ACTIVITIES"."USER_TYPE" LIKE '%' AND "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Create Quotation','Create Sales Order Item')) = PU_COUNT("VBAK","_CEL_O2C_ACTIVITIES"."USER_TYPE"

00
D
Level 1
5 years ago
J
Level 2
jelmer.bodeLevel 2
asked in Data Ingestion & Infrastructure
Add manual activities

Hi, I am looking for a possibility to add extra activities in the data model. We connected our Oracle data in the data model and have based on that data our activities. We have a system that is related to the Oracle data, but we can only add the data manually. Now I am looking for a way to included those event logs in the proces explorer, by add and connecting manually added activities. Is this possible?

00
J
Level 2
5 years ago

Badge winners

  • Value Assessment Expert
    anton.schmihas earned the badge Value Assessment Expert
  • Qualified to Prove Celonis Value
    anton.schmihas earned the badge Qualified to Prove Celonis Value
  • Value Realization Expert
    omar.alminhas earned the badge Value Realization Expert
  • Qualified to Manage Change and Scale Adoption
    omar.alminhas earned the badge Qualified to Manage Change and Scale Adoption
  • Celonis Technical Expert
    diego.zacarhas earned the badge Celonis Technical Expert
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2024