Product Q&A

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

We can update augmented attributes via an Action flow, but is there a way to mass-update directly from PyCelonis?

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?

Hello Celonis Team,one question to the Intelligence API. We want to use the intelligence API to extract and reuse date with other systems.Currently my developer is struggling with the pageSize Limit (Max. 50). When we have an high amount of selected records e.g. 1000+ he must loop over all pages the get the data in his 3rd party data pool.The question is: Is it possible to disable the pageSize Limit. So when the result are 10000 records, I want to have this 10000 records on one page.One further question is regarding how to hand over data to the Intelligence API. I learned I can the params kpi and data to select the data from the knowledge model.However, I have discovered that I can also manually create records in the Knowledge Model and consolidate data there. I can also the this manually created record within the Intelligence APIMy question: Are manual created records in the knowledge model still a supported feature in Celonis or Legacy? I

After creating my target model in the Process Adherence Manager, I want to be notified about:Missing events Unexpected events Incorrect event orderWhat is the best way to connect the results from the Process Adherence Manager to an Action Flow, so that I can automatically trigger alerts or follow-up actions based on these deviations?

Hi,I have a defined KPI in my knowledge model to calculate the median throughput time for my process: MEDIAN (CALC_THROUGHPUT ( CASE_START TO CASE_END , REMAP_TIMESTAMPS ( "CONSUMER_APR_ACTIVITY_TABLE"."EVENT_DATE" , DAYS ) ))I’d like to be able to compare median throughput times for all cases and only for cases which include a certain activity (for example: PENDING). I’d like to use either a table or a bar chart for this comparison.What would be the best way to achieve that, considering that table filters apply on all columns? Can I introduce another KPI which will determine the median for cases which include PENDING only? If yes, how can I do that?I look forward to receiving advice. Thanks.Kind regards, Vladimir

Hi,Shall we consider Production Order Journey as Work Order Journey.   

It would be helpful to allow admins to “View As” an end user in Studio/App interface, so that we could verify the permissions interactions from that user’s perspective. 

Hi, I would like to know if it is possible to update a custom field for an issue in JIRA via action flows. I was checking the documentation, and it seems that it is only possible to update certain standard fields. Does anyone have any experience with JIRA modules?Thanks!

Dear community, I would like to set up a data pool parameter to allow me to switch between test and prod environment? So I would need two global variables for my data jobs:var_data_source: to allow me switch between test schema and prod schema var_table_name: to allow me when creating table to add _test at the end of the table nameI have only found the way to create parameters in EACH data job under transformation and refer to the data pool parameter. Is there a smarter way? I am still using the data integration (not OCPM). Thanks a lot!   

How can i enroll for introduction to process mining course. I do not see the enroll option….

はじめまして。Celonisのバリアントエクスプローラーのエラーについて、投稿いたします。現在、View内に設置したバリアントエクスプローラーを開くと以下のエラーが発生します。・直接開いた場合　Variant Explorer [id:variant-explorer-531a92c8-92cd-4f1f-a10e-86a23a3ae35c]: Invalid PQL query. VARIANT: The specified activity column ["_CEL_PGM_WLM_VE_ACTIVITIES"."ACTIVITY_EN"] contains 36487 distinct activities. However, this component only supports 32767 distinct activities. Please review your PQL statements in the Knowledge Model and in the View YAML filters.原因と対応策について、ご意見いただけないでしょうか。よろしくお願いいたします。　

Using Intelligence API, how to get to the pql statement behind the filter

Hi everyone,I'm doing my master's thesis focusing on the user experience of dashboards in process intelligence platforms.If you use Celonis dashboards as part of your day-to-day work, you’re exactly the kind of person I’m hoping to hear from!I’d be super grateful if you could complete my survey.It takes about 10 mins, and your input would really help support my research 🙏Thank you so much in advance 😊 And feel free to pass it along to anyone you think might be a good fit!