Unanswered Questions

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 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 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 have been applied.  Any ideas to solve this? Thank you in advance!

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.  

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

Hello, I have an issue with a large number of Action Flow connections being saved under every analyst’s account, and wonder if it is possible to remove them, so that every analyst will only have 1 connection (via their API key) associated with the Action Flows. If it is unclear what I mean, under some Action Flow module (e.g. Query Data), there is a list of connections that you can use to get the module working, which I am trying to delete and establish only 1.  

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 Creating Charts in Views Celonis Release Notes Thanks in advance for your help or clarification! 🙏— Rajesh

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 ( FIRST_OCCURRENCE [ 'Create Purchase Order Item'] TO FIRST_OCCURRENCE [ 'Record Goods Receipt' ] , REMAP_TIMESTAMPS ("_CEL_EKPO_ACTIVITIES"."EVENTTIME"

Hi everyone,I'm currently working on a use case in Celonis and could use some help with a PQL rule I'm trying to build.I have a table called HOTEL that contains travel records, each with a start date and end date. I want to validate that every single day within the travel period is marked with a "J" in a calendar table called CALENDAR.For each travel record in HOTEL, I want to:Iterate over all dates between STARTDATUM and ENDDATUM. Check if the corresponding calendar entry for each date has the value "J". If any date within the range does not have "J", I want to flag it as an error.Does anyone have an idea how to solve this problem in a pql formula as a KPI?Thanks in advance 🙌Niels

Good day, I have an OCPM data model with 2 objects, a case and a user. I need to select my case eventlog as the default eventlog. How do I do that? I know I can create an eventlog in Perspectives and make it the default eventlog but I dont want to create an additional eventlog , I want to select the existing case eventlog as the default eventlog. Thank you

Hi everyone, I have an issue that I would like to share in case anyone knows how to solve it.I’m currently looking for a way to send messages to multiple end users by Google Chat. I don’t want to send messages to a group, but instead to end users. I noticed that Celonis provides a module called "Inject Message Into Room", but I need the webhook URL from each user. Additionally, I cannot send messages bigger than 4096 characters.Does anyone know if there is another module where I can use just the email address from users to send a message through Google Chat to each one of them, and change the length of the message body limitation, since there are some messages that might exceed the 4096 characters.Thanks! 

Hi    We are seeing a strange issue where we are using the exact same formula as in Analysis for a KPI, however the data on excel generated by action flow is about 2% different from that on the analysis sheet. Has anyone encountered similar situation and what was the resolution? 

Hi everyone,I’m exploring the idea of creating a view for supplier evaluations where the supplier’s logo changes dynamically – meaning the correct logo is displayed depending on the selected supplier.My idea was to use a variable in the image component to call the specific URL for each logo. Currently, this doesn’t seem to be possible.Is this something you are looking into, or are there any workarounds? I’d love to hear your experiences.Thanks & best regards,Jan

Hey all,I have a process where I have four activities labeled: A, B, C, D.In the event log I have for one case equal timestamps for B and C: 08:11:00 until 08:23:00.My problem is that Celonis visualizes this process as A → B → C → D, however I expect the process to look like A → B, C → D. Is there any way to do this, and if so, how?

Hi,We are very interested in becoming a services and consulting partner for Celonis in South Africa. With our mix of Industrial Engineering and data management expertise across mining, manufacturing, logistics, hospitality and financial services we believe we could provide an incredible service in this country by implementing Celonis and working with customers to realise real returns. There are a significant number of Tier one companies across the above sectors that would benefit.I would ask someone from Celonis to contact me please to understand how a potential formal relationship would be structured and would work.  Many thanks,Alex StampEntity IM (Pty) Ltd (www.entitysa.co.za)

Hello,I'm trying to make the DSO indicator, but I need to get data from several tables and I'm having problems...The DSO formula is made up of two parts, Revenue and Accounts Receivable. I need to calculate each one individually and then divide one by the other.I'll use the example of Accounts Receivable:Quando eu uso os campos de Filtro, com os seguintes filtros, funciona sem problemas:FILTER "o_celonis_SalesOrder"."CompanyCodeText" IN ('CompanyNameZYX');FILTER "o_celonis_SalesOrder"."SalesDocumentType" IN ('XXXX', 'YYYY');FILTER "o_custom_CustomerAccountItem"."BaselineDate" <= {t ${end_date}};FILTER "o_custom_CustomerAccountItem"."ClearingDate" > {t ${end_date}} OR "o_custom_CustomerAccountItem"."ClearingDate" IS NULLHowever, when I try to place the same filters in Case when, to generate the indicator that will be combined with Billing, there is a connection problem between the tables (o_celonis_SalesOrder and o_custom_CustomerAccountItem).sum( CASE WHEN "o_celonis_SalesOrd

Hi Team,I’m trying to send data from one Action Flow to another without using a webhook. Is that possible? Thanks in advance for your help!