Process Analysis

Hi together, there's spaghetti in my head. I have the feeling like it should be possible, but can't figure out how to.I've a table like this A B 0 NULL 1 0 2 1 3 1 4 1 5 1 Column A contains the case key, B can contain a case key as a reference. E.g. case 1 refers to case 0. And the cases 2, 3, 4, and 5 refer to case 1. Now I want to "turn around" the reference so that there is a new column that shows e.g. for case 1 that it's referenced by 2, 3, 4, and 5. The result should look like this:

Using PQL in the VBFA table, I need to combine the date and time into a single timestamp.Both the ERDAT (date) and  ERZET (time) fields are formatted as complete timestamps in our data model.I succeeded by converting both fields to strings, combining them, then converting the combined string back to a date.TO_DATE(TO_STRING ("VBFA"."ERDAT" , FORMAT ( '%Y-%m-%d' ) )||' '||TO_STRING("VBFA"."ERZET", format ('%H:%M:%S')), FORMAT ( '%Y-%m-%d %H:%M:%S' ) )Is there a more direct approach I could use to obtain the same result? The conversion to string seems  unnecessary.Thank you.

Hi, i have a Bar chart with the time axis on the x-axis and on the y axis how much the money was. Is there a way to break down the y axis graph into the specific vendor_names, there are around ten. How could i do it in a view.  Thanks in advance

Hi together, I'm working with legacy views and can't manage to pass the value of an augmented attribute of type date to a variable to use it as parameter for KPIs. The record containing the augmented attribute  - id: CM_MONTHS    identifier:      id: id      displayName: Id      pql: '"CM_MONTHS"."MONTH"'    attributes: []    newAttributes: []    augmentedAttributes:      - id: late_creation_deadline_date        displayName: "Late Creation: deadline date"        possibleValues: []        columnType: DATE        format: "%Y-%m-%d"        housekeeping: false        type: AUGMENTED_ATTRIBUTE    flags: []    priorities: []    triggers: []    businessRules: []    type: RECORD    origin: PACKAGE The component to update the augmented attribute  type: table  settings:    data:

In an OLAP table, I am looking at sales documents "VBAK"."VBELN".  I only want to see the last change of each day.  How do I filter for the last "_CEL_O2C_ACTIVITIES"."EVENTTIME" of each day?  I’ve experimented with PU_MAX, but I keep getting errors.

Hello everyone, I’m currently migrating an old view to a JAB view. In the old view I had an input dropdown (made with a custom object “Time Dimension” with the content columns: Year, Year-Month, Quarter, Week, Day). In the new JAB view I now want to implement this as well (filtering charts according to Quarter, Week and so forth). I’m already aware of the Celonis documentation: Configuring user inputs (input box, input dropdown, button), but this is really too intransparent for me.  Can someone give me a step by step guide on how to implement this?I already created a variable as object like this: {"Year": "String","Year-Month": "String","Quarter": "String","Week": "String","Day":

Hi Team, I’m working on input dropdown where my timestamp should be convert into daily,weekly,monthly and if it is daily I need 8 hrs , for weekly 40 hrs and monthly 173 hrs in one single dropdown. How I can achieve it. Regards,Ajith Naidu.

Hi team, I want to know more change the default display of columns within the Case Explorer component of Studio Views, after having added two more attributes.Best regards, Leonardo

Hi everyone, I’m working on an analysis in Celonis and I have a question regarding filtering table rows.In my case, one of the columns in my table displays a sum of values retrieved from the backend (e.g., SUM("SomeColumn")). I would like to exclude all rows where this sum equals zero, so they don’t appear in the final table.How can I apply such a filter directly in the table configuration or via a filter condition?Thanks in advance for your help!

HelloIn a scenario where there are multiple instances of “WIP CB IP” activity, I am trying to identify the first instance along with the next activity taken by a user.  I am easily able to identify the first WIP activity (highlighted in blue) using PU_FIRST.  However, when I attempt to identify the next activity following the first WIP, I end up retrieving the activity for the 2nd WIP line (highlighted in yellow and red).   I would like to report on the activity highlighted in green.I have tried wrapping the PU_FIRST within the ACTIVITY_LEAD but the syntax failed indicating that “/IRM/IPCBITM” is not within the Activity table.  I have also attempted to use a CASE WHEN statement but that just generated two WIP lines.  I am only interested in the first instance of WIP.Thanks in advance,Phil  

Hi,I need help fixing my PQL scriptCASE  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 1%' THEN 'Criteria 1'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 3%' THEN 'Criteria 3'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 5%' THEN 'Criteria 5'  ELSE NULLEND I am trying task search in a text field (Shopping_Details_Desc) for cases where ‘%CRIT%’ is identified. I would then like the code to assign a Criteria when the number ‘1’, ‘3’ or ‘5’ follow directly after the we wildcard search. I am pulling errors because there are other numbers in the text description and the code is incorrectly assigning them because it is find any any ‘1’ (as an example) that comes after ‘CRIT’ and then calling it a ‘Criteria 1’, even when it is a Criteria 3.  My issue is that sometimes our operators are miss writing the text so we are trying to capture either CRIT or CRITERIA, or anything in between - which is why I

Hi all,  I created an attribute (“MARC”.”cond_mbew_compl_vprsv”) as a boolean with the following formular:CASE WHEN(  ( "MARC"."BESKZ" = 'E' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'S' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."STPRS")) = 0 ))    OR  ("MARC"."BESKZ" = 'F' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'V' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VERPR")) = 0)))THEN 1 ELSE 0 END Now I want filter like followed: FILTER "MARC"."cond_mbew_compl_vprsv" = 1 This does not work and I got the following error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account. Can you help me what I should change? Thank you. Regards

I'm facing an issue where my charts and tables show the message "You don't have data yet" even though I have connected them to the data model.When I create a Case Explorer, it only shows 1 row with these columns: Case ID Number of Activities Duration In the table section of the Case Explorer, it only displays CDHDR.CASES.Can someone please help me understand why I’m not getting any data in the charts or other tables I create?Thanks in advance!

Hello everyone,I'm working with classic process data: Case ID, Activities, and Timestamps.I want to list all first activities and all last activities, and count them by case. This way, I can see which activities my variants start and end with, and how many variants they cover.Ideally, I’d like this in two tables—so I can select a starting activity and see the corresponding ending activities in the other table.I’m assuming it’s fairly easy but i can not manage to do this..Kind regards, Niklas

Hello all,I used this formular to get the average time of late payment:AVG((DAYS_BETWEEN(PU_FIRST("BSEG", "_CEL_AR_ACTIVITIES"."EVENTTIME","_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = 'Due Date passed'),"BSEG"."TS_AUGDT")) - <%= buffer1 %> ) This works well but when I filter on Fiscal Year the KPI is wrong because our Fiscal Year is not similar to Calendar Year. Our Fiscal Year starts always in october. How can I change my formular that the KPI is calculated for example from october 2024 til september 2025 when I selected 2025 as Fiscal Year. Thanks and best regards.

Hi,Is it possible to adjust the settings of a Process Explorer on how it opens inside a view, like the zoom level or which Events are shown?Right now, there are too many events displayed in the Process Explorer, and my users need to zoom manually to see the names of the activities and their KPI values. I would like to change the initial zoom settings to a higher value or to show only the activities that don't display 0 in their primary KPI, if that's possible.Many thanks for any help, Fabian

Hello everyone,I understand that the button dropdown is still not available in the new Views. Has anyone managed to recreate a similar functionality? For example in the analysis I have two button dropdowns and for each one of them I have manually inputted 5-6 categories (Local Supplier, Company Code, MSGK, PO number etc.). Each category is updating two variables (one is for the name of the column and other is PQL calculation in OLAP table). Categories from button one are updating variables in column A while the categories in button two are updating variables in column D. I need to achieve something similar in the new Views, but the documentation for the Input Dropdown isn’t entirely clear to me. Has anyone implemented this successfully? If so, how did you manage it?Thanks in advance for your help!

Hello everyone,I would like to create option for users where they can leave comments. I would like for this option to be connected to a chart (let say it’s a chart showing number of blocked documents per month) and I would like to allow users to leave comments for February (number of blocked documents was really high compered to other months). But the issue is that for comments and augmented attribute identifier needs to be unique and I cannot configure it. So if someone has some idea I would be grateful.  Also in documentation they configured comments with variables but when i put variable for DOC ID (VIM_1HEAD.DOCID) and use that variable as identifier it’s not working. Any idea what should be put there? Thank you!

I DID THE WHOLE PROCESS IN MY DATA POOL, FROM UPLOADING A FLAT FILE TO THE DATAMODEL WHERE I HAVE NO ERRORS, HOWEVER IN THE VIEWS WHEN CREATING A TABLE VIEW IT ONLY BRINGS ME THE HEADERS

Hi Guys, what’s up ? I wanted to ask if there is any way we can selection multiple attributes in new views and update variable based on it. Currently, the ‘multiple’ option is disabled for attribute selection. I tried with free text but it just adds additional single quotes in beginning and end of the string, so those single quotes should be removed to consider it as table and fields. for ex. “table”.”field” is considered as ‘“table”.”field”’.  

Buenos días necesito saber si es posible utilizar CELONIS para realizar análisis de dato o información para obtener INTELIGENCIA en el ámbito militar, lo que me permitirá mejorar el proceso de toma de decisiones 

Hi all, In the case explorer, in YAML or Views, how can I change the Throughput Time and use my own formula in PQL?Thanks for helping.Br,Leonardo

Good morning all, I need assistance with PQL to compare the timestamp of a certain activity of case A with the timestamp of another activity of case B, has anyone done this before?

Hello,My goal is to create a filter which, after clicking, will only show cases which contain specific activity in them. In my case I want to include all cases which do contain activity with string ‘reject’ in the name of activity.I’m trying to create a filter with this expression:  FILTER MATCH_PROCESS_REGEX ( "_CEL_MERGED_ACTIVITIES"."ACTIVITY", 'X' >> LIKE '%reject%' ) = 1;             Although it does not seem to be working.How can I create and apply a filter to show only all cases which do have such activity?

I have event log as leading_object_id activity_name resource1 Create Invoice A1 Approve Invoice Z2 Create Invoice A2 Create Invoice B2 Approve Invoice BI want to write PQL query (KPI) such that I get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice. How can I achieve this?