Product Q&A

I have a question regarding process automation: I need to get the max. value of one column and therefore use the "Query Data Model" node. After that I want to add a new row with exactly this max value. Actually, the "Write Data to Table" node would need an int value then but the "Query Data Model" only gives me a list. How can I convvert this value?

. if I lower the limit to say 10, it works fine. can anyone help me with that.  

I'm trying to connect to an on-premise SQL server and wanted to confirm my understanding that an extractor is not required if the IPs are whitelisted to allow traffic. If anyone has done this before, I would appreciate your response.

I have an activity (Claim Denial,) here I'm trying get the count of activities got paid after the Claim Denial,. payment happened before Denial and after denial as well, but I need to consider the first payment made after the Denial,  it can be many payment as well and payment activities we have 5 different type. also payment span should be >= 60. days between(First Denial date , first payment date(after the denial)>=60payment A- 01/01/2021Denial- 02/01/2021Payment B-03/01/2021 PU_FIRST works for First Denial but for Payment if we use PU_FIRST it will look for the Payment A but it should take Payment B date

Is there a way to combine conditions across tables in a PQL query or is it required to join tables beforehand in order to be used in a PQL query?   Here is an Examples: I want to go from this: CASEWHEN ISNULL("LIKP"."ZZTERMIN_DATE")=1 AND ISNULL("LIKP"."ZZFRTER")=1 THEN 'Ohne Termine (Ohne frühster & Ohne Fixtermin' WHEN ISNULL("LIKP"."ZZTERMIN_DATE")=0 AND ISNULL("LIKP"."ZZFRTER")=0 THEN 'Mit beiden (Mit frühstem & Fixtermin)'  WHEN ISNULL("LIKP"."ZZTERMIN_DATE")=1 AND ISNULL("LIKP"."ZZFRTER")=0 THEN 'Nur mit frühstem Termin (ohne Fixtermin)' WHEN ISNULL("LIKP"."ZZTERMIN_DATE")=0 AND ISNULL("LIKP"."ZZFRTER")=1 THEN 'Nur mit Fixtermin (ohne frühster Termin)' END  To this:CASE WHEN "LIPS.LFIMG" <> '0' AND ISNULL("LIKP"."ZZTERMIN_DATE")=1 AND ISNUL

 I am using celonis IBC and file uploads option to export eventlogs . By defalut celonis creates table with the csv file name, which we have uploaded. can we change the table name? if i upload the same file multiple times with different data only the latest data available. How can we preserve previous versions of data?

Hi all,I would like to build a chart which shows the number of open activities at a given day.In our data activities are a combination of a task (e.g. modelling or testing), and a (lifecycle) status (e.g. new, in progress, done, rejected). I would like to plot per day the number of open tasks/activities of a certain type.I currently have the activity timestamp aggregated to day as DIMENSION, and the following KPI:MOVING_COUNT_DISTINCT(CASE WHENMATCH_ACTIVITIES(NODE[Testing - In progress] , EXCLUDING[Testing - Done, Testing - Rejected] ) = 1THEN L33_V_MBD_INZICHTEN_STATUS.FEATUREAPGIDELSE NULLEND,-999,0)In (my?) theory this should use the activities up until the day, and then determine whether the case contains an open testing task or not. However, my current result is incorrect:image1223594 18.2 KBWhich trick am I missing?BTW: were on CPM4.6Happy holidays!

Dear Community, I would like to show the throughput times of different vendors. However, I would like to group the vendor numbers on the dimension axis by percentage. Similar to the example on the picture. DLZ1334407 7.48 KB Thank you very much if someone can help me with this problem.

Case when and Calc throughput focus on the full case and not a part(sub-process instead of process) for each case. I want KPIs to focus both on the entire case and sub process as well. I tried providing the first occurence and last occurence workaround, however this assumes that the process sequence is adhered to, it skips cases where the process sequence is not fully adhered to.

Hi Team,Am trying to find out , country wise how many billing blocked customers and delivery blocked customers I think i did it, but how do i remove the zeros from the pivot table.image940425 14.6 KBIf i expand the country, i required only the KPIs Dimension. not the unwanted values (refer the below screen shot). Thanks in advance.image977439 28 KB

Try celonis Order Management(EN) DemoNow instance not working

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