Product Q&A

Hey guys, do you have any idea on how to setup a week number calculation that includes timestamps of monday in the following week? (tuesday as the first day of the following week) Thank you,Alex

Background: for Plant Maintenance we want to use the AUFK and MHIS tables for exploration

I have questions related Celonis App creator course. " 1:What is the function used to replace all instances of a certain term with the YAML editor" " 2: what is the syntax used to search all sections with the YAML editor" your fast response will be a

Does anyone have the link between the Plant Maintenance Orders PMOs tables to Purchase Order POs table EKPO?

Hello Experts, In OLAP header and OLAPs Fields header not able to use dollar ($), When I use the ** symbol, for example, if I give **Amount then it turns as "#{Amount $}".

Hi Community, is there a way to build a dynamic column chart with 1 dimension but several, variable KPIs? The problem is, once I include all possible KPIs the bars wont be displayed anymore. In most cases only a certain number of those KPIs is necessary. For example: CASE A: Dimension (matnr.1): KPI1 (2), KPI2 (0 or -), KPI3 (4) CASE B: Dimension (matnr.2): KPI1 (0 or -), KPI2 (1), KPI3 (0 or -) In Case A only the KPIs 1 and 3 should be displayed in the column chart. In Case B same for KPI 2. Is it possible to change the visibility of KPIs on the basis of the CASE (A or B)? Maybe by using a parameter? Thanks for your help! Alex

HI, as a newbie to PQL, I am would need help in order to calculate the different in stock levels between two months. The current display shows the SUM of the stock, with a Component Filter the particular month. How could I calculate the difference between the starting stock (January) and the current stock level, by month? (there are multiple stock items)ThanksKenny7

I'm using the formular:TO_TIMESTAMP("AFKO"."GSTRI", 'YYYY.MM.DD') and I'm getting the following error message - see attached screenshot 1 I'm using the same formular for "AFKO.GSTRS and there are no errors at all - see screenshot 2. Please help. Thanks a lotAnne  

Hi Everyone! Hoping someone can provide a formula or an idea on how to tackle the two issues below.  Some of our customers (most often EDI customers) order with their specific customer material numbers. Customer material numbers are entered in their CMIR table under their customer number (or payer #).  Issue 1: Customers who have been set up on EDI for years with no issues are now having orders fail resulting in an IDOC. This is because of mass uploads to update CMIRs (several without checking duplicates first by mistake). We need a way to identify these errors and remove the duplicates without having to pull reports for hundreds of customers out of SAP one-by-one to identify the errors. Also, we need a way to monitor moving forward to avoid duplicates.  Issue 2: EDI orders are failing because multiple customer material #s have been entered into the customer's CMIR table tied to only one of our part #s.

Hi Can anyone help me getting start to Celonis? Any training link? regardsRaheel Irshad Khan

Hi All, I am facing issue as follow. In our main analysis the total count of cases are showing lesser than the duplicated copy of it.The duplicate analysis showing more case count which is actually correct but the main analysis is having lesser records.The data model is same for both. In the process data model logs also it is showing the count same as duplicate Analysis.Any idea what is happening wrong here?

Hello,we would like to use the "Data Service Link" funktionality to jump directly into our S4 System.Does anyone has already done that or knows how to implement that?Kind regards Benedikt

Dear Celonis Community, we faced a problem with our KPI calculation based on Sales Order Creation Date. In our graphs we usually show the KPIs (# of SalesDocuments, AutomationRate, etc.) agregated on Sales Order Creation Date. We have some countries having orders open for several months (e.q backorder handling). If now an order was created in january, all its activities are considered in the KPIs that belong to january. Even (due to the topic i described above) the activities from february to march. Looking end of january you will see different KPI values than in march, because february and march activities for this order happened and are now considered in the january KPIs. We know there is a possibility to switch to Eventtime, but we didnt find this a good solution either. I do not really ask for a technical solution, but just for an idea on how other customers handle this topic (do they even noticed it?, do they even face it?). Thank you very much for a response.

Hello, I want to calculate the percentage of Perfect PO, For that I have to consider certain criterias like - Out of a list of WFs, I have to include only 1Payment should be on timeNo manual changes after PO orderedSome more criterias I am struggling to calculate this percentage, could anyone help me with this? Thank You. Best Wishes Khushboo

Hi everyone, at the Plansee Group we do Inventory Management with Celonis. After three months, we have setup a new data model with most of the business requests covered. We do also calculate the Days Inventory Outstanding (DIO). This works well. Now, wed like to add the evolution of the DIO with time. However, there are three tables (A,B,C) involved with A being the parent node and B and C being a leaf of A each. The relations are 1:N (A:B) and 1:K (A:C). In order to calculate the DIO, we use PU_FUNCTIONS to pull data from B and C on A. Thus, the N:K relation is resolved. Now, wed like to represent the Evolution with time by a date which is only given in table C. While, we could choose a data in the first approach within the condition of a PU_FUNCTION, this doesnt apply if we choose the data to be a dimension of the component. Id appreciate your input from a developer perspective very much and I am looking forward hearing from you. As the logical connection is quite complex, feel free

When I select the manual tick count on the Dimension Axis I would expect a behavior similar to the one I see at the KPI Axis. However it apparently does nothing. Example: When presenting a series of dates, lets say the daily position of a customers credit for a whole year, I filled in 12 in the Ticks count field, expecting it to show only one tick per month, instead of on per day. But nothing happens. Am I interpreting wrongly the way this should work? It would also be nice that data labels would only be displayed where the ticks are shown. Thank you, Joaquim

Hello Team, How to auto forward the signal List mails from Action engine when recipient mail is not responding. Senario: If the employee mail has been revoked or mailbox full error is coming the Action Engine Signal will move to his/her manager/sponsor. Auto forwarding the mails to another mail on receiving the failure acknowledgement from the routing rule defined mail

Hey everyone, Im trying to put my head around the process AI feature for the first time, but have not got really far until now My process is linear, as Ive used process mining to analyse the performance of a purchasing process to detect what was causing higher than expected throughput time of a PO item, and also redundant POs released to a supplier. Having a target throughput time of 2 days, can I leverage process AI feature capabilities to detect most probable root causes (taking into account the characteristics of each event log, product reference, department, price, etc)?

Hello Team, My team is using Celonis C4C Enterprise Version and we are creating some dashboards for Purchase To Pay for our customers. There is a requirement where we need to increase the Threshold of Self loops. Im trying to increase the threshold to 500 but it resets to 100 after saving the analysis settings. Just asking if 100 is the threshold limit? Eagerly waiting for a response. Thank You. Warm Regards, Jayanta Borkakoti

Hey, I want to create an OLAP Table, which has the Activity Name as Dimension, Count of other Table within a specific time and the mode of the count as KPIs. Both tables have timestamps and the same ID (see attached image with explainationCelonis_Questions729848 43.2 KB ). Unfortunately, I have no idea of how to do this with the PQL statements and tried various things but none were successful. Im using Celonis on-premise 4.6. I would appreciate any help here.

(topic withdrawn by author, will be automatically deleted in 24 hours unless flagged)

Hello all, how can I format my colum chart based on this formula? CASE WHEN '<%= unit %>' IN( 'YEAR') THEN '%Y' WHEN '<%= unit %>' IN( 'MONTH') THEN '%Y-%m' WHEN '<%= unit %>' IN( 'WEEK') THEN '%Y-%m' WHEN '<%= unit %>' IN( 'DAY') THEN '%Y-%m-%d' END The formula doesnt work in the format space. image1321124 6.54 KB Thank you in advance.

Would it be possible for Celonis to process real time high volume data from PLCs. Most use cases I see have to do with administrative processes. How about PLC data processing? Anybody with experience on this topic?

Hi All, I have full AP data and I am trying to write a formulae in Celonis to showhow many are PO Invoices and another one to say how many are Non PO Invoices. What will be my PQL query be. Thanks Sudip

Hi,i do have trouble implementing implenting a filter. I want the to give the business user the chance to filter for a value range.the column looks like:x001x002x003y001y002z001At the moment there is a button dopdown - but there is the need to look up a range, e.g. x050-x080 which are to many values to be selected manually.My idea was to let the user set the minimum and maximum value via input fields and use those values as a sheet filter but variables can not be used in sheet filters.Does someone have an idea?Best regards,Jan