Product Q&A

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? 

Hi everyone,I’m exploring the idea of creating a view for supplier evaluations where the supplier’s logo changes dynamically – meaning the correct logo is displayed depending on the selected supplier.My idea was to use a variable in the image component to call the specific URL for each logo. Currently, this doesn’t seem to be possible.Is this something you are looking into, or are there any workarounds? I’d love to hear your experiences.Thanks & best regards,Jan

Hey all,I have a process where I have four activities labeled: A, B, C, D.In the event log I have for one case equal timestamps for B and C: 08:11:00 until 08:23:00.My problem is that Celonis visualizes this process as A → B → C → D, however I expect the process to look like A → B, C → D. Is there any way to do this, and if so, how?

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 Team,I’m trying to send data from one Action Flow to another without using a webhook. Is that possible? Thanks in advance for your help!

Hello,Im no longer able to access past Celosphere (2023 & 2022) video on-demand. I belief it used to be https://www.celonis.com/celosphere/2023/recordings/watch and https://www.celonis.com/celosphere/2022/recordings/watch respectively. Currently URL redirect to 2024. Is there any chance to watch year 2024 and 2023 past recordings? Thank you. 

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  

Hello All,Could you help me to advise on how to classify the bucketing with the help of coloring in pivot table which is recently develop in new view. We are able to provide the color classification in Olap Table however i am afraid it is not yet possible in pivot table.Please HelpRegards,Apurva 

Hi all,I am trying to extract an olap table data from a view can you guys please help me with the appropriate python/pycelonis code. Thanks,Akshay

Hi all, I try to find an easy solution for the following situation:I am triggering an Python script in ML Workbench via Action Flow.This Script is using pycelonis and extracts an OLAP table out of an Analysis. The OLAP table is containing exactly the information, columns etc. how we need the data. My first idea was to create an .xlsx file directly within ML-Workbench from dataframe and get the .xlsx file that is then stored within Jupyter File Browser via another Action Flow module. So far I haven't found a solution to access the files stored on ML-Workbench. Using Celonis Query Data -> CSV Advanced etc. is a total pain because in both modules I have to add all the columns again and do the mapping and all this stuff although the structure itself is already available on Analysis OLAP table level. Another issue is that I wanted to do this within one Action Flow and the Action Flow is not waiting till Python script execution is completed. Current workaround is the use of Sleep modu

Feature Request: User Creation Date in Celonis Admin & Settings DashboardThis request proposes adding a new feature to the Celonis Admin & Settings Dashboard that would display the User Creation Date for each account.Purpose & Benefits: Provides administrators with visibility into when a user account was created. Helps in audit readiness and compliance checks by tracking account lifecycle. Assists in troubleshooting and access reviews by correlating account age with activity. Reduces dependency on separate audit reports for basic account details. Expected Outcome:A new column/field labeled “User Creation Date” available in the Admin & Settings Dashboard, enabling administrators to quickly filter, sort, and review users based on when their accounts were provisioned.

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!

  Latest trend: #AI 

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

Does anyone have the steps to do the data integration with the Dynamics 365 for order to cash process?

Dear Celopeers, We already extracted the relevant tables from the customers system. Nevertheless, as the cutsomer is using Infor, we are lacking the expertise with this software.Are there any scripts available which we can use in order to facilitate the next steps? Thank you! Kind regardsRaluca

Hi,I have an action flow with a Router module, and I want one of the branches to just end the Action Flow without going through the rest of the Modules in the Action Flow. Because I have an Aggregate module, it always continues executing from there, so I want to just stop the Action Flow at specific condition. Thanks

These two tables are related in 1-N relation(VBAP:1 and VBRP:N). Also in some cases there are no entries in VBRP(AUBEL and AUP) for some entries in VBAP(VBELN and POSNR). I am creating an Olap to find all entries in VBAP (VBELN and POSNR) which does not have related data in VBRP(AUBEL and AUP) but they dont show up in olap. If i remove the VBRP columns from olap then they show up.

Hi!I’Ve been struggling with setting up the correct PQL for visualising a KPI on a line chart showing a timeline as the formula became quite complicated. Would appreciate any help on understanding what query I need or why it is not working.  The KPI I want to display on a timeline chart is a cancellation rate. The view contains an input dropdown as a variable  ${outlier_analysis_selection_main.pql} which the dashboard should adjust to. The dimensions of the line chart are ROUND_MONTH("CASE_TABLE"."DSL_ORDER_DT").  In the line chart, I already have the overall cancellation rate.This does not adjust to any user filtering done through the dashboard, nor the selection through ${outlier_analysis_selection_main.pql}. I also have another cancellation rate line which does adjust to any user filtering done. I can therefore compare the development of the cancellation rate for whatever is selected to the overall cancellation rate. Now I want to add a line that always shows me the cancellation rat

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

Dear Celonis users, I only know how to create a filter in KM and apply it to a table.  I would like to restrict the scope of filters, so that they will only have impact on one tab, when I put those filters in the filter bar. Is it possible to achieve this goal on Celonis web version?

Hi,What I’m trying to do is essentially pick the last but one non-automated user from the event log and pull it to object level. The previous non-automated user needs to be different from the last non-automated user.In the sample data shown below the desired output would be JANE.I’ve tried looping one PU_LAST and using it as filter for another PU_LAST but doesn't seem to be working.PU_LAST( OBJECT ,  EVENT_LOG , EVENT_LOG NOT IN (PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN (‘AUTOMATED’) ))  ,  ’AUTOMATED’).EVENT LOG ID USER 1 JACK 2 JANE 3 JOHN 4 AUTOMATED 5 JOHN  Any insights would be much appreciated.

Hi folks,what’s your thoughts about the OCEL standard for object-centric event data? Should Celonis support it and that way enable us to do ETL and keep log data outside outside the Celonis cloud, for instance in MS Azure?It would be interesting to hear if Celonis has given a thought about implementing OCEL or not.https://ocel-standard.org/1.0/

I have the following problem: I would like to upload a .XLSX file into my workspace via an ActionFlow. The .XLSX file is located on SharePoint Online. I can download the file using the "Download a File" action (Microsoft SharePoint Online) in the ActionFlow. However, I'm stuck at that point. In the output, the data is in "binary" format. How do I convert it from binary back to something I can import into a workspace? I have tried many things, but I just can't find the solution. Does anyone have any advice?