Product Q&A

Hello Dear All,I am doing an analyze for a supplier companys inventory. The data-set is like this in the image below.Screenshot 2020-01-07 at 14.08.041495829 62.5 KBWhat I want to do is to determine the valuable products according to frequency and price rank. So, for this purpose I firstly aggregate the all products with price rank and created new column represent the frequency counted.Screenshot 2020-01-07 at 14.56.44435820 18.6 KBAnd frequency is calculated with this KPI: COUNT_TABLE(PM_Last.csv_CASES)And now I just want to apply a manual RFM algorithm to determine most valuable products. So, I need to use the values of this two column and create a monetary value in another column. For this, I just need to multiply the 2 column, such as the formulation that I tried COUNT_TABLE(PM_Last.csv_CASES) * PM_Last.csv.BuyPriceRankBut, I receive this error message : Screenshot 2020-01-07 at 14.12.45786133 9.82 KBI think, what I want to do is not complex but I couldnt find a way to use aggrega

Hi, I would like to create an analysis for three of our depts. together.The department is one of the characteristics of activities and the whole process is not only happens in those 3 depts of interest.If I use filter ACTIVITY_TABLE.DEPT IN (1,2,3) Celonis cuts all the activities that were performed in other departments. I am rather interested in all the cases that were ever touched by my 3 Departments no matter if some of the activities were performed somewhere else - the process should be shown completely.Thank you!

Hello, I have a question on how to filter a table with a dimension, and a aggregation. For example I have a olap table with: Dimension A | Count(Dimension) abc | 5 cde | 10 Now I would like to create a filter on top of this olap table and filter out everything that has a count of the dimension lower than 6. From the documentation regarding filtering I understand that I filter will not work, in this post I am looking for an alternative. https://zalando.eu-1.celonis.cloud/help/display/CIBC/FILTER I would appreciate any help on how to do this. Best, Paul

Hello to everyone who reads this! I think the solution of my problem could be pretty easy, but I dont get it I need to search for loops of each activity in my analysis which are directly followed by an specific activity. Every activity can loop and every activity can be directly followed by the specific activity. Basically the soltion should be something like this: FILTER MATCH_PROCESS_REGEX (Table1.ACTIVITY, variable >> variable+ >> XXX $ ) = 1 An activity (no matter if it is the first activity in the case or not) is followed by one or more occurrences of the same activity and is directly leading to the specific activity XXX. Yes: A - A - XXX Yes: A - A - XXX Yes: A - B - C - C - C - C - XXX Yes: V - W - P - P - P - XXX No: D - D - E - XXX No: F - G - F - G - XXX My problem is, I dont know how to insert a variable or something similar into this formula which is checking each activity in the analysis not only the hard coded one. It would be great to see the number of occur

Is there any way we can calculate average throughput time in the process explorer between activities in YEAR or MONTH I tried creating custom KPI but couldnt go through. Thanks in adv. -Amogh

Dear all,Currently we are doing some analysis on our O2C process. We are making use of a data model in which the delivery document line item is the central case_id in the case table. Attached to this case table are, amongst others, the earlier steps in the process (i.e. Sales Order data) as well as later steps in the process (i.e. Invoice data). A graphical representation for the analysis of 1 SO Line item (which contains 2 cases here) looks as follows:image909261 6.49 KBIn the above example, the specific SO_line 100 consists of two deliveries and two invoices (delivery line item:invoice = 1:1 relationship)In Celonis weve created the following overview for this SO Line item:image1168107 9.59 KBINVOICE Q is defined as PU_SUM(VBAP, _CEL_O2C_CASES.INVOICE_QTY)Besides, we have a date picker component to filter on billing date. However, so far it doesnt work as we hoped it would. The idea is that if we enter 01/01/2019 - 31/12/2019 as date range, only the first billing document (Dec 20th) i

Hi everyone, I am looking for an OLAP table which can show multiple KPIs (MODUS, MEAN, TRIMMED MEAN, QUANTILE) of the throughput time between activities. The business use case is to have a comprehensive overview of the real throughput time from Celonis in order to compare these values with the current master data settings in the operating system. Celonis - OLAP Table743229 38.2 KB The first row is showing the overall throughput time of the process from the first activity (A) to the last activity (D) (e.g. from customer order is received until product arrived at the customer. In the rows below I want to check the throughput time of the individual process steps. For example, activity A (start pick&pack) to activity B (complete pick&pack)) Question 1: How can I show in the first columns the two activities I am interested in? Question 2: In addition, how can I add an individual line like illustrated as Bottom Up SUM Question 2: How can the MODUS be calculated? There is no PQL fun

Could you please help with a question about using R in celonis? I only start to use function such as RCALL and RAGG. My analisys requeres work with dates and time, so I have to use datetime types and test this with the following code: *RAGG(v_oa_cases.number AS x, * as.POSIXct(2019-01-01 12:00:00) ) This gives an error: No result value in R script execution. Same as specifying the format in as.POSIXct. What could be the problem? Could somebody help with the suitable options? Thank you

Hi,I am currently working on getting the Manual Delivery Rate?What do i need to modify on this code that is currently getting the On-Time Delivery Rate?100.0*AVG(CASEWHEN ISNULL(<%=DUE_DATE%>) = 1 THEN NULL No ConfirmationWHEN ISNULL( PU_LAST("VBAP",ROUND_DAY("_CEL_O2C_ACTIVITIES"."EVENTTIME"),"_CEL_O2C_ACTIVITIES"."ACTIVITY_<%=language%>"='<%=record_goods_issue_activity%>') ) = 1 AND DAYS_BETWEEN(<%=DUE_DATE%>,TODAY()) <= 0 THEN NULL --'No GI and Future Due Date' WHEN ISNULL( PU_LAST("VBAP",ROUND_DAY("_CEL_O2C_ACTIVITIES"."EVENTTIME"),"_CEL_O2C_ACTIVITIES"."ACTIVITY_<%=language%>"='<%=record_goods_issue_activity%>') ) = 1 AND DAYS_BETWEEN(<%=DUE_DATE%>,TODAY()) > 0 AND DAYS_BETWEEN(<%=DUE_DATE%>,TODAY()) <= <%=TOO_LATE_BUFFER%> - COALESCE(<%=ROUTE%>*1.0,0.0) THEN NULL -- 'No GI

1- After you log in to your Snap environment. Go to team settings as it is shown below: image1915934 84 KB 2- Go to "Settings and then click Public in Team Privacy as it is shown below and then click save image1917934 63.7 KB Then click Enable open signup link and Copy the link to the clipboard and share it with the people you want to invite in your team. image1262632 41.5 KB

Hello,I am trying to create a dropdown filter, where users can select activities and get all cases which pass through these activities. I tried 2 versions:Using CASE WHEN and returning TABLE.ACTIVITY when it fits a certain pattern (with e.g. TABLE.ACTIVITY LIKE String%Example%). The problem here is that if I select any activity in the filter, my report is filtered just for the date of that activity and not the whole process chain. I.e. if I have a case that spans over 4 months, this filtering will only return that month when the activity happened.Using CASE WHEN with PROCESS EQUALS and listing 1 activity in each WHEN option. It looks something like this:CASEWHEN PROCESS EQUALS Activity A THEN Activity AWHEN PROCESS EQUALS Activity B THEN Activity BELSE NULLENDHowever this filter doesnt work with other filters and presents only 1 option. If I filter for some specific case which includes 5 of listed activities, this filter only allows me to select the first listed option. So filtering e.

Hi, In some cases, the calculation of certain KPIs has to be done using PU_FUNCTIONS. However, as these function do not consider the actual analysis filters, the values calculated might not be the expected. Although I agree that not taking into consideration the current analysis filters is quite useful, I believe that it would be a great improvement to have the possibility to consider also the filters. Best Regards, Bruno

Dear Community, is there a way to customize the CPM4 Help Page that you get, when you click on your user name and then Help? I mean this one: grafik897371 20.4 KB The reason is that we do not want users to contact the celonis help desk directly but see a company-internal e-mail adress and phone number that they can use. Thank you

Hi, Im currently looking for a way to create a scatter plot where both axis are representing a KPI. If I do this, only one point is shown, but I want to represent all customer as a point. Is there a way to get this done. Best regards Steven

Hi, I have a query relating to saved formula / dropdowns that are derived (i.e. using a CASE WHEN for example). I have an analysis where the dropdown has required updating but when published the updated logic is only applied when the dropdown is reapplied which makes sense. However, this also means that if the selection is made and the user reopens the analysis after the change is made that the view will not show the updated logic unless they manually clear and reapply the selection from the dropdown. A feature that used to exist prior to Celonis 4.5 where Selections could be cleared on opening an analysis either using the Analysis / Tab Load Script Clear Selections;. This forced users to apply filters. This would allow me to ensure that users are always making selections from the latest logic and not just viewing old selections that have not been updated. Despite the help pages suggesting this is possible Help Pages the error message Select is not supported anymore. Use Filter instea

Dears, Im trying to calculate Payment terms mismatch. For MM related Invoices,Payment terms should be equal to PO payment terms.For this motivation, Im trying to obtain the field EKKO.ZTERM to compare it against BSEG.ZTERM. But Im block because of no not have a common parent in the schema message.I try different approaches using pullout functions but Im stuck . Can you please advise? below the relations available and the error messageMy formula should look like something like this:CASE WHEN (EKKO.ZTERM)<>(BSEG.ZTERM) THEN NOK ELSE OK ENDI read that somehow this can be achieved through the DOMAIN_TABLE but to be honest I could not manage to get it. Below Im including a screenshot of the data model mapping.image1589721 136 KB

Dear Celonis community, we have built the following OLAP Table for our Automatic Order Entry (AOE) types. image1101180 5.54 KB We have two KPIs for that: AOE Header and AOE Item calculating either the ratio of the Sales Orders (header) or Sales Order Items (item). We would like to switch between the KPIs via the yellow highlighted dropdown. Clicking on the header item in the dropdown will fill a variable with the value header; same for item. My Formular for the column EDI % is: CASE WHEN <%= dropdown_aoe_header_item %> = header THEN (SUM(CASE WHEN VBAK.AOE_MAPPING =EDI THEN 1.0 ELSE 0.0 END) / COUNT(VBAK.MANDT)) WHEN <%= dropdown_aoe_header_item %> = item THEN (SUM(CASE WHEN VBAP.AOE_MAPPING =EDI THEN 1.0 ELSE 0.0 END) / COUNT(VBAP.MANDT)) ELSE NULL END I wanted to check the value of the KPI based on the variable value. However if i click on header/item it does not make a difference, but only the first calculation is done in both cases: SUM(CASE WHEN VBAK.AOE_MAPPING =

Hello,I try to count the number of sales order items based on a filter on headers.I manage to do that:SUM(CASEWHEN VBAK.BSARK NOT IN (ZWEB, DFUE, ZMYP, ZMWS, ZTEL, ZPBI)AND VBAK.ERNAM NOT IN (BZTLK, BTS16)AND VBAK.VBTYP = CTHEN 1ELSE 0END)But it only counts sales orders and not sales order items.Note that I manage to do it with a Pivot Table (since we can choose on KPI to count VBAP or VBAK) but I also want to have percentages on the same OLAP table.Thank you in advanceAntoine

Hi All,Currently I have a dropdown button with manual entries. All of these entries set two variables, of which one concerns the name of the selected entry.Preferred value to set for the name:Exclude Invoice Value of Zero: YesHowever, so far I didnt find a way to get this Yes in bold. Regular ctrl + B as well as and (double asterisk) operators dont work. Is there any way to get this done?Thank you!Jeroen

Hi,I have a problem that was addressed in another topic however, I have tried the solution and it did not work.Basically i would like to sum up the euro value of invoices that have been completed within 2 working days. We dont have the calendar table in our data model so using the working day formula does not work and therefor I have tried the below work around that has been suggested. However, am getting an error.Can you please let me know where my error is?SUM( CASE WHEN DAYS_BETWEEN( REMAP_TIMESTAMP (ROUND_DAY(BKPF.BLDAT, MONDAY 08:00-17:00 TUESDAY 08:00-17:00 WEDNESDAY 08:00-17:00 THURSDAY 08:00-17:00 FRIDAY 08:00-17:00 ),REMAP_TIMESTAMP (ROUND_DAY(BSEG.AUGCP, MONDAY 08:00-17:00 TUESDAY 08:00-17:00 WEDNESDAY 08:00-17:00 THURSDAY 08:00-17:00 FRIDAY 08:00-17:00)) <=2.0 THEN BSEG.EUROELSE NULLEND)Thanks for your help!Anna

Hi Team, Like list of supported connectors available with celonis. Where I can find list of supported and unsupported Database with celonis ? Thanks.

Hi, I have loaded table BSEG, however when I run AP analysis, the values only sum for posting key 31 as that is what the invoice is based on . However, for validation purposes I need to total across all the posting keys in BSEG. How can I structure a query to do this ? Thanks Geoff

Hi all, Id like to compare the Purchase Requisition (PR) value to the PO value and to the Invoice value. Therefore, Ive added an OLAP table with the PO document numbers, PO Items and the PR number as dimensions and the PO Net Price (EKPO.NETWR) and the PR valuation price (EBAN.RLWRT) as KPIs. Afterwards, Ive calculated the difference in percentage between PO and PR value which works fine. Now, Ive tried to add the Invoice value as a third KPI to this analysis in order to see all differences within one view. Therefore, Ive added the Invoice Value (EKBE.REEWR) to the KPIs, however received following error message: No common parent between tables could be found please check your schema. The tables EBAN and EKBE do not have a common parent in the schema I do understand the issue, however do not know if and how I could solve it, in order to have all three values (PO, PR, Invoice) in the same table. Any ideas? Thanks, Oli

Hello Community, I am playing around with the backup content function for Celonis analysis. https://python.celonis.cloud/docs/pycelonis/en/latest/notebooks/99_Use_Case_Version_control.html#Create-backups-of-all-analyses-that-are-published-in-separate-workspace-directories While investigating, I realised that you have to store your file locally, before you can push it to Git, or AWS S3. I was wondering if anyone tried to directly send the backup to S3, or Git?

Hi there I would like to use nested variables:I have a dropdown button with two items: 'dont filter and filter according to parameters.When I choose the option dont filter I, well, dont want to apply filtering on certain components.When I choose the option 'filter according to parameters I want to apply a filter that also takes one or more other variables into account.Currently I have a variable that I use for filtering, where the variant including filters looks something like this:FILTER "MY_TABLE"."MY_COL" > <%= myvar %>;However, this does not seem to work as the myvar variable is not replaced by the value of the variable.Any ideas how I can have a filter that is disabled, or executed using other variable(s)?