General Product Q&A

I am trying to find potential use cases on general accounting and bank reconciliation process/intercompany transactions. Any help on this?

I know want o create an Action Flow that sends an individual Email to each Material Manager (Note that there could be over 50). The Email should contain the following information:If a material of the MM has a negative stock or the stock becomes negative in the future the Email should contain this number togehter with the first date date where this happens and the corresponding stock. If this is true for multipe Material numbers they should all be in one Mail. Examples how the Output should look like are also in the Excel-Attachment. To get the first negative values I tried using fomulas analog to this one because it workes in a view but it does not seem to work in the query-node in the action flow. "PU_FIRST (DOMAIN_TABLE("Material Number"),"Stock","Stock"< 0)" Also I havent found a way how to create individual aggregated email for each Material Manager Does somebody have an idea how to solve this?

I am curious to know “how to objectively evaluate Celonis as a solution” for process analytics and process mining. Is there any best practice / a checklist to assess the long-term viability of using Celonis for each new business use case? I am able to create awareness around the basic differentiations between Data Analytics and Process Mining, but I'm not sure what factors to consider to make a quantitative assessment for wider education and evangelization. Expectation management around the solution should be handled with objectively. Seeking some ideas here from the wider users.

Hello, we are going to make a short presentation (approx. 15 min) of Celonis to our executives (including CEO) who have no previous knowledge. The purpose is to give them a general overview of the potential and the benefits of a partnership. So we need a somewhat short presentation (considering the time will be only 15mins) describing the basic functionalities the benefits we will have as a partner and the impact it will have on the end customer. We are already working on a presentation but we have limited time and we don't want to leave something important outside. So is there any existing presentation of Celonis used in such cases. P.S. I don't know if this is the right place for this question, in any case thank you in advance. Best, Thymios

I need to add aaranyi@schema31.it and I need to remove fgiannuzzi@schema31.it ThxS

How is the membership to 'my team' arranged in Celopeers? Background: We have several users in Celopeers, belonging to a Celonis EMS-team, but cannot view cases created by the colleagues.

Hello everyone, are there any advanced use cases (Material management, P2P-Cockpit, whatever, ...) where one can simply see advanced PQL-functions in action? (For free)I am struggling with advanced PQL-Functions (Nested PU-and BIND-Functions, Domain_Tables, ...) and the learning curve is quite harsh without any actual real world help and examples. Especially Material Flow Management. Like e.g. Analysises about current stock, stock evaluation (future arriving orders vs future used material), stock over time (Stock + Arrived orders - Reserved material for production) etc. The idea behind such things is in my head. But the actual functions to combine the data accross multiple tables is still really advanced.  I´d love to see some examples somewhere. I dont know if Celonis provides something like that? I feel like a lot of stuff is kind of behind paywalls (Consulting firms).

Using action flow can we directly get the data from data pool without using data model

I see the word custom process in Celonis Academy, what is a custom process? For example, is importing the add-on SAP into Celonis a custom process?

Hi Celopeers, Can anyone help with a filter function to select all cases in a 12 month period leading up to a specific date? So like all cases in the 12 months to 30th April 2023?

I want to create an ABAP report to extract data, where do I start?

XES file upload in Celonis Free Plan doesn't load. File upload works, but the step 2 (configure-activity-columns) doesn't load the screen. Data set I'm trying to use is: https://data.4tu.nl/articles/_/12716513/1 I have set the limit of the space to 20Gb, so this should be enough.

Hi. In views, when designing a benchmark tab, I want to link both the PE and KPI lists to the chosen dimension.I select a dimension in a first dropdown (eg. Company Code) , then select the different company codes I'm trying to compare (in a different pair of dropdowns), but these components (Process Explorer, KPIs, etc..) do not update. In analysis I'd need to create a component filter, but how to proceed working on views?

Is there any best way to identify unused tables and fields from knowledge Models/ Data Models

I am trying to combine multiple KPIs into a CSV, but it doesn't seem to work.Each KPI has different filter so I'm using several Celonis modules to separately get those KPIs. Please refer to the screenshot below. I had the following two problems:(1) The third Celonis module appears to be running repeatedly many times. So I had to stop the Action Flow manually.(2) The CSV file also has a very large number of rows than expected. Multiple rows of the same Company appear. Originally, one company with one row is expected.  Is there any method to combine multiple KPIs with different filters into a CSV?Should I use Iterator/Aggregator to combine those modules? Yours,Chen

What do I have to do to copy the data pool?

I want to create a filter of an ELSE inside my condition. The   ELSE 'Área Não Aderente'. Below script. I want to bring only the data from this ELSE, which would be the opposite of my condition below.  CASE WHEN       ("EKKO"."BSART" LIKE 'Y%' OR "EKKO"."BSART" LIKE 'PE' OR ("EKKO"."BSART" LIKE 'Z%' AND "EKKO"."BSART" NOT IN ('ZCG','ZPM', 'ZCAT')))    AND     ("EKKO"."EKGRP" LIKE 'I%' OR "EKKO"."EKGRP" IN_LIKE ('%1I','%2I','%3I','%4I','%5I','%6I','%7I','%8I','%9I') OR "EKKO"."EKGRP" LIKE 'A%' OR "EKKO"."EKGRP" LIKE '01A')        THEN -- Pedido por Área     CASE WHEN         PU_COUNT("EKKO", "EKPO"."MATNR", "EKPO"."MATNR" IN_LIKE (

I need to filter documents by taking the current month. Ex.: Filter documents from the year 2023 taking the month of MAY(Current)

I want to create a filter of an ELSE inside my condition. The  ELSE 'Área Não Aderente'. Below script. I want to bring only the data from this ELSE, which would be the opposite of my condition below.  CASE WHEN   ("EKKO"."BSART" LIKE 'Y%' OR "EKKO"."BSART" LIKE 'PE' OR ("EKKO"."BSART" LIKE 'Z%' AND "EKKO"."BSART" NOT IN ('ZCG','ZPM', 'ZCAT')))  AND  ("EKKO"."EKGRP" LIKE 'I%' OR "EKKO"."EKGRP" IN_LIKE ('%1I','%2I','%3I','%4I','%5I','%6I','%7I','%8I','%9I') OR "EKKO"."EKGRP" LIKE 'A%' OR "EKKO"."EKGRP" LIKE '01A')    THEN -- Pedido por Área   CASE WHEN    PU_COUNT("EKKO", "EKPO"."MATNR", "EKPO"."MATNR" IN_LIKE ('%3001009%',

is there any way, if we can freeze one column on OLAP table and put filters on rest of the columns on the same table??

We have a requirement to connect multiple source systems with the celonis process mining application and then merge event logs from these different source systems to show end-to-end process flow. Also, we wanted to understand how different source systems like Salesforce CRM, SAP ERP, and custom business applications can be combined integrated with celonis process mining application to show the end-to-end interconnected business processes that are flowing through these source systems. Is it possible to combine these event logs from the different source systems within celonis process mining or do we have to connect these different source systems to the datalake system and then perform an event log merge outside of the celonis process mining application.

Hi all,  Now I'm looking for the detailed technical document for O2C connector on celonis market place, that contain case table definition that should have column information what the column stands for.Does anybody know such a document?  Thanks

I need a filter that doesn't bring me the documents of the current month.