Product Q&A

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 rather orchestrate all the data loads in the Data Integration environment instead of using Process Automation modules to make a data transfer.Thanks for your support!BR THomas

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"."AssignmentNumber"),        CASE          WHEN "All_Items"."DocumentType" = 'CR'       

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 hierarchy level, Name is second, Order Value is the measure.Thanks in advance for your insights!

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 any other means than Buttons/Table interaction let me know.  

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?Best, Thomas   

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!

Hello,I’ve just finished the OCPM training. In there you create objects with multiple object to object relationships and events with multiple object to event relationsships. So e.g. the object “Expense” has a relationship to the “Report” object and the event “Approve Report” has multiple relationsships, e.g. to the object “Expense” and “Report”. The resulting Process Explorer can be seen in the right picture. As another test, I’ve duplicated the events and deleted all but one event to object relationsships. So each event has only one relationsship to one object. When displaying a Process Explorer with this Event Logs (see left picture), I get the same result as with multiple event to object relationsships. Also when filtering on tables with data from the source systems, i get the same filtered results on each of the Process Explorers.Am I missing something or what are the benefits of multiple event to object relationships?