Product Q&A

Hi and welcome to the Celonis Family! If you are new to Celonis, this Community is the perfect place to learn from experienced peers, build your network, and find mentors. Feel free to check out our new Customer Onboarding Booklet attached!  Also, please note that we are running an onboarding webinar series for all new customers!Feel free to register for upcoming webinars or watch the recordings here:https://www.celonis.com/celonis-community/success-webinars/ Any questions? Just reach out to myself or any other celonis team member!

My activity table is having three columns ACTIVITY_EN, CHNAGED_FROM, and CHANGED_TO. Now I want to filter all cases which are ever passed through the Cancelled value in CHANGED_TO or CHANGED_FROM column. How can I filter these cases?

Hello everybody,I have the following problem. I hope you can help.I would like to use the component filter to hide the documents that have a clearing document.I have no idea for the formula.When I FILTER BSEG. AUGBL = then it only deletes the line for me, but not the entire receipt.Was a formula turned into a formula?Do I have to take GJAHR into account with the formula? Because the document in 2021 does not yet have a clearing document and should not be deleted.image779124 2.89 KBGREETINGS

Hi all, I have a problem uploading the BKPF.CSV file to SAP AP using the Quickstart option of SNAP. The file was generated with the extractor requested to the SNAP tech team. The message is: "The file cannot be matched to any of the required tables. Please make sure that the file name starts with the table name"SNAP_ticket_130414.pdf (288.9 KB) Attached is a file with screen captures Any hint? Thanks for your help. Luis

Hi, I want to select SUM of the top 3 cases based on their count in the single component KPI.I am using the INDEX_ORDER function to get index of each row, but when I apply the filter on analysis the count doesnt get changed. I assume it INDEX_ORDER is performing static in nature. How can I make it to dynamic. RegardsMukesh

I want to create a dashboard where user can input the data and on clicking the submit button the input provoded by user should go to machine learning script where the values are being used in the code.Is this possible with celonis? Please provide any documentation/code related to it.

Hello together, I want to use the standard Process Overview App to analyse troughput times and bottle necks. My process is the accounts payable process (paying bills). I could categorize my activities in: Data Log activites (performed activities by user or batch_user), f.e.: scan document, post document, forward documentCalculated activites, f.e.:reached discount period, reached payment period (based on the document date) These calculated activities are really important for the process analysis. However, they can be disturbing when analyzing the throughput time, because these activities dont affect the troughput time (they are just calculated). Do you know a sheet filter i could apply on the Process Overview App so that these activities are no longer taken into account? However, the cases themselves should still be included. Thank you in advance. Andreas

Hi everyone,for our development data model we would like to dive into our top X (e.g. 100) of open development projects in regards to their expected value. Currently I only know the function for an OLAP-table to show a limit number of rows. If we filter on certain areas/regions/plants this option remains, always showing the top X for the current selection. But we need additionaly KPIs above the table as:Total expected value of the top X projectsCertain Process-KPIs like (Average development loops per project) etc.Now Im searching, if there is any functionality to put a component filter or sheet-filter that we respect only the top X projects of the current selection.This might be interesting for everyone who wants to have a look/comparison within their top X cases.Best regards,David

Hi! I tried to look for any information on this in the Manual, to no avail, so I thought Id ask here: My client asked if its possible to filter the cases that meet the conformance model in the Conformance tab. We can see that its indeed possible to filter out the cases that violate the model - but we dont see an option to filter the correct ones. Is there any way to do this in Celonis? Thank you in advance, Filip

Dear Team, Is it possible to send extract of analysis (in excel) automatically to sftp or to some email on periodic basis? Regards. Roshan

Hello community,I am trying to build a table that will have a ranking of company codes. I use Celonis 4.5 on-prem. The company codes are my dimension. This ranking is based on the below KPI logic:CASE WHENMAX(WORKDAYS_BETWEEN(R2R.Tables::BSEG_KDAS.CAL_ID, R2R.Tables::BSEG_KDAS.LAST_DAY_OF_MONTH,(PU_MAX( DOMAIN_TABLE (R2R.Tables::BSEG_KDAS.ENTRY_DATE,R2R.Tables::BSEG_KDAS."_CASE_KEY"),R2R.Tables::BSEG_KDAS.ENTRY_DATE)))) = 3THEN 1WHENMAX(WORKDAYS_BETWEEN(R2R.Tables::BSEG_KDAS.CAL_ID, R2R.Tables::BSEG_KDAS.LAST_DAY_OF_MONTH,(PU_MAX( DOMAIN_TABLE (R2R.Tables::BSEG_KDAS.ENTRY_DATE,R2R.Tables::BSEG_KDAS."_CASE_KEY"),R2R.Tables::BSEG_KDAS.ENTRY_DATE)))) = 4THEN 2ELSE NULLENDthe above statement works as expected, however i need to include another variable where it also checks for the time stamp.I have tried the below statement, however am receiving an error message saying An aggregation is not a function.Can you please suggest a solution that incorporates both the max day

Hi I need to exclude the holiday dates from my activity table Event time column . Can anyone help me on this .Thanks

Hi , I need to calculate throughput time for some activities which are stored in variable. Can anyone help on this ASAP

Hi, I am using a combination of Import from Database for the Cases & Activities tables with Import from File third file (an Excel file with a primary key connecting to the Cases table). This works perfectly, as expected. However, after a couple of hours, all my Variant & Process Explorers stop working with the following error: Undefined exception occurred. Could not open swap file: 7e2f96 Clicking Reload from Cache in the data model resolves this, and the dashboard works again perfectly. But in another few hours, it breaks again with the same error. Im wondering what could be causing this error, and it its perhaps a known issue when using Import from File from Excel? It doesnt make any sense to me that it would work, then stop working with an undefined error, then start working again when the cache is refreshed (since the data doesnt change). Any advice is appreciated Thank you, Matthew

Dear all, We currently face an issue creating the data model for SAP SRM. We want to analyse the approval workflow for shopping carts in SAP SRM. Using tables like: CRMD_ORDERADM_H /SAPSRM/D_WF_000 /SAPSRM/D_WF_003 /SAPSRM/D_WF_008 /SAPSRM/D_WF_013 We currently cannot determine the right timestamp for each approval step. Therefore my question if somebody already implemented that topic to Celonis and wants to share the experience with the data model for SAP SRM. Thank you Matthias

Hi all, I want to have a dropdown button with the values 0 to 12, which I can generate using RANGE(0, 1, 12) however when I run/use the dropdown button it does not show any items. Is this supposed to work? (were running CPM 4.5) Kind regards, Joos

Hi everyone,I hope you can help me with my SQL Problem.I created the Table Cases and selected my Case Key and a specific filtering for Specific Type.The strange thing is that my output includes two lines but in my row data the conditions are matched for Text1.DROP TABLE IF EXISTS CASES;CREATE TABLE CASES AS(SELECT DISTINCTB.ID AS CASE_KEY,CASEWHEN B.EX = 5 AND B.VW = 4THEN Text1ELSE nextEND AS Specific TypeFROM Data AS B );SELECT * FROM CASES WHERE CASES.CASE_KEY =722OUPUT:CASE_KEY Specific Type"722 Text1722 nextDoes someone know how why I still get next as a output and how can I change the syntax to get sure to get out only Text1?

Is it possible to subtract minutes from a datetime and get subtracted datetime?

Hi - I have two tables ACTIVITY_1 and CASE_1. ACTIVITY_1 has different statuses of PO.Case_1 has all the distinct POs and PO Amount. Now I want to show the sum of PO Amount on each activitity on the Process Explorer. When I use a simple SUM calculation or PU_SUM calculation, it double counts the PO amount, if a PO has gone through an Acitivy/Status more than once. This is supposedly a simple calculation, but I dont seem to be able to create it yet. Can you help please?

Hello Team,We are trying to calculate the rework cases for activity in different approach i.e in column chart where we need if case key has executed more than once , twice or thrice for particular activity then each cases should be unique in each column logicfor eg:-More than once case keys executed should not repeat in more than twice column and same with thrice column.Below is the logic we are looking for to calculate the same but not able to get unique records .greater than 1 =Cases should not repeat in >2 and >3 columngreater than 2=Cases should not repeat in >1 and >3 columngreater than 3=Cases should not repeat in >2, >1 columnKindly let me know how best we can create the logic , awaiting for your response.

Hey everyone, I am looking for a solution for the following issue. I have a bundle of 5 different activities. I need to know the count of cases for every activity.The Problem is that more of one of the bundled activities can occur in one case. Therefore I would like to count only the last occurred activity in the bundle. The required activities can occur somewhere in the process flow.Example picture attached.bundle953551 57.8 KBIs there someone who can help me to solve this problem?

Hi everyone, Im trying to add a rework filter to my analysis that allows the user to choose between activities and how often they occur. Im thinking about something like this: select cases where activity occurs more/less than 1/2/3 etc. In that way we could filter down exactly onto those cases where Celonis identified rework. I just started with Celonis, so Im not sure how to start/implement such a filter so I hope I could get some help from the Celonis Community. Thank you very much in advance!

Suppose I am using PU_AVG function to calculate time between ticket deferred and ticket released activity for each case but in my scenario there are multiple combinations of ticket deferred and ticket released so, will it pick all occurance per case or not.

Celonis offers you a lot of features to share your success stories or achievements with other people. One of them is the so-called functionality Public link which allows you to share the published version of your analysis with this link. First, navigate to Process Analytics aaa11913935 256 KB Click the dropdown menu of the analysis you want to shareThen public link aaa21919931 74.7 KB Click Enable public linkClick Copy to ClipboardClick SaveEvery person who has this link will be able to use (not edit) your analysis. For example, this is my analysis that I share with you via this link: https://snap-er-ndrio-gmail-com.eu-1.celonis.cloud/process-mining/public/df45b38a-46d2-4b4c-9ec2-4fc2293c15a8/#/frontend/documents/df45b38a-46d2-4b4c-9ec2-4fc2293c15a8/view

Hello, I use a data model that has been working well for a long time. Data records are added at regular intervals (weekly). Now I got in a few components the following error message: No common parent between table could be found - please check your schema. The Tables [Table1.DATA] and [Table2.DATA] are connected, but have no common parent table. Join path [Table1]N 1![CASES]!1>N[Table2]. For more information on the join path, search for Join functionality in PQL documentation. I already checked the fields that are linked in the data model. [Table1.Data].[Field] = MULTIPLE keys [CASE].[key] = UNIQUE key [Table2.Data].[Field] = UNIQUE key I checked this with the following code: SELECT Field, COUNT(Field) AS Anzahl FROM Table2 GROUP BY Field HAVING (COUNT(Field)>1); Does anyone have an idea how the analysis of the error can be advanced here? Is it really only due to one of the tables described in the error or is it possibly due to a different table in the data model? Why is the tab