Product Q&A

Hello, I would like to to know if I can create PDF reports with Celonis Snap?

How can I create a Backup or restore a Backup from my Celonis Snap Analysis?

Hello, how and where can I upload and integrate the exported Data/Analysis from another Celonis Snap account? Is there any other possibility to exchange Analysis from one to another Celonis Snap account?

Dear Colleges,  I have lost access to the analysis that I made at the P2P.  

hi,  I would llike to know if it is possible to set multiple calendars for different plants with different working hours in the same data model. best regards, Anna

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.