Product Q&A

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",

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 all I am currenlty investigating very basic Visualizations in Process Explorer.Ultimately I want the User to be able to include/exclude Activities in a matter where they are actually excluded form the the Directly Follows relations which are the edges of the graph.  as a minimal example lets say I have only Act A, Act B and Act C and only one case with variant A->B ->C. If B gets deselected I want the process explorer show to show A->C then. The existing Graph Control Panel only hides the activities so it would actually remove B and A->B and A-> and no data remains. I just stumbled across the REMAP VALUE (Activitycol, ('B', NULL)) PQL which would allows me to create a second event log in KM where I can then do the REMAP but only preemtively and hardcoded. I want the user to give some degree of freedom and customization the dashboard to select either a whole Event Log to be used (then I would just prepare 2 or

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"

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 

CELONIS BUSINESS ANALYST VIRTUAL INTERNSHIP how to i access this internship i got through aicte platform

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,We have built an application is Celonis. We need to register this app in the marketplace. Anyone guide me on how to register an app in celonis marketplace? Regards,Aravanan. M

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 transformat

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

Hello,I am trying to get data from a Microsoft sharepoint list to the Celonis Platform.According to the Flowchart provided by the API-Team - When to use the Standard Data Ingestion API (and other methods) - the extractor builder should be used for a Sharepoint data transfer, since the REST API is exposed.I tried to set up the connection, but I fail when configuring the endpoint, since I get xml-data even if I specify that I would like to have a json structure (Request Parameter - Accept: application/json;odata=verbose)Does anyone have experience with connecting the MS universe with the Celonis universe?I also found a workaround that works (Push CSV to Data Integration), but I would rat

Hi everyone,has anyone here worked with Coupa’s APIs — especially the requisition_revision_records and requisition_revision_record$requisition-lines APIs?Does anyone know if these are still supported by Coupa?Many thanks.

Hello,I need some help with building a PQL query that will match two different documents by a specific criterion.Let’s say I have a table with all open and closed items — we’ll call it ‘All_Items’. This table includes various document types like RV, BK, CR, etc.I’m trying to build a logic in PQL to identify cases where one document type (for example, RV) is matched with another document type (for example, CR) within the same table. The key condition is: The RV document’s Reference Number should match the CR document’s Assignment Number.I want to write a logic that can detect these matches, possibly using a CASE structure or a domain table approach. Here's what I have so far, but this logic isn’t working since the condition checks if CR document has same AssignmentNumber and ReferenceNumber:CASE  WHEN "All_Items"."DocumentType" = 'RV'  THEN    CASE      WHEN PU_COUNT(        DOMAIN_TABLE("All_Items"."As