Product Q&A

I need help with a formula.COUNT (DISTINCT CASE WHEN EBAN. LOEKZ = X THEN EBAN. BANFN ELSE NULL END)ORCOUNT (DISTINCT CASE WHEN EBAN. BSMNG! = 0 THEN EBAN. BANFN ELSE NULL END)ORCOUNT (DISTINCT CASE WHEN MATCH_ACTIVITIES (NODE [Banf ist erledigt]) = 1 THEN EBAN. BANFN ELSE NULL END)Here I would like to make a case distinction.The formula doesnt work that way. There is an error.I want to count my requisitionif eitherLOEKZ = XORif 2. BSMNG is not equal to 0ORif the activity Banf ist erledigt is in the activity table.It is only important that the BANF is counted only once.That means that the BANF should have all 3 characteristics, so only 1 should be counted and not 3.I hope I can get this through DISTINCT.Thanks

Hello, I would like to create a create a backlog KPI. (per week, calculate the amount of cases closed this week minus the amount of cases created this week) Creation date & close date are stored in 2 different fields of 2 different tables. (cases creation & closure are not actually part of the process in itself). At the moment, I can create 2 column charts: 1 chart with dimension = creation week and KPI = Count of cases1 chart with dimension = closure week and KPI = Count of cases I fail to merge this into 1 single chart, with dimension = fixed weeks and KPI = (Count of cases where closure date matches with the fixed week - Count of cases where creation date matches with the fixed week) Is there a way to do this, in the Analysis EDIT mode or through data-model configuration in HANA? I hope this was clear enough for you to be able to support me Thank you for your help, Best Regards Robin

Hi,Im searching for a solution (coding statement example) to identify O2C cases where the same activity was executed multiple times but in different posting periods, e.g. in a third party sales the posting of the statistical goods receipts.The cases where the activity Im interested in was executed multiple times can easily identified viay the process flow selection: activity Post PGR is anytime followed by Post PGR, but how to achieve a single row which identfies the orders where this activity happened for different posting periods. As the timestamp (e.g the month) of the activity doesnt necessarily equals the posting period Ive already added the posting period to the activity table. Does anyone can help me with this, ideally I want to show in the analysis the first or last posting period together with the case key ?CheersChris

Hello, How to calculate the sum of 2 single KPI components which are using the same function to provide the result but with different filters, and the filters are also using different tables to get the filters.

Were trying to create a chart with a line per year (e.g. KPI x in 2019, 2018, etc.).In Celonis this means adding one KPI per year. (if not, please advise how!)How can we easily filter the data within a KPI definition, for instance like such (which didnt work obviously):FILTER YEAR(table.column) = 2019; KPI_X()Our current approach is to extend KPI_X with a parameter (Year), which is used as a filter in a CASE WHEN statement within the KPI_X definition. However, it feels like a complex solution to a simple problem. Hence this sanity check question, whether were overlooking an easy route.BTW: were on premise, version 4.5

Hi Team, I have a case management process which i have divided into case creation, case resolution, case closure etc. I need to run separate conformance models for all of these by applying a crop selection filter across each stage. In my reference model I have an activity(B) that can happen either before or after Activity(A), both the sequences are valid, However my crop selection for setting the scope of the phase is starting from Activity (A) which is ignoring the cases where Activity (B) has happened before(A). Is there any way to include those cases as well by making changes to my reference model rather than whitelisting them. Thanks in Advance.

When you upload your XES file using the Snap quickstart and you see something similar to the following screenshot image1272716 52.7 KB then most probably your XES file is missing the global attribute. For instance this is a file that does not have the global attribute and we will have the same problem. image744469 41.5 KB What we need to do here is to add the following global attribute <global scope="event"> <string key="id" value="string"/> <string key="org:resource" value="string"/> <string key="concept:name" value="string"/> <date key="time:timestamp" value="2017-01-09T09:49:50.000+01:00"/> <string key="org:role" value="string"/> </global> including the columns that we can find from the event attribute to our XES file. We can open the XES files with text and after adding the global attribute its gonna look like the screenshot

Hi, How would I write a filter on a table to show all activities preceding a specific activity, along with the frequency? Basically, what the process explorer fullscreen analysis shows.

Hi all. Is there an option to format the 1st column in a Pivot Table (dimensions) ? When it comes to drill down to more dimensions or the text in one dimension is > 25 characters is not readable (e.g. using small size 13px)

Hi all, Were trying to create a PivotTable where the cells show the numbers in a % of the column total. Roughly something like this: Category 1 Category 2 Category 3 2018 75% 50% 5% 2019 20% 30% 15% 2020 5% 20% 80% However, were uncertain how we can calculate a total per category to use for the % calculation. All ideas or tips are welcome!

Hi everyone,I need a KPI in a form:if X then Aif Y then Bif (X or Y) then (A+B)else null end;As I want to use it in an olap as dimention (first column) where the other KPIs deliver values for A,B and A+B, it is is not the optimal solution to split it into two tables (looks not good).It seems for me, it is not possible to use CASE WHEN as it uses ELSE after the first condition and automatically excludes the A+B.Do you know if there is a solution?Best,Maria

Hello everybody,I need your help.I have to calculate the throughput time of my requisition.In Table 1 (EBAN) I find the start date (Lieferdatum).Since a requisition can have multiple positions, I need the earliest date (PU_FIRST?).In Table 2 (Actiontable) I find the end date.Here I need the Bestellnummer activity for the purchase requisition and the last date of each Bestellnummer (PU_LAST?).I hope someone can help.The photo serves as an example.image1020472 24.9 KBgreetings

Hi everyone, i was wondering whether it is possible to include multiple similar KPIs in one histogram ? how many days since a)activity a till now b) activity b till now. Best Maria

Hi all, Currently we have an IBC license with a couple of processes. However, it would be very useful for us to have a place to sandbox new ideas and use cases, also for other business units. Unfortunately the IBC license has no room for that, but luckily we have Celonis Snap. The only problem there is that security is not very happy with the lack of user and data control. We are curious how other companies deal with this issue. For us, it would be very helpful to have a hybrid solution in the future. In this case, every IBC user automatically has a Snap instance, with the user management and audit tools from the IBC for instance. We would love to have a discussion about your solutions and the product possibilities! Bests, Jan-peter

I am trying to create a filter for the action engine, that filters out cases, where CHANGED_FROM attribute of a change order quantity activity has specified value (<1). Important is that this attribute CHANGED_FROM is maintained also for other activities, but these values are not relevant for me. First I did just two separate filters: Cases include change order quantityCHANGED_FROM <1 But the second filter apparently looks also at other activities, so it took some of the not relevant activities, which gave me false positives. How can I configure that filter that it really only looks on the value of CHANGED_FROM of activity change order quantity? Thanks a lot in advance

Hello, Is there a way to change data row extraction limit in data jobs in Celonis Cloud. Only 100 first line are displayed in output. Thank you in advance

Hi , I would like to build a Overview where I need to have the count of Activity on header level for different dimension. For Example: I want to have a Olap table as per below. Column 1:Plant Coulmn2: Number of Purchase order header. column3: sum of Count of activity for these purchase order at header level. This is for P2P use case. Where few activities are at header level but the use case is built on item level. So the count get multiplied by the number of item which I want to avoid.

I need to filter my analysis by a specific value of a specific activity attribute. I.e. I want to only show cases when the attribute CHANGED_FROM of an activity change quantity is <1. The point is that other activities also have this same attribute, but these cases are not relevant for my goal. thank you very much in advance for the advice!

How do platform updates affect previous versions of the software?, or if have an Analyzed process in place on a lower version of the software and then i upgrade the software, will my process works smoothly on new version also?, or do i need to make changes to the modeled process ?

Hi, We have several activities which have the same sorting and same event time. Is there a possibility to change the sorting of the activities in Process Explorer in the front end Celonis ? Best regards Adam

Hi everyone,Im curious if there is any other possibility to force the order of the dimension in a chart instead of putting a) / b) / in front?And if not, is there a possibility to make a)/b) transparent or change text colour? I tried some HTML statements but without success.Looking forward to your feedback.p.s. I only found this thread, where the solution with a)/b) is suggested: Sort chart by hidden dimension Analysis Hello Team, a quick question: in Celonis chart components is it possible to perform sorting on the dimension which is then hidden? In OLAP we can hide the dimensions, I dont see such option for example for column chart. In our case we want to sort payment terms with their due date from earliest to latest (so 00 is due immediately, 30 is due in 30 days etc.) But now we need show a combination of payment term and this additional number with days). [image] Best regards,David

Hi Team,We are trying to build a dashboard to monitor our Conformance modules across analyses. We want to see in an OLAP table, the throughput times or the longer by/shorter by timefor each of the violations.Is there a way by which I can use the Conformance formula to find the throughput time for different violations in an OLAP Table? Right now I am successfully able to pull the list of violations using the readable command on the Conformance formula using Petri nets. However, the throughput time I add to the table is different from the ones that I see on my Conformance Module.Please let me know if that is possibleThanks in advance

Hi Team, We have two project folders (example- P2P and Master Data) but data required in few analyses is available in the same data model (P2P_DM). Is it possible in Celonis, to create two project folders but they share the same data model? Note- I do not want to create a copy of P2P_DM because it is very huge in the size Regards, Amogh

Dear Experts, Hope all are doing good and keeping safe and healthy. I am about to start working on an analysis for assessing the efficiency of an R2R (Month Close) Process. It will be my first analysis and wanted to go through any analysis some one has done on Celonis already (if any). Insights and best practices can be leveraged for a quicker and quality analysis and deliver better solution/actions. Yout advise and guidance on any front will be highly appreciated. Regards@dinesh.kumar35

In file uploads option,TIMESTAMP couldnt choose any data type other than string format. If selected [data and time]or [integer] format it is showing exception. How to solve it ?