General Product Q&A

Hi, This is my code called Cost. I added a filter to show only entries where the cost is null, but it still shows entries with values. SUM(PU_SUM(o_CELONIS_SALESORDERITEM, "o_custom_CostPerLine"."CostTransactionCurrency","o_custom_CostPerLine"."CostElement" IN ('00004', '40020', '400100',  '40220'))/"o_celonis_SalesOrderItem"."OrderedQuantity"*"o_custom_CustomerFinanceDocumentItem"."Quantity"+COALESCE(PU_SUM(o_CELONIS_SALESORDERITEM, "o_custom_CostPerLine"."CostperQuantityTransactionCurrency","o_custom_CostPerLine"."CostElement" IN ('46100'))/"o_celonis_SalesOrderItem"."OrderedQuantity"*"o_custom_CustomerFinanceDocumentItem"."Quantity",0))my Filter : Filter (exactly the cost code) is null Thank you for your help 

Is it possible to embed an image (customer logo) in an Action Flow Outlook email body?I read the related topic “Action Flow-Screenshot of an analysis as image in a mail body” but that thread has been inactive for ~ 1yr and it does not appear it was successful. The Outlook module also has its own nuances to it (text body content vs html...).Thanks

Team,This is a question regarding the CRISP DM framework. Can anyone suggest whether they have used the CRISP DM framework, either for their own process mining project or for creating project apps/platform apps in Celonis? Some of my research points to Celonis themselves using CRISP DM framework internally. Any information in this area is very much appreciated.Thanks in advance,Santhosh

Hi all,I’ve created a view that includes (among other components) a table.This table has an Action button that triggers an Action flow.Now, I’d like to hide the button when the user selects more than one row in the table.However, I haven’t found a filter that meets this requirement.Any helpful tips would be greatly appreciated.Thanks a lot!

Hi all, I am wondering about how to best setup the user permissions for my end-users of a package.I have two different groups of end-users (=Groups in admin & Settings panel). First one is a huge group of plain normal endusers who should have read access to a myrad of assets within the package lets call them “Read Users”.Then I have a single special “Settings View” which is used to set and edit specific Augmented Attributes which steer the. The editing of said augmented Attributes shall only be done by a small group of higher privilege “Admin Users”.see minimal example: I would prefer to give Read Users access on Package level as there are 30+ different assets they need access to. But I need to exclude them from editing the settings in “Settings View”. I can imagine that

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

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

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!

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,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

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!

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!

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,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 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 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