Product Q&A

Hi Team,We are working with the conformance module in Celonis. I see an error msg popping in all my components saying that Your model contains duplicate activities. Activity A occurs in the model 2 times, Activity B occurs in the model 3 times Please try to create a model without duplicate activities as it may cause severe performance issueIn my reference model, I have used duplicate activities however they are a part of different sequence flows (e.g. two different paths after split using exclusive gateways) and also for some instances the activities can happen again in the sequence flow.Can you help me understand this error msg in detail and how exactly does it affect the performance issues?Thank you in advance!Soham Potdar

Hello, It would be great if the current view of an analysis could be exported to PDF. Different options for the required sheetsOption for an extra page that shows all filters & values in detail. pdf958374 28.1 KB

Hi Team, I am trying to use standard Three way match formulas from App store. It is showing the below error message: Pull-Up-Function could not be executed. Table EKPO is not a child of table EKBE. Use a non Pull-Up-Function instead. In the data model, the tables EKPO (case table) and EKBE are joined on the columns MANDT, EBELN & EBELP. Could you please suggest what could be the cause of the issue?

I added a new attribute (column) to an already existing column. I can see it in the schema: and if I try to write the code in a data job: But if I try to find it in the Formula editor in my analysis I cannot find it: Any idea what could be wrong? Thank you very much Regards Masha

The Snap team is always trying to improve the user experience of our users and simplify Process Mining in order to allow them to analyse more processes. In the past two weeks the only thing we could think of was: what if we could develop a feature that allowed our users to generate their Event Logs from raw data in an easy and intuitive way? This would eliminate the frustration of our users that they dont know what an event log is and where to find it. For instance, lets have a look on the data coming from a Service Desk Application and how can we generate an Event Log. Most of the times such applications consist of two main tables the Tickets and Ticket changes. Tickets table consists of columns such as: ID, Created at, Updated at, Commented at, User and Category. Tickets changes table consists of columns such as: ID, Status changed at, Assigned at, Deleted at, Department etc.

Hi Team,We want to visualize three KPIs corresponding to a particular dimension. We are thinking of achieving this in terms of the horizontal and vertical axis of a scatter plot (2 KPIs) and the third being the bubble size.I wanted to know whether there is a way to increase the size of the bubbles based on additional KPI in Scatter plot (other than the ones specified in horizontal and vertical data series) ? If not, is there a way to look at additional KPIs in scatter plot when you hover over the bubbles ?Thanks in AdvanceSoham Potdar

Hi, I tried to build an OLAP table with les champs suivants : CHANGED_FROM : _CEL_P2P_ACTIVITIES.CHANGED_FROM CHANGER_TO : _CEL_P2P_ACTIVITIES.CHANGED_TO OverDelivery: EKPO.UNTTO UnderDelivery: EKPO.UEBTO I would like to create an column with CHANGED_FROM * OverDelivery But I received an error message. How could I do this multiplication between those tables ? image71463 2.27 KB image790124 6.4 KB Thanks in advance.

Hi Team, Need some help about Bridge Chart. I tried to create a Bridge Chart with Dimension and Sorting as below: CASE WHEN DELIVERIES.RGK_DRRA>0 AND DELIVERIES.RGK_DRRC>0 THEN Late SL WHEN DELIVERIES.RGK_DRRA<-3 AND DELIVERIES.RGK_DRRC<-3 THEN Early SL ELSE Ohters END And the Aggregation is COUNT(DELIVERIES.DELIVERY_ID) But the sorting is not what I want, and the colors are all black. Could anyone help me with sorting and changing colors? Thanks a lot.

Dear Celonis Community I am trying to prepare for Accounts Parables an analysis which would show the cancelled invoices. in my process explorer i dont have a dedicated activity Cancel Invoice How would you ensure to show them, what specific filters would you apply? Thank you Tatiana

Hallo, I am looking for the operation guide for IBC Celonis. I have found the operations guide for 4.3 but nothing for the cloud. I am looking for the solutions for SSO, Monitoring Solutions, Version control etc. There are some help pages about SSO but really rudimentary. Is there any pdf/documentation where I can find the topics. Many thanks in advance. Greetings, Ula Jessen

I would like to see the workflow of 2 different task tables from SN in Celonis. The Case table and the case_task table. The issue i encounter is that the dimension Roundmonth (case record created) does a auto join for the case and task table (sounds logic). But all i want is a simple "excel"table to track the records. How can i show the trend of 2 different tables based on both their creation date?

As the title says, exporting a chart that scrolls to PNG only shows the area that is captured within the current window. Is there a way to have the exported PNG show the entire chart? CPM_OLAP_Table_20200902_152303|690x141

Hi to everyone, Im looking for info (links, books, Excel Models and/or counsels) about ARIBA Data model, for training pourposes. Im interested in Tables and Fields of the transactional Core in order to training a Model. Thanks in advance to anyone that could help Alfonso Fabra Nodotic (Spain).

Dear Community, Im currently working on setting up data permissions on IBC. They work as excpected, but that is somehow a"problem" as well. Heres an example of my data model: grafik835223 5.33 KB The two tables are linked via two columns, a company code and an event id. Additionally, the two tables have a 0-to-many connection, meaning that there can be cases without a connection to the events table, and vice versa. I want to set up data permissions based on the company code. As far as I understand (and validated during testing), data permissions are always AND connected, and the tables are always inner-joined This means, when I set up data permission on column cases.company code, I will not be able to see the events x,y,z, because theres no respective case for them. Vice versa, setting up data permissions on events.company code, the will not be able to see case id 4, because theres no link either. Setting up data permissions on both tables will not lead to any other result du

Hello dear community,when creating my event log, question marks appear unexpectedly in the ID column. This makes it difficult to write the code. Can anyone help me what this might be due to?Thanks for any help!!

Hi Team,We are currently trying to use round_week() function as a dimension. However, I see the function would aggregate the week values starting from Monday to Sunday as a week.Is there a possibility where I can represent the week to start from Saturday and end on Friday and aggregate the weekly values as per the same?Thanks in AdvanceSoham Potdar

Trying to create a KPI for my column chart, where I would count only those cases for which a specific condition is met. In particular, I want to count the number of SO Items (COUNT_TABLE(VBAP)), which were created via EDI (VBAK.BSARK = DFUE). Tried this statement, but getting an error: CASE WHEN VBAK.BSARK = DFUE THEN COUNT_TABLE(VBAP) ELSE NULL END Error: image77760 4.71 KB Dimension is ROUND_MONTH(VBAK.ERDAT) if that makes the difference. UPDATE: in addition, important that in the end I want to show on the same column chart also the number of SO Items that were created not with EDI. I.e. I want to have a stacked column that consists of all SO Items and I see the part with EDI and the part without EDI. Help appreciated! Regards Masha

In the OLAP I can see the particular field has null value, but selecting the same value resulting the OLAP to show no rows.

Hi everyone, I am trying to write a load script that would incorporate the below logic, and I am confused with the syntax. Will appreciate any advise. Analyzing SAP O2C process. Logic: If SO Item is for defined materials then this SO Items should be included without any additional filter. If SO Item is for any other materials (not from that defined set), then for those SO Items additional filter should apply. Materials that should go without filter: EDIDUMMY, ILODUMMY For every other material I want to exclude those where there is a reason for rejection: ISNULL(VBAP.ABGRU) = 1; I tried to write something like this, but after I try to save the script analysis keeps loading forever, so I guess something is not working with the filter: CASE WHEN VBAP.MATNR IN (EDIDUMMY, ILODUMMY) THEN FILTER 1=1 ELSE FILTER ISNULL(VBAP.ABGRU) = 1; thanks Masha

Hi all, I have a process with parallele sub processes. As Celonis doesnt display theses sub processes my idea is to remove the activites related to these sub process in the analysis. So how is it possible to easily remove activity in the analysis (keep all the cases with or without this activity but just remove the activity)? I could do that by removing the activity in my csv and reload it but I wanted to know if there is an easy way to to that in Snap (by exemple in using the Activity filter, but this filter will filter the cases and not remove the activity). Thanks all for your help Nico

Hello everyone, Im currently working on an analysis for viewers which is going to be exported as image, a stacked area chart in the date range of a year. Now to my problem: Their requirement is that every workday has to be shown in the diagram, so the dimension axis gets unreadable because of the amount of dates displayed: (part of the diagram with the date range of half a year as example) Is there any way to only display every second or third label on the dimension axis so it looks less cluttered and more readable? Ive looked through the component options but couldnt find anything related exept the tick count, but that doesnt help me for this case. Best regards, Nils

Hey all, I want to count cases where an article number is just present in one table but not in the other example TableV1 ArtNr 1 3 4 5 7 9 TableV2 1 2 3 4 5 6 7 8 9 10 Count cases which are in TableV2 but not in TableV1 (Null). In that case 2, 6, 8, 10 -> Count = 4 Thx and br Daniel

Hey pros, I want to upload lots of table with the same columns, like article number and price. To select which version/table should be analysed I want to setup a variable with the name of the table. Example: Currently COUNT(DISTINCT SupplierA_v10.csv.Teilenummer des Lieferanten) Should be something like that COUNT(DISTINCT " || <%= Name_Update %> || .csv".Teilenummer des Lieferanten) Do you have any ideas how to set this up? Many thanks ahead and br Daniel

Hi ,I would like to know if there are any provision to consolidate the date for the specific date slice to use in the dimensions . For Eg 5 days or 3 days custom grouping etc .I require the functionality similar to ROUND_WEEK() to group date but i should be able to group based on the custom logic of 5 days or 3 days etc for the date range .Thanks ,Praveen

Hi Team,In the ML workbench, we are trying to pull data of a component from a particular analysisThe code that we are using is not able to pull data from some particular analysis. However, if we use the same code to pull the data from a different analysis belonging to the same workspace we are able to pull the data.Are there any Analysis settings that we need to look into for the data pull that might be causing this error.We are getting the following error while pulling the data from the analysis.image571669 70.7 KB