Product Q&A

Hi All, As example reflecting only 1 specific SO, we currently have the following situation: All deliveries/billings from SO line items 10, 20 and 30 have a date in Q1 or Q2, whereas the date of the delivery/billing related to SO line item 40 is in Q3. Only Q1 and Q2 data is loaded in Celonis, so the delivery/billing related to item 40 is not yet loaded. Now wed like to calculate the total billed quantity for this specific Sales Order. As expected, PU_SUM(VBAP, _CEL_O2C_CASES.INVOICE_QTY) returns 40000, 40000 and 31600 for so lines 10, 20 and 30 respectively. However, if we want to aggregate over SO instead of SO line item and use PU_SUM(VBAK, _CEL_O2C_CASES.INVOICE_QTY), it returns 120000 whereas we only expect 111600. Any idea whats causing this sum of 120000 and how it can be solved to show the aggregation on SO level of only the loaded delivery/billing documents? Thanks

We have a data structure with case, activity, customer and contact tables.A contact is linked to a customer (N:1),A customer is linked to an activity (1:N),An activity is linked to a case (N:1).A case can be executed for multiple customers, hence this relationship structure of customers linked to activities.The challenge/question is to count the number of contacts for a customer of a specific case.Bonus challenge: only select those contacts that fall within the case runtime (which are attributes in the case table).The problem were facing is the famous no common parent between tables could be found error, and we believe the even more famous PULL UP functions could help us, combined with a DOMAIN_TABLE possibly. However, the relationship is such that we cannot just access a parent or grandparent table, but need to go to the parent (case) of a sibling table (activity) of our child table (contact), through customer which is our direct parent.In our example Customer is the parent table of b

Hi All I would like to limit the scope of an anylsis by filtering some company codes in a load script. I have create a variable as text replacement in which I have put the list of company code: Variable Name= ShopCC TexT/Replacement= CH01,IT13,FR02,FR08 the load script is FILTER EKPO.BUKRS IN (<%=ShopCCode%>); Unfortunaltly I get an error saying that there iwas a syntax error in the load script. Any Idea please ? thank you

In a KPI card, I would like to display only the activities that occurred for that KPI for the last 90 days. I know the below is incorrect but logically it is as close as I can get without help. FILTER _CEL_P2P_ACTIVITIES.EVENTTIME BETWEEN TODAY() AND (TODAY() - 90) The KPI card works so I am looking for the code to tack onto to get the 90 day window. Please advise! Thanks.

Hello, Is it possible to create a stacked bar chart with Celonis ? Thank you for your help, Regards Robin

Im having some trouble understanding how the built-in Number of process variants KPI is calculated. I dont understand why these two statements are not equivalent. KPI("Number of process variants") versus COUNT( DISTINCT VARIANT( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" ) ) image.png900323 21.4 KB

Hello all, In the PQL Editor an output of my formula is shown in the preview. If I then go to Done and want to look at the table, I get the following error message could not find referenced aggregate COUNT(DISTINCT ). Can anyone help me? I use the PQL formula: KMEANS() in its complex form. Best Regards, Patrick 01 Preview.jpg2156449 64 KB 02 result.jpg1383276 20.7 KB

Hi,I am trying to calculate payments terms in an Accounts Payable Analysis. Right now, my formula is:SUM((CALC_THROUGHPUT(First_OCCURRENCE[Vendor Creates Invoice] TO Last_OCCURRENCE[Pay Invoice], REMAP_TIMESTAMPS("_CEL_AP_ACTIVITIES".EVENTTIME, DAYS)))*(BSEG.WRBTR))/SUM((BSEG.WRBTR))Is it appropriate to do calculations combining BSEG and CEL_AP_ACTIVITIES Table? I would be curious to know if there is a better way to do this.

We are not able to edit any out of box analysis like Conformance checker, Social Analysis etc. We would like to use some of the components / formulas from these analysis into our single analysis for the users. How can we achieve the same?

Hi,I am trying to create a table that will show me which vendors operate in two different markets one of them being Spain. Some of vendors will be listed more then once in the market thus making the pull function a bit difficult to use I believe.Not sure where to go from here but Ive been trying different codes with no luck.Case when Cases.VendorName = Cases.VendorName AND WHEN Cases.LocalMarket = Spain AND Cases.LocalMarket = % THEN Cases.VendorName ELSE NULL ENDPlease let me know.Anna

I would like to open a reference document contained in the File Upload Center using a button. I cannot figure out what the Document ID is though. Any variation of ID that I enter results in a 404 error. Where must/can the document be stored for accessing? (I assume its in the file upload of the Event Collection)Where do I find the Document ID?Please advise if I am way off and there is a cleaner way to do this. Thanks!

A few months ago it was mentioned that user/analyses stats and usage would be coming to the IBC. From the SaaS hosted version, this information is available and it would be nice to see this implemented in the IBC. Any update on this?

Hello, Can someone please help with table loader pool types? What is difference? Impact on data load? When and which type should should be used? Thank you in advance! KR, Kalpesh

Hi all, We are using a dedicated Segregation of Duties dashboard to analyze cases where two activities are processed by the same person (e.g. Creation of PO and Releasing the PO). In this dashboard, the viewer selects two activities, which shall not be performed by the same user to see in how many cases there is a violation. See here the PQL statement: avg (case when PU_first(EKPO,"_CEL_P2P_ACTIVITIES".USER_NAME, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = <%=From%> AND _CEL_P2P_ACTIVITIES.USER_TYPE <> B) = PU_first(EKPO,"_CEL_P2P_ACTIVITIES".USER_NAME, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = <%=To%>) then 1.0 else 0.0 end) * 100 By checking the violations in detail, Ive recognized that there are cases where Person A creates a PO, Person B approves the PO and afterwards Person A changes some field in the PO (e.g. Net Order Price). Due to this change, the release indicator is AUTOMATICALLY changed from B (release) to R (not released). This case is shown as a viola

Hello Celonis Team, is it possible to use celonis on iphone or ipad? Could you give me some information about the mobile view from celonis. Many thanks

I am trying to convert the data present in an OLAP table to a dataframe.c = get_celonis(**settings)w = c.workspaces.find(KPI Analysis - CSAT,None)a = w.analyses.find(CSAT Model,None)q=a.published.components.ids[7ae951ac-b933-4e62-b8c0-ee21e6a15845].dataCan anyone please help me what can be the command to convert q into a dataframe.Thanks!!

Hi, I would not use VBAP.NETWR_CONVERTED and have the Net Value Order in the Document Currency. When I insert as KPI VBAP. NEWTR, I would like to insert in Units the Document Currency. I tried with: VBAP.WAERS<%=VBAP.WAERS%>a variable : VBAP.WAERSa variable : {VBAP.WAERS } But it is not working. Any idea ? Thank you

Dear Community, We are trying to understand the Data model status option Reload all partitions. We have tested this option with one data model and the data model load completed and the remaining data models load not started automatically. Could anyone explain this option Reload all partitions! data model - reload all partitions.png1588506 40.7 KB

Hello, I would like to create a table with a count of variants by Company Code but when I use the standard KPI Number of process variants, the number not corresponding to the total I have on the Variant Explorer. Is it exist a simple formule to count the variants? Thank you

We have seen that there are some of the KPIs which has to be recreated in different analysis , may be becuase of data security. Role based access etc. Wouldnt it be nice that we have an App as Global KPI where we can drag and drop the KPIs which are used in different analysis and control where we would like to manage it. With that, any changes done to KPI is reflected across different analysis. This removed redudance of work, eliminates human error. Also managment dashboard and operation dashboard has the same calculations of the KPI.

Hi All, Do we have any use cases for Application Monitoring tools such as Dynatrace. Can we get a process-level view with metrics of applications to see which application/interface is down because of which the process has stopped ( in real-time ). Regards, Rakesh Paul

Hello Celonis Development Team, Thank you for developing such a fantastic product. . I am a big fan already. Please share your opinion on having the following new features: Button - An option to show or hide one or multiple components. This will help us use the space for more innovative analyticsButton - An option to change the chart type of an existing component.Charts - The Series color mapping - options are limited and apply to all the series points. Instead, we should have a free code window wherein we can put codes to calculate color thresholds.The grid to put any component on the screen should have small steps giving freedom to arrange components more aligned. Thank you Regards, Sachin

Hello Community,We are developing a new algorithm to help users detecting duplicates.As an inspiration we toke the blog: Celonis 5 Steps to Reduce Costs Caused by Duplicate InvoicesCelonis customers have already saved millions by taking action on duplicate invoices. Find out how to how to use fuzzy matching to find duplicates and save money using the Celonis Intelligent Business Cloud and Python. We have noticed that the algorithm detects false positives. In the algorithm, this might happen because we do fuzzy matching and searching. Now the users like to flag these false positives in the sheet. Moreover, they want the flags they made to be visible for other users using the sheet. How would you implement such a flagging system?One idea we had was creating an additional column in the table that can be adjusted by users in the frontend. In this way, the adjustments could be visible for all the users. Does somebody have any idea whether this is possible?Happy to hear your thought

Hello everyone!Ive got some trouble with unique case aggregation. Ive got case table with column Amount, and events table with status of process. I want to build table wich consist of some columns from case table, avg timestamp between two activities, and sum (casetable.amount).So, I build filter on list:FILTER PROCESS EQUALS (X) TO (A) ;And filters on component(Table):FILTER SOURCE(Celonis_events.activity) LIKE (X) ;FILTER Target(Celonis_events.activity) LIKE (A) ;Next, i build table dimensions:CELONIS_CASES.BUNAMECELONIS_CASES.GJAHRSOURCE(CELONIS_EVENTS.ACTIVITY) - not visibleTarget(CELONIS_EVENTS.ACTIVITY) - not visibleAND KPIS of table:AVG(TARGET(REMAP_TIMESTAMPS(CELONIS_EVENTS.EVENTTIME, MINUTES)) - SOURCE(REMAP_TIMESTAMPS(CELONIS_EVENTS.EVENTTIME, MINUTES)))2)SUM(CELONIS_CASES.AMOUNT)All good, but if within one case we got more than one change status from (X) TO (A) activities - we got (CELONIS_CASES".AMOUNT)*(Count of (X) TO (A) ) and its wrong, because case got fixed amoun

Hello, I am trying to calculate the average number of posted invoices per user in a number component in the AP data model. The basic code of the KPI looks as follows: COUNT(BKPF.USNAM) / COUNT(DISTINCT(BKPF.USNAM)) The current KPI however does not yet show the real performace of the AP department because many invoices are posted via batch files or batch users and some invoices are posted by users that are doing an internship or an apprencticeship and these users do not post more than for example 100 invoices. In order to get rid of the cases which were posted by batch users, I used a component filter which works fine. But for the second issue (exclusion of cases which were posted by users that have not posted more than 100 invoices in the selected time range) I have not yet found a solution. I have tried several case when statements and also worked with ABC clusters to exclude the cases of these users, but nothing worked. Does anybody of you have an idea how this could be solved? I am