Product Q&A

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!

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? 

Hi There,We’d like to integrate our Celonis (SaaS) solution to one of our other cloud applications (ServiceNOW) using the other application’s REST API. We need to deploy a VPN for this integration to ensure secure communication. Does Celonis SaaS (or the underlying platform Azure/Amazon) provide a means for deploying a VPN? e.g. Azure VPN Gateway or AWS Transit Gateway Kind Regards, Seamus

I have 2 different data source and initially i build my objects and events in one data source and next i have expanded it to other data source. When i made changes and published to development the perspectives have failed and this had impacted the views that are built on Production perspectivesOnce the issue is solved with perspectives the views are again back to normal is there any link between test perspectives and production perspectives. 

Hi team,I’ve solved duplicates in Object table, Object Change table and Events tables with ROW_NUMBER() OVER (PARTITION BY A."CASE_KEY") meaning each row is unique, and still I receive the below error from Celonis: The data model contained joins that could not be executed in the user-defined direction due to duplicates in the dimension table. Please review the foreign key connections in Data Integration. The joins of the following tables have been executed successfully in the reverse direction: [Event table]1 --> N[Object table] Does someone have any idea on how to solve it?When there are duplicates on both tables, the model doesn’t even upload. In this case the duplicates seem to be in the Dimension table (I assume, is this the object table?) and therefore the model has been uploaded, but I’m not sure all the connections

Hi everyone, We have several ABC Classifications that we need to implement in Celonis and I’m simply curious:Why is the ABC classification resulting in a 1, 2, 3 ranking? I’m ending up having to convert to string and remap the values for each classification so that it makes sense for the users and while it’s not a huge issue, I think it would be easier if the function just resulted in A, B, C directly. Is it for efficiency by using integers?  Or does this allow for some further analysis that I’m not seeing at the moment maybe? Best regards,Benjamin

Hello everyone, 👋I’m building an overlay view to show case details, using number as a variable.Currently, the overlay view has a predefined filter like this:FILTER "sc_req_item"."number" = '${number}'; However, I’d like to make the overlay more dynamic — for example, use another variable ${case_table} to replace "sc_req_item" (or even "sc_req_item"."number") so that the same detail view can work for multiple case types, such as Requests, Request Items, and Tasks. Has anyone successfully used a variable for table or column names in a FILTER statement (or found another way to make one detail page work dynamically across multiple case tables)?Any insights or workarounds would be really appreciated! 🙏 Thanks!BR,Xiangxiang

Has anyone experience on connecting Celonis with SAP Business One (BOne)?How easy is the connection? 

Hi,We are currently exploring celonis and would like to understand how can celonis help in application modernization and how does it align to application assessment / reverse engineering. I came across this link: Intelligent Enterprise Modernization | Celonis but was unable to find detailed information in the product documentation.Would really appreciate any lead/reference.Thanks

Hi Team, We’ve signals configured in action engine and have set actions under each skill one of them being “Forward Signal Via Email”. This gives flexibity to signal owner to modify the email body, recepient list,etc before sending/forwarding the signal to anyone. But I wanted to check what will be to from email address for these email and how can change the From email address of that mail as recepient will be respoding to the email and I want that to reach to specific from address I have been setting. Thanks & RegardsChethan Shetty

Hi everyone,I’m using the Grouped Column chart in Celonis Views, and I noticed that the data label position (currently displayed in the center of each bar) can’t be changed to the top or outside end — unlike in Analysis charts, where this option is available under formatting.Can anyone confirm if the label positioning feature is planned for a future Views release, or if it’s already available in any recent update?I reviewed the documentation below but couldn’t find a clear mention for Views specifically: Analysis — Charts and Tables — Settings

Hey, I’m beginner in Celonis and started my learning. I wanted to know Can we build a user form which helps me to collect the data from user and store it designated table. I also have set of rules for forms like show this field if user in particular role or make the field editable only if certain condition matches with current logged in user otherwise just keep it as read only and so on. Can this be achievable in celonis. Looking forward for response. Note: Pease share screenshot how it will look if you have anything sharable in this forum. Thanks & RegardsChethan Shetty

Hello all, I’m currently working on combining various cycle times (e.g. from PO Item creation to Goods Receipt, or from Goods Receipt to Invoice Receipt) with key figures from my Case Table in a single OLAP table.To achieve this, I’ve tested two different approaches:Cycle Time Calculation Based on the Activity Table: This method allows me to control which occurrence to consider — for example, in cases of multiple GRNs for the same PO line, I can choose to include only the first one. The formula delivers the expected results. However, I’m unable to combine this approach with other key figures from my Case Table (e.g. Company Code, PO Item Count, etc.) in the same OLAP table. Additionally, if the cycle time is negative (e.g. GRN before PO Item creation), the formula returns “–” instead of the actual negative value.   AVG(CALC_THROUGHPUT ( F