Product Q&A

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

Hi Community,I’m working with Treemap charts in Celonis and noticed something I’d like to clarify:On the initial view, only one hierarchy level is visible (e.g., Category). To see the next level (e.g., Name), I need to click and drill down. The area size is calculated based on the numeric measure (e.g., Order Value), and the Category is used for grouping and color coding.Is this the expected behavior in Celonis?Or is there a way to show multiple hierarchy levels at once (similar to Excel or Power BI Treemaps)?Here’s what I tried:Structured data as: Category Name Order ValueMachines Supplier A 12000Machines Supplier B 8000Electronics Supplier C 15000Electronics Supplier D 5000 Category is the first

I have issues with the responsibility of Celonis environement on iPad. I used multiple browsers and always request Desktop site. Often the bottom part of the screen is outside of the display (this is where usually the save button is for studio.) There is no way to scroll down to show it.Are there any way to effectively work with studio on iPad?Thanks!

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

Is it possible to create a button that updates a runtime (or View) variable with a KPI value?Usage example:User clicks Button → KPI returns 5000 → variable gets overwritten with 5000By the looks of it I can only update a variable with static values, and there’s no way for me to reference a KPI.

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

I have a strange issue while creating copilot. I want the copilot to read data from one table only. The table contains creation date, closure date, case id. While simple questions like created cases in June are ok for the copilot to handle, wekely or daily trend charts are not produced. The copilot can’t extract week or month no from date columns to produce the trend charts. AI services enabled are: Claude 3.7 Sonnet (AWS)GPT 4o (Azure OpenAI) From time to time the copilot get’s frozen while thinking, it can take up to few hours for it to spin without results. Anyone faces similar issues? 

Hi all,I have a question relating to “hygiene” in data pools.In my organisation we use manual data ingestion and upload files into our data pools. Over time, a large number of files and tables was added and created. I’d like to do a bit of house-keeping and remove obsolete/ unused files. How can I do that? I have analyst access.I look forward to hearing from you. Thanks.Kind regards,Vladimir

Hi all, I have a bit of an advanced nut to crack here so any approaches no matter how complex are welcome.To create a nice user experience I want to open another view via a Button (or also via table cell interaction). However a view variable should steer which view to open.Context:I have one table which lists and sorts all type of problems . Its purpose is to get an overview and decide what to work on so lets call it “Overview”. Once selecting a problem more details are needed. Those are driven by the type of problem at hand. Hence I need a way to click “Open Details” and depending on variable it opens and passes variable to “Detail View A” or “Detail View B”.The behaviour I want to achieve is:Click within “Overview” on a Problem of type A → Open “Detail View A”Click within “Overview” on a Problem of type B → Open “Detail View B”If you have any idea on how to facilitate this navigation (maybe via javascript) or

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.

Hi,looking for idea how to manage issue with action flow execution. It results with error message and it is causing action flow to fail. Issue description: Action Flows which updates an augmented attribute fails to execute with error message: “Data Model row doesn't exist or no permission to query” Other information:  Permissions are correct, checked with other users.The reasons seems to be due to missing data in augmented table. The table in data model after being refreshed no longer has a value, for which the action flow tries to update the change in KM. Looks like the augmented table and data model table are desynchronized. Appreciate Your advice.Michał

Hello Community,I have the following “problem,” or am I misunderstanding something here?SAP Example I have an Sales Order (Table VBAK) with 6 items (Table VBAP). On Item has the Category “TAX” (Field VBAP.PSTYV)Within the Knowledge Model I have set an global filter FILTER VBAP.PSTYV NOT IN (‘TAX’)This works as expected and I only see only 5 items when I display the data in flat table or using the count function e.g. COUNT(VBAP.POSNR)But when I use the PU_COUNT Function PU_COUNT(VBAK, VBAP.POSNR) I get 6 items as result.My question here: Is this expected behaviour and does PU_FUNCTION ignore global knowledge model filters? Or is this a bug?