Product Q&A

Hi!Im trying to calculate how many cases have a certain activity less or more than X times, etc.I have this table A which shows number of cases that have a certain activity, and total sum of this activity. As you can see, the activity is repeated many times in a few cases.I want to separate in ranges, Im using this formula but I get the total number of activities and not the number of cases. (Table B)SUM(CASE WHENPU_COUNT("_CEL_PS_PO_LINE", CEL_P2P_ACTIVITIES"."ACTIVITY<%=language%>)<=10 THEN 1.0ELSE 0.0 END)Could you please help me know what Im doing wrong?Thank you!Table ATable Bimage1044173 6.21 KB

Hello, We are running a number of Data Jobs, including Extraction and Data Jobs, can we get the alert of the log either successful or error message in our mobile. We are getting the data in our mail.

Hi all, How to change the team name on Snap? I saw under Team settings > Settings that it is possible to change the team name but it always roll back the change. In fact I have a team with my personnal name and I want to change it with my enterprise name. Could anyone help? Thanks Nico

Hello, I dont know why everytime I try to use the Process Explorer in my analysis I cant show the automation rate of the activities. Every time I insert a Process Explorer component it appears without the Automation KPI. I tried to set it up by myself in the Analysis Settings, Process Explorer KPIs but probably I dont use the right code Should I also include some formulas in Saved formulas & Variables ? If yes, which ones? Many thanks for your precious help

Hello,were using a formula to determine if only one specific field has been changed or if other fields have been changed as well.CASE WHENPU_COUNT ( VBAP, _CEL_O2C_ACTIVITIES."_CASE_KEY", _CEL_O2C_ACTIVITIES.CHANGED_FIELD = <%= Block_types %>) -PU_COUNT ( VBAP, _CEL_O2C_ACTIVITIES."_CASE_KEY", _CEL_O2C_ACTIVITIES.ALTERNATIVE_TREE = Change Management) = 0ANDPU_COUNT ( VBAP, _CEL_O2C_ACTIVITIES."_CASE_KEY", _CEL_O2C_ACTIVITIES.ALTERNATIVE_TREE = Change Management) > 0THEN Block OnlyelseCASE WHENPU_COUNT ( VBAP, _CEL_O2C_ACTIVITIES."_CASE_KEY", _CEL_O2C_ACTIVITIES.CHANGED_FIELD = <%= Block_types %> ) > 0THENBlock and other changesELSE Only other changes or no change ENDENDThe formula works fine, but if the variable <%= Block_types %> is changed to a different fields , the formula is not getting updated when used as a fi

Hello everyone,I have 2 activities, A and B and I would like to calculate the throughput between them. It can happen, that A and B appear multiple times but B always appear after A;so I am interesten in the pairwise calculation of the throughput time (and average of that).Example:F-A(1)-C-B(1)-A(2)-B(2)-N-A(3);In this case I need the average time between A(1)-B(1) and A(2)-B(2).any ideas?Best,Maria

Hello. I am wondering if Celonis has exam simulators to practice before one seats for a certification exam. I think it would be very useful. Thanks.

Hello, I am getting the error message could not locate column in table while reloading the data model. However, the column is in the view, I have checked if I am using the correct source table and if the columns are synchronized (all ok). What else could be the root cause of this error? Thank you. Kind regards, Lenka

Dear Celonis Team, were currently working on connecting a Sybase ASE database via the IBC Uplink Connector. Weve noticed, that the configuration of the tables in the extraction in some times takes ages. In the extraction configuration, clicking on a large table with lots of rows the settings pane for that table (like filter settings and column selection) takes minutes to load or doesnt load at all. Turning on the Debug Mode for the extraction reveals why that is. Looking at the log files on the uplink server, the following lines apper once I select a table in the IBC frontend: 2020-07-22 15:33:21.777 INFO 4508 --- [ol-2-thread-105] c.c.c.j.s.DatabaseConnectorService : Metadata source being used is DRIVER_METADATA --EOM-- 2020-07-22 15:33:21.777 INFO 4508 --- [ol-2-thread-105] c.c.c.j.s.DatabaseConnectorService : Calling DatabaseMetaDataService#getMetadata for table dbo$_CELONIS_wo_transfer --EOM-- 2020-07-22 15:33:21.777 INFO 4508 --- [ol-2-thread-105] .c.c.j.s

Hello Team, Im creating a new Table in one of the Transformation Tasks of my data job. While creating the table, I want to define the primary keys. Can you please guide me, how to do that. Thank You in advance. Warm Regards, Jayanta Borkakoti

Hi I am Having Enterprise Trail Cloud, when iam giving my Credentials it is showing me Invalid Credentials . Please help on connecting it .Thanks

Hi, I am trying to solve a case. How to count numbers (MAX and MIN) of events in single KPI. Need to know how many events take on one user. I have two users. They have different numbers of events min 1 and the other one max 20. I need to make a count of events per user to get max 20 in single KPI. I tried to use a standard KPI maximum events per case but it is not what i need. 2020-07-30_12-57-17769203 9.74 KB

Hi, we are developing a usecase in which we want to automaticaly import a csv / excel on daily base from a fileshare. Until now we have only worked with scheduled databse connections or manual file upload. Is there any possibility to automate a daily csv import into a datamodel? kind regards Benedikt

Hey Guys, I had a quick question about filters on Pull up functions. I am trying to create a dashboard that displays Sum of spend by vendors. But i do this by Pull up function (because I use it as a dimension to categorize). I know we can put filters on the pull up function PU(child table, parent table.column [,filter expression]). My question is can we put more than one filter in the expression? I want to be able to filter for the month and year. I was able to filter for month but couldnt filter for year. Is there any way to put filter for year and month in date format ? Because I want the user to be able to input year and month to display information

Hello Everyone,I would like to create a table that list all the variants and then for each variant calculate how many unique activity there is.example,Variant acitivity countstep1,step2,step3 3step1, step3 2thank you for your help.regards

Hi Team,This is my first post. Please let me know if this is not the place to post a question like this. I need help with a statement.I want to know how I can convert this statement: max("_CEL_AR_ACTIVITIES"."_CELONIS_CHANGE_DATE") to a timestamp in CST. I have put this in a text component.The statement above works, but I have to keep telling my users that take that time and minus 5 hours. It always causes my team to break for a second and do that math, :).I would like it if I can just have it converted to CST if possible. Thanks in advance.Paresh

We are working on an issue where we would like to list the lowest order number activity within a certain case key, within a certain change number. E.g. picture attached might clarify the situation a bit more. We want to do this in the front-end (the dashboards) of Celonis.

Hi everyone, I am fairly new to Celonis. We have the O2C process loaded (SAP ECC), with, as I understand, more or less standard activities defined. Now, one of the business stakeholders asked me if we can add pricing data. In particular he would like to have the data from Conditions tab of the Display item details: Active / Condition type / amount and so on. As far as I can see the data there is coming from KOMV, which is a so called structure. Do I understand correctly that loading such a structure directly to IBC is not possible? Or is there a way? Thanks a lot Masha

Hi everyone, I need to create a drop down that will allow me to filter cases shown in the analysis by the value of a specific attribute of a specific activity. In particular: I need to filter cases where activity remove billing block was performed either by user type A or B. Process O2C in SAP, if that is important. Thank you very much in advance Regards Masha

Hello, in our analysis we have a lot of sheets. On every sheet is the same navigation pane (various components like button, dropdown and so on) At the moment, we have to maintain/edit the navigation pane on every sheet. Better solution 1: Select all components of the navigation pane and set a new option Grouping. After grouping the components to one big component set to new option "show on every sheet. Better solution 2: New sheet-type Background sheet. All components on the background sheet are visible on all sheets who have assigned the background sheet. Kind regards Thomas

With a button action it is possible to show a message box. This should also be possible as a configurable right click action. So we can provide users with help on KPIs and keep the design clean (no buttons) right_click968443 33 KB

Hi, Celonis Community! I am calculating the time between events for employee as: demension1 SOURCE (20_DOCS_EVENT. EVENT, CASE WHEN 20_DOCS_EVENT. EVENT = event1 OR 20_DOCS_EVENT. EVENT = event2 OR 20_DOCS_EVENT. EVENT = event3 OR 20_DOCS_EVENT. EVENT = event4receive OR 20_DOCS_EVENT. EVENT = event5approve THEN 20_DOCS_EVENT. EVENT ELSE NULL END) demension2 TARGET (20_DOCS_EVENT. EVENT) and filter FILTER SOURCE (20_DOCS_EVENT. EVENT, CASE WHEN 20_DOCS_EVENT. EVENT = event4receive OR 20_DOCS_EVENT. EVENT = event5approve THEN 20_DOCS_EVENT. EVENT ELSE NULL END) = event4receive; FILTER TARGET (20_DOCS_EVENT. EVENT) = event5approve; demension3 20_DOCS_CASES.EMPLOYEE KPI AVG(HOURS_BETWEEN(SOURCE(20_DOCS_EVENT.EVENTTIME), TARGET(20_DOCS_EVENT.EVENTTIME))) This calculation works, but it calculates all days, how can I count only working days?

Hello Celonis team, In IBC Process Analytics, Is it possible to hide or unhide an analysis or even entire workspace ? Over time with continues development of analyses in IBC, workspace might be crowded, and Its getting more and more difficult to the right one to continue work with.Also, sometimes when an analyst present some analysis to the audience, she or he may not want to show all of the analyses to avoid confusion etc. So, is it possible for analyst and admin to hide and unhide analysis/workspace based on proper authorizations? Thanks, Denny

Hi folkshow to define a1 tabLe and N table in pull-up function. I mean which table belongs to a1 and which table belongs to N. I just wanted to know the definition of a1 and N table.as its creating confusion. As I am new in celonis.Folks you help will be appreciated.Best RegardsInder Mehta

How to analyze your SAP Supply Chain in Snap The Supply Chain Quickstart is the first step of your process mining journey with Celonis! With just a few clicks you can learn how to optimise your finances in regards to your supply chain. Simply export the relevant data from your SAP system to start your analysis. In order to use this Quickstart you need to request the Supply Chain SAP extractor first to export your data from you SAP. This is applicable only for: SAP ECC 6.0 or higherS/4 Hana on-prem How does it work? First, navigate to SNAPClick the New Analysis button 1.11920970 175 KB Choose Supply Chain 2.21918968 126 KB Extract data from your SAP system In order to visualise your process, you first need to extract the relevant tables from your SAP system: Enter the company codes you want to analyse and request your Supply Chain SAP extractor (ABAP report)You will receive an email with the Suppl