General Product Q&A

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 community, I have seen that some features are not working perfectly in the Studo Analysis and there are a lot of migration tool available from Studio Analysis to Views. Is there known the future of Studio Analysis? We have quite some use cases still in this older technology and I would like to assess the urge for migration. Thanks a lot.Jan

Hi, is there a way to see/use autogenerated KPI in the View?

Is there a way to copy an existing asset to a blank tab on another asset within the same package?Context: Separate assets were created vs tabs but want to combine into the same asset so the filtering is carried out through all tabs. Will I have to recreate the “separate” assets within the new tab?

We have 2 spaces for P2P. 1 is P2P dev and other is P2P. The P2P is the one when we deploy users see. So there was a change made by 1 person in P2P dev which I used copy to and I have overwritten the original view in P2P and Published it. Later I got to know few people have crucial changes in P2P which got overwritten and they had not published the changes as well. Is there any way we can revert back to way it was?

“Managing existing users” page (https://docs.celonis.com/en/managing-existing-users.html) is outdated.It is possible to lock users with the “User locking policy” setting but I see no option to unlock them.The only bypass I found was to remove users then to reinvite them. 

I want to calculate cumulative sum for column ‘Net Weight’ by Year . Below picture is result i want to have.Column definition:‘SO Created Year’ = ROUND_YEAR("VBAK"."ERDAT") ‘Created Month’ = ROUND_MONTH("VBAK"."ERDAT") ‘Net Weight’ =  KPI(“so_netweight”) Cumulative Sum=         if I use formula : RUNNING_SUM(kpi("so_netweight"),order by("vbak"."so_creatd_year"), partition by("vbak"."created_month_so_"))  , i got below error.  can anyone help ?

I have two pages: Page 1 and Page 2. Both have a "Filer Dropdown" component that allows users to select a plant value.My question is,if a user selects a plant value on Page1, will this value be synchronized with Page2? Or, does the user need to select the same plant value on Page 2 again?Similarly, if a user selects a plant value on Page2, I would like this value to be synchronized with Page1.

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

Hey Celopeers, I want to create a Table within a View wihich contains 4 columns. One Column is the Dimension Column (Gives 15 Rows). In one column the numer of invoices for the current month are counted. In the other column the number of invoices from the previous month and in the last column the number of invoices for the month before last.  The user want to have the coulmn names in the format "YYYY/MM" and the column names should be dynamic, so that in the new month the column names are updated automatically. We are using the Knowledge Model - View Technology and no analysis. I also thought of using a chart diagramm, but the users require a table. I tried some things, but nothing worked. So if somebody knows about how to create dynamic columns I would be very thankful for your help :D  

Hallo Celonis support, We have implemented Celonis RFC Module and Extractor on our SAP ECC system by importing Transport AI1K901056. Since 2023, we have discontinued Celonis license. How can we get the RFC Module Deletion Transport and clean all the cached datas ? On our SAP system, following Celonis packages are installed:  /CELONIS/CLTM                 Celonis Changelog & Trigger Ma /CELONIS/CL_DATA_EXTRACTION    Celonis change log extractions /CELONIS/CONTROLLERS           Celonis Controller for Extract /CELONIS/CORE                  CELONIS CORE UTILITIES /CELONIS/DATA_EXTRACTION       elonis Data Extraction /CELONIS/EXT                  Celonis extensions /CELONIS/EXTRACTOR             Celonis Extractor /CELONIS/IF_RFC                Celonis RFC Interface for Extr /CELONIS/RP_BG                 Reports for processing in back ZCELONISCL                    Celonis Change LogsAs an old cus

Hello, I need to pull around 1 million records from a table in DM and create CSV for a weekly automated report. As of now I am using GET_ROWS module but it has limitation of 100K records. Can someone suggest the most optimal way to handle or bypass this constraint and create the csv?

Hi everyone,I’m exploring ways to apply process mining concepts to analyze performance and user interaction flows in a small digital product, and I’m curious how others here approach similar use cases outside of traditional enterprise processes.In my case, the product is an interactive application where user actions (inputs, retries, session restarts, drop-offs) generate a high volume of short-lived events. While this isn’t a classic order-to-cash or procurement process, the challenge feels similar: identifying where friction, delays, or bottlenecks occur in real usage flows.Some of the questions I’m currently working through: How to best model non-linear user journeys where loops and retries are expected Whether it makes sense to normalize event logs when actions happen in milliseconds rather than seconds Techniques for identifying performance-

RFC Module 3.9 (2024-08-19) With the 3.9 version of the RFC Module, there's no need to create a directory on the SAP file system to store extracted data temporarily. The new extractor uses a staging table within the SAP application database for this purpose. This updated architecture offers a simplified setup and improved reliability. For more information, see RFC module.

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

Hello Community,I am working in Celonis Studio- Views Asset where in one of the tabs i am adding a button that i want to use for navigating between Tabs.I tried the “Open linked View” option and yet it doesn’t seem to save and nothing happens when testing it. Any Advice please ?Thanks

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

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?

Working with a dataframe activity table in Python I export the file in parquet format for efficiency reasons. However, when I load the file in Celonis it doesn't recognise the timestamp in the proper format but as a string. Can anyone tell me why this error is happening? Thank you very much. Thanks a lot.

Initially I had four attempts to complete the Rising star technical assessment. I failed in the first two attempts of the first section. Now it shows 0 attempts remaining.I have competed all other sections.Please guide me how to restore those attempts.

Hello everyone,I need your help with the Email connection settings in Actionflow. For a connection that has already been created, I would like to check what settings were configured. Where can I verify this?   

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

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