Product Q&A

Hello,I am facing a somewhat specific problem with an Action Flow.I am using the Get rows module to retrieve, depending on the input variable, the column from one table or another. The variable directly affects the name of the table I am retrieving. No problem there; depending on the input parameter, the module behaves normally. The problem occurs in the next module, when I use the Text Aggregator to group the data according to this specific field. The name of the Get Rows module variable changes depending on the value of my input parameter. Here is what I tried to do, which works when the parameter is 1 but does not work when the input variable is 2.  Does anyone have any suggestions for this problem? Thank you, have a good evening. 

Good morning,I need to create a date filter for the start date on a graph, and the date is a user input, so I create a Date Picker as input box and save it as a variable.I struggle with the PQL in my graph FILTER PQL statement:FILTER “table”.”datecolumn” >= {d ‘${my_start_date_variable}’} But I get this error message  How do I adjust my PQL to get the date format correct? The date picker has a standard format that cannot be changed. I also tried this, and it does not work:FILTER “table”.”datecolumn” >= ({d '${my_start_date_variable}'}, FORMAT ( '%Y-%m-%d')) Any assistance will be appreciated.  Thank you,Denise

Hi everyone,we are using Object Link functionality to link Manufacturing Orders. In order to show the relevant predecessors and successors of one selected order (order number is written to variable aufnr) we filter as follows:This selects the respective order, but also all predecessors and successor orders.However, in this case, we only want to see the orders, that are created in the same plant, not from previous plants. E.g. in the following examples, the 2 first orders 1 and 2 of Plant A should not be selected, if the variable is set to Order 6.What is the best practice to filter in this case?Thank you, BR Philipp

Hi!Is it possible to change the Data Source of the transformations of celonis objects (OCPM)?Background: we have migrated a formerly external instance into our Celonis. Therefor we do have several redundant data extractions. I would like to consolidate them in one common Data pool (seperat of the other data pools). This means that I have to change the Data Source of existing celonis objects. But it seems that the Data Source is read only, once an object is created. Is there any solution for that? ...up to now, my only idea is to create views in the old, original data source for each table, that is moved to the new common data extraction pool.

Can we configure CC option in Emails triggered through Celonis Action Flow, without using Outlook component  

Hi,I’m trying to restrict access to my webhook-triggered Action Flow using the IP restriction feature.According to the documentation (https://docs.celonis.com/en/webhooks--action-flow-.html), this should be straightforward. However, I can’t find any field where I can add my IP addresses.Am I missing something?Thanks for your help!

Hello!I’m not sure how to present this problem so bare with me please.My level: I’ve built some simple views before and that’s it. I’m trying to get the TPT between 2 activities from different eventlogs and I expect to get the time between but get nothing.What am I doing wrong here?AVG(CALC_THROUGHPUT( FIRST_OCCURRENCE['e_custom_InboundStart'] TO LAST_OCCURRENCE['e_custom_OutboundMarkedAsLoaded'], REMAP_TIMESTAMPS( MERGE_EVENTLOG( "el_custom_PurchaseOrder"."TIMESTAMP", FILTER "el_custom_PurchaseOrder"."ACTIVITY" IN ('e_custom_InboundStart'), "el_custom_Outbound"."TIMESTAMP", FILTER "el_custom_Outbound"."ACTIVITY" IN ('e_custom_OutboundMarkedAsLoaded') ), HOURS ), MERGE_EVENTLOG( "el_custom_PurchaseOrder"."ACTIVITY", FILTER "el_custom_PurchaseOrder"."ACTIVITY" IN ('e_custom_InboundStart'), "el_custom_Outbound"."ACTIVITY", FILTER "el_custom_Outbound"."ACTIVITY" IN ('e_custom

Hello, For the moment my View trigger a Skill with input, and when triggered we can see some details about the record affected by the skill :Skill Input Form However when I change the Skill with an Action Flow it is not possible to show the details, it Only show the ID of the record. Do you know a way to do that with ActionFlows Inputs and Action ? Thanks 

Hi Team, I used Get Rows and added column names. Then created a Text Aggregator but i can;t see the columns created in the Get Rows, can anyone help me on this.  I need my column name like  “ 4.Invoice ID “ but i got only the Total number of bundles and Bundle Order Position. I tried publishing, ran only get row, re-loaded, even logout and retired.

I have a usecase in which I want to create an object-centric datamodel. According to the linked video below, it is possible to create events based on the attribute of an event (e.g. the event is order, but there are orders in different domains, e.g. games, clothing, …. which is saved as an attribute of this event). Populating this category as the event is possible in a simple case-centric example like explained in the video, but currently this seems impossible for object-centric models? Is this correct or am I missing something? I would like to avoid creating single events for each category.https://academy.celonis.com/learn/video/create-events-based-on-their-attributes

Hi Everyone! Is there a way to download the BPMN model from Process Explorer (New Views) so that I can use it in PAM?

How do I get to see what is the trend of events and connections as a business user? Order count with common number of events/connections - default view nowOrder count with least number of events/connectionsOrder count with most number of events/connections Finally, I want to build a histogram to determine what is average number of events/connections for orders to identify trends. 

Hi, This is my code called Cost. I added a filter to show only entries where the cost is null, but it still shows entries with values. SUM(PU_SUM(o_CELONIS_SALESORDERITEM, "o_custom_CostPerLine"."CostTransactionCurrency","o_custom_CostPerLine"."CostElement" IN ('00004', '40020', '400100',  '40220'))/"o_celonis_SalesOrderItem"."OrderedQuantity"*"o_custom_CustomerFinanceDocumentItem"."Quantity"+COALESCE(PU_SUM(o_CELONIS_SALESORDERITEM, "o_custom_CostPerLine"."CostperQuantityTransactionCurrency","o_custom_CostPerLine"."CostElement" IN ('46100'))/"o_celonis_SalesOrderItem"."OrderedQuantity"*"o_custom_CustomerFinanceDocumentItem"."Quantity",0))my Filter : Filter (exactly the cost code) is null Thank you for your help 

BackgroundThree tables and their relationship as below:VBAP(1) : VBFA(N) : Memo(1) RequirementI want to create a table with three columns: Column #1: “Reason Code”( From table: Memo , it is a dimension column)    , it is doneColumn #2 : “Memo#” ,  with PQL: COUNT(DISTINCT "memos"."vbeln" || ' ' || "memos"."mandt"   , it is done Need your help on this:Column#3:  “Total number of VBAP” . I don’t want the value of “Reason Code” cross filter table “VBAP” which means the all the value should be the same , for example: 13298   I have tried 2 PQL below:PQL#1:Global (  SUM (    PU_COUNT (      "Memos" ,      BIND (        "VBFA" ,        "VBAP"."VBELN"      )    )  )) PQL# 2:                GLOBAL ( COUNT_TABLE ( "VBAP" ) )I may also enable pre-filter in this table level. But the Column#3 “Total number of VBAP” should NOT be impacted.

Hi!Today I noticed that there is a “Transpile” button in SQL editing, and I would like to know if there is any documentation about it as I haven’t been able to find any.  Thankyou for your time

Team,This is a question regarding the CRISP DM framework. Can anyone suggest whether they have used the CRISP DM framework, either for their own process mining project or for creating project apps/platform apps in Celonis? Some of my research points to Celonis themselves using CRISP DM framework internally. Any information in this area is very much appreciated.Thanks in advance,Santhosh

Hi all,I’ve created a view that includes (among other components) a table.This table has an Action button that triggers an Action flow.Now, I’d like to hide the button when the user selects more than one row in the table.However, I haven’t found a filter that meets this requirement.Any helpful tips would be greatly appreciated.Thanks a lot!

Over the Join Functionality documentation page (Join functionality (celonis.com)), when we get an 'No Common Table' error message - a detailed explanation along with the join path is explained. As I am new to the Celonis world, I wonder how to use the mentioned path to achieve the corresponding result.  Thanks in advance.

Hi! How can I access dummy data to help with my build of my App? End goal is this app will be sold on Marketplace. I would need data for all of the core processes. 

Hello Celonis TeamI have a stupid question but I don’t find a solution yet.The following SAP tables are connectedVBAK 1:N VBAP 1:N LIPS N:1 LIKPMy challenge is to display a document flow within a table. This works - but only for VBAK/VBAP dataset which have an following LIPS/LIKP dataset. I expect to see the following: But as result I only get  My question: How to I configure the table that I also see VBAK/VBAP columns with no following LIPS/LIPS datasets? Best, Thomas

Hello everyone,I want to connect a whole dashboard via profile view to another dashboard. The connection is EKKO.EKGRP → the profile view dashboard will be filtered according to the purchasing group EKKO.EKGRP - so that works fine. My question is whether it is possible to map further criteria to be synced automatically with the profile view. In my case, the sync filter functionality standalone does not work as the time dimension e.g. in dashboard 1 != dashboard 2. So in case, I have selected the year 2025 in dashboard 1 (Base _CEL_P2P_ACITIVITIES.EVENTTIME) - the sync filter does not work as the time dimension in dashboard 2 (CUSTOMIZEDTABLE.ERDAT) is not the same. Is this somehow possible? The profile view which I have connected also contains a filter bar which is not accessible when connecting it. Is this also possible? Thanks for your help! Best regardsJulia Bauer 

Hello , I have a homepage with links to other dashboards. I want to keep the filters, and when I click on a link, it should bring back the filter already selected on the homepage. Thank you.I used a Celonis EMS old version ( I don't have visibility for a filter selection)

Hi Community,Editing an action flow, I want make a different module the initial one, without deleting the current one. Is it possible? Regards, Repsol Support Team

Hi everyone,we are currently restructuring our data architecture in Celonis. For each process area (P2P, AP, AR), we have separate data pools where we extract, transform, and load the respective data models.In the AP area, we already use a dedicated Central Extraction Pool, which only handles the extraction of raw tables. The actual AP data pool then receives these extracted tables and performs the transformations.Now, we want to extend this concept gradually to other areas. For example, we plan to stop extracting the CDPOS table in the Purchasing Pool and instead consume it from the Central Pool. This step-by-step migration should help us reduce redundancy and improve maintainability.However, I have a specific question regarding this setup: If I start consuming tables from the Central Pool in the Purchasing Pool (e.g., CDPOS), what happens to other tables like EKKO, which are still being extracted directly in the Purchasing Pool?Will my transformations in the Purchasing Pool use the l

Hi Community,I’m working on cleaning up our data pools in OCPM, which currently include:Migrated CPM → OCPM pools New OCPM pools Pools that extract data directly from source systems Pools that combine multiple source extractions Derived data pools (with filters, perspectives, etc.)What is a good way to organize or separate these different types of data pools? Specifically:Is there a recommended approach to distinguish source-based pools from combined or derived pools? Are there best practices for naming conventions to make it easier to manage and identify them? How can I easily see which data pools are connected to which assets (apps, views, packages)?Any guidance or examples would be greatly appreciated!Thanks in advance,ShalinI am aware of this question, but it was posted a while ago and does not provide the granularity I am looking for🙁https://community.celonis.com/topic/show?tid=4263&fid=2