General Product Q&A

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

We have a Celonis view with KPIs defined in the Knowledge Model. These KPIs use time-based filters with variables like datefrom and dateto inside the PQL-code.For example:"o_celonis_VendorInvoiceItem"."CreationTime" NOT BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1)and elsewhere in the same KPI:"el_custom_SalesOrderItem"."TIMESTAMP" BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1) When exporting this view to Excel via Action Flows, the Get Rows module lets me reference the Knowledge Model, but I cannot pass values for these variables.Using the Data Model instead allows variable injection in PQL, but then I lose access to predefined KPIs and calculated attributes, resulting in very complex, hard-to-maintain code.Question:Is there a way to dynamically set the variables of Knowledge Model KPIs when using Action Flows?

Hello!I’m not sure how to present this problem so bare with me please.My level: I’ve built some simple views before and that’s it. I’m trying to get the TPT between 2 activities from different eventlogs and I expect to get the time between but get nothing.What am I doing wrong here?AVG(CALC_THROUGHPUT( FIRST_OCCURRENCE['e_custom_InboundStart'] TO LAST_OCCURRENCE['e_custom_OutboundMarkedAsLoaded'], REMAP_TIMESTAMPS( MERGE_EVENTLOG( "el_custom_PurchaseOrder"."TIMESTAMP", FILTER "el_custom_PurchaseOrder"."ACTIVITY" IN ('e_custom_InboundStart'), "el_custom_Outbound"."TIMESTAMP", FILTER "el_custom_Outbound"."ACTIVITY" IN ('e_custom_OutboundMarkedAsLoaded') ), HOURS ), MERGE_EVENTLOG( "el_custom_PurchaseOrder"."ACTIVITY",

Hi all I am currenlty investigating very basic Visualizations in Process Explorer.Ultimately I want the User to be able to include/exclude Activities in a matter where they are actually excluded form the the Directly Follows relations which are the edges of the graph.  as a minimal example lets say I have only Act A, Act B and Act C and only one case with variant A->B ->C. If B gets deselected I want the process explorer show to show A->C then. The existing Graph Control Panel only hides the activities so it would actually remove B and A->B and A-> and no data remains. I just stumbled across the REMAP VALUE (Activitycol, ('B', NULL)) PQL which would allows me to create a second event log in KM where I can then do the REMAP but only preemtively and hardcoded. I want the user to give some degree of freedom and customization the dashboard to select either a whole Event Log to be used (then I would just prepare 2 or

One of my customers is asking for a detailed comparison of features between Celonis and Signavio. Can any one provide a link or document regarding this please?

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 

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