Process Analysis

Hi all,I’d appreciate your help with creating a stacked bar chart.In my dataset I have cases which are generated due to 1-4 issues. I have Error_count (type INT) and Product (type STRING) as case attributes and have a KPI defined for case count.I’ve selected the component Stacked bar chart. I’ve selected Count of cases as the first stack, while Error count is a dimension.How do I stack the chart per product? I’ve attempted adding Product as an additional dimension, but that doesn’t get me the outcome I want.I look forward to hearing from you. Thanks.Kind regards,Vladimir

Hi team,I have an issue with the Throughput Time Explorer in one of our Views. When I add it to a existing or New Tab, I get and error:Throughput Time Explorer [id:  ...]: Syntax error near [FIRST] after reading [“] at line 3. Please refer to PQL documentation for available syntax.Please see attached screentshot:I’d really apreciate your help with this. For context, I use the Througput Time Explorer in other packages with no issues whatsoever.Kind regards, Vladimir

Hello Community, maybe I am just blind and didn’t find it yet in the documentation, but could it be that there isn’t any possibility to determine if there is a number in a specific pattern?I’ve got a column “unit” which got values like ‘A123’ and ‘AB12’ - I need to filter out every unit which got no number on second position.Like in regex, I can do: ^(.)\d to get if the second character of my string is a number.SQL Patindex also can do very basic capturing groups like %[0-9]%  - which will give me 2 if the first number is on second place. At the moment I am doing this with this PQL:TO_INT( SUBSTRING("TA_MR_PKC_EVENT"."BEARBEITENDE_ORGA",1,1))Which results in NULL if the second position isn’t a number - I can work with that, I am totally fine about it -  but I am a little bit curious if there is an more elegant way in doing this. Best regards,Fabian

COUNT(  CASE    WHEN PROCESS EQUALS (      "_STD_CEL_AP_ACTIVITIES_TABLE"."ACTIVITY_EN"      EQUALS (("_STD_CEL_AP_ACTIVITIES_TABLE"."ACTIVITY_EN")* to ANY to 'Remove Payment Block' END )    )    THEN      "BSEG"."MANDT" || "BSEG"."BUKRS" || "BSEG"."GJAHR" || "BSEG"."BELNR" || "BSEG"."BUZEI"  END)I haven’t used PROCESS EQUALS before, and I’m finding it difficult to understand its syntax even after going through the documentation. I want to use it in view, so if you have any insights or examples on how to use it, please let me know.

After creating my target model in the Process Adherence Manager, I want to be notified about:Missing events Unexpected events Incorrect event orderWhat is the best way to connect the results from the Process Adherence Manager to an Action Flow, so that I can automatically trigger alerts or follow-up actions based on these deviations?

Hi,I have a defined KPI in my knowledge model to calculate the median throughput time for my process: MEDIAN (CALC_THROUGHPUT ( CASE_START TO CASE_END , REMAP_TIMESTAMPS ( "CONSUMER_APR_ACTIVITY_TABLE"."EVENT_DATE" , DAYS ) ))I’d like to be able to compare median throughput times for all cases and only for cases which include a certain activity (for example: PENDING). I’d like to use either a table or a bar chart for this comparison.What would be the best way to achieve that, considering that table filters apply on all columns? Can I introduce another KPI which will determine the median for cases which include PENDING only? If yes, how can I do that?I look forward to receiving advice. Thanks.Kind regards, Vladimir

Hi,Shall we consider Production Order Journey as Work Order Journey.   

How can i enroll for introduction to process mining course. I do not see the enroll option….

はじめまして。Celonisのバリアントエクスプローラーのエラーについて、投稿いたします。現在、View内に設置したバリアントエクスプローラーを開くと以下のエラーが発生します。・直接開いた場合　Variant Explorer [id:variant-explorer-531a92c8-92cd-4f1f-a10e-86a23a3ae35c]: Invalid PQL query. VARIANT: The specified activity column ["_CEL_PGM_WLM_VE_ACTIVITIES"."ACTIVITY_EN"] contains 36487 distinct activities. However, this component only supports 32767 distinct activities. Please review your PQL statements in the Knowledge Model and in the View YAML filters.原因と対応策について、ご意見いただけないでしょうか。よろしくお願いいたします。　

Using Intelligence API, how to get to the pql statement behind the filter

Hello,I’ve just finished the OCPM training. In there you create objects with multiple object to object relationships and events with multiple object to event relationsships. So e.g. the object “Expense” has a relationship to the “Report” object and the event “Approve Report” has multiple relationsships, e.g. to the object “Expense” and “Report”. The resulting Process Explorer can be seen in the right picture. As another test, I’ve duplicated the events and deleted all but one event to object relationsships. So each event has only one relationsship to one object. When displaying a Process Explorer with this Event Logs (see left picture), I get the same result as with multiple event to object relationsships. Also when filtering on tables with data from the source systems, i get the same filtered results on each of the Process Explorers.Am I missing something or what are the benefits of multiple event to object relationships?  

Hi everyone, We have several ABC Classifications that we need to implement in Celonis and I’m simply curious:Why is the ABC classification resulting in a 1, 2, 3 ranking? I’m ending up having to convert to string and remap the values for each classification so that it makes sense for the users and while it’s not a huge issue, I think it would be easier if the function just resulted in A, B, C directly. Is it for efficiency by using integers?  Or does this allow for some further analysis that I’m not seeing at the moment maybe? Best regards,Benjamin

Hello everyone, 👋I’m building an overlay view to show case details, using number as a variable.Currently, the overlay view has a predefined filter like this:FILTER "sc_req_item"."number" = '${number}'; However, I’d like to make the overlay more dynamic — for example, use another variable ${case_table} to replace "sc_req_item" (or even "sc_req_item"."number") so that the same detail view can work for multiple case types, such as Requests, Request Items, and Tasks. Has anyone successfully used a variable for table or column names in a FILTER statement (or found another way to make one detail page work dynamically across multiple case tables)?Any insights or workarounds would be really appreciated! 🙏 Thanks!BR,Xiangxiang

Hello, I have an issue with a large number of Action Flow connections being saved under every analyst’s account, and wonder if it is possible to remove them, so that every analyst will only have 1 connection (via their API key) associated with the Action Flows. If it is unclear what I mean, under some Action Flow module (e.g. Query Data), there is a list of connections that you can use to get the module working, which I am trying to delete and establish only 1.  

Hi everyone,I’m using the Grouped Column chart in Celonis Views, and I noticed that the data label position (currently displayed in the center of each bar) can’t be changed to the top or outside end — unlike in Analysis charts, where this option is available under formatting.Can anyone confirm if the label positioning feature is planned for a future Views release, or if it’s already available in any recent update?I reviewed the documentation below but couldn’t find a clear mention for Views specifically: Analysis — Charts and Tables — Settings Creating Charts in Views Celonis Release Notes Thanks in advance for your help or clarification! 🙏— Rajesh

Hi everyone,I'm currently working on a use case in Celonis and could use some help with a PQL rule I'm trying to build.I have a table called HOTEL that contains travel records, each with a start date and end date. I want to validate that every single day within the travel period is marked with a "J" in a calendar table called CALENDAR.For each travel record in HOTEL, I want to:Iterate over all dates between STARTDATUM and ENDDATUM. Check if the corresponding calendar entry for each date has the value "J". If any date within the range does not have "J", I want to flag it as an error.Does anyone have an idea how to solve this problem in a pql formula as a KPI?Thanks in advance 🙌Niels

Hi    We are seeing a strange issue where we are using the exact same formula as in Analysis for a KPI, however the data on excel generated by action flow is about 2% different from that on the analysis sheet. Has anyone encountered similar situation and what was the resolution? 

Hello,I'm trying to make the DSO indicator, but I need to get data from several tables and I'm having problems...The DSO formula is made up of two parts, Revenue and Accounts Receivable. I need to calculate each one individually and then divide one by the other.I'll use the example of Accounts Receivable:Quando eu uso os campos de Filtro, com os seguintes filtros, funciona sem problemas:FILTER "o_celonis_SalesOrder"."CompanyCodeText" IN ('CompanyNameZYX');FILTER "o_celonis_SalesOrder"."SalesDocumentType" IN ('XXXX', 'YYYY');FILTER "o_custom_CustomerAccountItem"."BaselineDate" <= {t ${end_date}};FILTER "o_custom_CustomerAccountItem"."ClearingDate" > {t ${end_date}} OR "o_custom_CustomerAccountItem"."ClearingDate" IS NULLHowever, when I try to place the same filters in Case when, to generate the indicator that will be combined with Billing, there is a connection problem between the tables (o_celonis_SalesOrder and o_custom_CustomerAccountItem).sum( CASE WHEN "o_celonis_SalesOrd

Hi, I currently have a dashboard in Studio Analysis for which I built an Action Flow that picks up a distribution list with certain filters so that i can send out automated emails with a pdf attachment (each with different filters). Now I wanted to do the same with a View and this is not possible.50 users should receive an automated pdf of a View on a weekly basis filtered only on their set of Divisions/ Product Groups. What is the best alternative to automate this?BR  

Hi all,in Celonis sales there’s big focus on value realization yet I find the current approach by tracking value with the Transformation Hub less than ideal. For instance, the Duplicate Invoices App may assume that all identified invoices are saved cash, but in reality vast majority of such invoices could’ve been automatically blocked by ERP anyways.Do you guys have some good examples from real life where you were able to demonstrate significant amount of realized value (in $$$) companies got from Celonis implementations? How much of the value was purely Celonis’ merit and how much was it based on process improvement programs companies were undertaking regardless of Celonis?I think this discussion is needed, especially in smaller markets (I’m based in Norway), as the licensing model is much driven by value realization assumptions.

Hi everyone, How can I add something to the existing data model? Thanks!

Hello everyoneI'm relatively new to building custom Celonis components in Studio and I've hit a wall with something that seems like it should be straightforward. Hoping some experienced folks here can point me in the right direction.The issue: I'm trying to replicate the built-in throughput time explorer with a custom component, but I'm getting different results:Built-in explorer: 12k cases (1-day filter) My custom component: 13k cases (same filter)What's confusing me:I exported both results and compared them - all 12k cases from the built-in are in my results My component has ~1k additional cases that seem valid when I check them manually These "extra" cases definitely meet the 1-day criteria, so why does the built-in exclude them?My current filter:FILTER CALC_THROUGHPUT(FIRST_OCCURRENCE [ '${start_activity}' ]TOFIRST_OCCURRENCE [ '${end_activity}' ],REMAP_TIMESTAMPS("TABLE"."EVENTTIME", MILLISECONDS) )/ 86400000.0 BETWEEN ${min_days} AND ${max_days}; Questions:Did I make a mistake in

I have the following lines of code for which I would like to create a table in which we see the total amount of transaction codes, another column with total amount of transaction codes per company code and the amount of transaction codes as a percentage of the total transaction codes, per company code.In the back end I have managed to write these codes, however, because of a lack of the 'Over' function I can't seem to be able to make it work in the front end. These are the codes in question that are currently working in the transformation scripts ( back-end ):select TRANSACTION_CODE,ACTIVITY_EN,Company_code,Count(TRANSACTION_CODE) as count_tcode,SUM(count(TRANSACTION_CODE)) OVER(PARTITION BY Company_code) AS total_per_Company_code,ROUND((count(TRANSACTION_CODE) * 100.0 / NULLIF(total_per_bukrs, 0)), 2) AS percentage_per_Company_codeFROM _CEL_AP_ACTIVITIESGroup by TRANSACTION_CODE,ACTIVITY_EN,Company_codeHow would you go about creating a PQL script that could tackle these lines of code

Hi Team,I’m working on creating a generic Action Flow with a writeback module. Depending on the OLAP table, I need to send different inputs to select the correct table for the writeback.

We are currently looking for a way to capture the filters applied by a user and include them, along with data from tables, in an Excel export triggered by an Action Flow.However, we are currently unable to access or retrieve the filter information within the flow.Has anyone developed an approach or working solution for this scenario? Any help or guidance would be greatly appreciated.