Product Q&A

Need to calculate time spent on Credit hold activity for order to cash process and populate a column of OLAP table but credit hold activity is denoted by 2 names in activity table 1)Set Credit Hold 2)Set Default Credit Hold.What should be the formula for thisI have used formula(CALC_THROUGHPUT(FIRST_OCCURRENCE[Set Default Credit Hold] TO LAST_OCCURRENCE[Release Credit Hold], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, HOURS)))But I need to put below condition as well for same column(CALC_THROUGHPUT(FIRST_OCCURRENCE[Set Credit Hold] TO LAST_OCCURRENCE[Release Credit Hold], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, HOURS)))

Is there an inbuilt process connector available in IBC for Success Factor- a Human Capital Management system

Dear All I am looking for a solution to calculate a KPI based on a condition I tried it with this statement but there is an error CASE WHEN EKBE.VGABE LIKE 2 THEN SUM(EKBE.WRBTR) ELSE 0 END)

Hi, Are there any process connectors, data model and analysis in healthcare domain or pharmacy related ?

Hi, I want to calculate the time spent by all users in all the cases handled by them in the ITSM background. Can you please help in the implementation of the same. An example of the problem is given below:- Case id Eventime Activity User 1 01-01-20 change priority A Solution should be like this:- 1 02-01-20 change severity A Time spent User 1 03-01-20 change owner A 3 days A 1 04-01-20 create action B 2 days B 1 05-01-20 execute action B 2 05-01-20 create ticket B 2 06-01-20 change priority B

Hi, I would like to merge this two filter togheter but I dont found the right formula : FILTER EKKO.BSART IN (ZNB , Z3P, ZTR, ZRS) and FILTER EKKO.EKGRP ***!= (995) with FILTER EKKO.BSART IN ( ZST , Z3P, ZTR, ZRS) and FILTER EKKO.EKGRP = 995 ; Thanks in advance.

The process flow for Accounts Payable has an activity called Due Date Passed. Does this mean that a vendor invoice is overdue? The reason of my confusion is because the definition provided by Celonis is Thereby Accounting that the invoice is paid on time before the due date passes. This is unclear to me. AP includes the following activities: (1) Vendor Creates Invoice", (2) Scan Invoice , (3) Enter in ERP System, (4) Book Invoice, (5) Clear Invoice (Payment), (6) Due Date Passed. I will really appreciate getting help on this

Hi Team, I am currently working on auto-assignment of the DBConnection to the table all at once in the front end via the python code. But i am not getting any functions which can help me with that. I am able to connect to the datamodel, fetch the table ,table data and change the table names too. The only thing i am lacking is to change the DBConnection of everytable from python. I could analyze from the data of the table fetched via python that each DBConnection has their own DBConnectionID , but i am unable to change that ID from python. Please let me know if that change is possible, if so, how to do it. Thanks in advance.

Hello, Good day. For OTC, we want have an OLAP with dimension: _CEL_O2C_ACTIVITIES.ACTIVITY_EN and KPI: Net Order Value (VBAP.NETWR_CONVERTED). The issue is that it is not giving the right value, especially when there are SO items that went thru the same activity more than once. For example, we have SO1 and Activity1, this SO has Net Order Value of 1 EUR and went thru the Activity1 3x, so the result of the KPI in the OLAP is 3x Net Order Value (3 EUR). We needed to output the correct Net Order Value (which is 1 EUR).

We have one SAP client connected already. Now we want to connect the second one, the same process (O2C). In this other client we have a separate business division, which we want to analyze separately. Current already existing analyses shouldnt be influenced by this new data load. We will probably also want to have some analyses to compare the business divisions, but we will definitely need to be able to easily create analyses separately. Will appreciate any guidance a lot. I will outline below my understanding and will appreciate comments to it. I understand that first of all we need to create the new connection. And from this instruction we only need to perform steps 1 and 6, because the server part is already there and it is not SAP client specific. Then, for the moment, since we have a data load running every night, I will add a filter on the case table (VBAP) to only take data from the first client (MANDT = CLIENTNUMBER). Because, if I understand correctly, otherwise with the next

In the grouping field, I am using ROUND_MONTH(EKKO.AEDAT) as legend, but in the chart, it is showing date format as grouping column . How can I change the format to YYYY_MM ?

Hello All, Anyone knows how to use and what is the benefits of using index sheets on front end analysis? I tried using and seems its scanning open requests but not sure how is it working? Thanks, Kalpesh

I need to perform something like the VLOOKUP in PQL. In particular, in my O2C_VBAK table I added a column EDIPartner, that pulls the EDI Partner number (EDPAR.KUNNR) for the concerned VBAK.KUNNR. Now, I want to make a drop down filter in my analysis, so that user can choose different EDI Partners, and I want him to see not only the number, but also the name of that partner. If I just write VBAK.EDIPartner|| - || KNA1.NAME1, then it will take the NAME1 of the VBAK.KUNNR. How do I make it take the NAME1 of the VBAK.EDIPartner?

Hi Celonis Community! I have a question about the ability to calculate the number of repeated actions for some indicator in my situation, I want to count how many refunds are made per document within each document creator field demension - the creator of the document (unchanged during processing) kpi fields 1 column - the number of documents that were returned 1 time 2 column - the number of documents that were returned 2-3 times 3 column - 4-7 returns and so on returns - the number of events Returned by the creator of the document I accomplished this task by making 2 tables. Highlighting the values I need in the upper graph and looking at the creators in the lower table is it possible to accomplish this using one metric? image693391 7.49 KB

While applying data permission for specific user I am getting the below error while accessing the analysis. FILTER DOMAIN: Incompatible expression after IN operator: Expected INT or compatible, but got [CONST_STRING]

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. So if we had a feature that would automatically convert these tables into an Event Log then it would l

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