General Product Q&A

Hi all, I have a column with multiple values   e.g. col_list = '21651,5615561,50615,561591' per case_keyI need to split the values in four different rows when showing an OLAP table in studio.Some  case_keys present up to 5000 values in that column. Thank you for your help, Leonardo

Hi everyone, I’ve got the following Issue:I have an action flow that queries data and builds up an HTML view in the form of a table for all its entries.In the end I  trigger a Process Automation Skill to send an email via the “Email by Celonis” action. My hyperlink is correctly tagged with:<a href="https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23" rel="noopener noreferrer" target="_blank"> salesorder</a> but in the mail I only receieve the text “salesorder” without the hyperlink. On the other hand when I use the URL as the hyperlink text it gets through with the mail:<a href="https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23" rel="noopener noreferrer" target="_blank"&gt

Hi, I was going through academy links for Process Copilot but I don’t see the “Inspect response” option. has this been changed recently? 

Hello CommunityI played a little bit with augmented attributes and now want to fully delete it.As you can see in the screenshot I deleted the augmented attributes within the Knowledge Model but the corresponding records still occur. The “delete” button is disabled.Question: How can I fully delete this unneeded stuff?Best, Thomas  

Hi Everyone, I am working on a particular information to check to extract which is User Group Permission  and User Group through the ML Work bench.  Please keep your thought for helping. Thanks,Shakthi

HiI have a Annotation Builder run that is stuck at 80/100 transactions. When I click the cancel button it does not cancel. When I click the stop button it does not stop. When I do this enough it does stop - but when I run the next set it starts up again

I am working on an engagement where we want to create Purchase Orders (PO) in SAP triggered from Celonis based on Purchase Requisitions (PR). We are trying to implement this via Action Flows using an RFC call (BAPI_PO_CREATE1). We have the following scenarios: Mirror PR – All PR lines in one PO with identical lines Combine PR – Combine several PRs into one PO Individual – Multiple PR lines are converted into individual POs Add PR – Add PR lines into an existing PO For scenarios 1, 2, and 4, there can be multiple PR line items that need to be created within a single PO (or appended to an existing PO).Current ChallengeWe are facing issues in structuring and passing multiple line items from Celonis to SAP within a single RFC call. Specifically:We are able to fetch multiple PR line items using “Get Rows”We are using Array Aggregators to construct r

Dear Colleagues, I have a simple Action Flow where I “Get Rows” (Celonis module), then I “Create Excel” (XLSX Excel files module) containing the data I selected, then I “Send an Email” (Email module) with the excel I had created.Everything works, however in the “Create Excel” module where I do include headers, finally in the excel file they look like this: “O_CELONIS_PURCHASEORDER.PurchaseOrderItem” - is there any way to customize these headers or at least get rid of the first part “O_CELONIS_PURCHASEORDER”?Thanks and kind regards, Malgorzata 

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?

I am using the free training environment in Celonis Academy.Studio was initially available, but after I deployed an App as the guide instructed, I encountered an error that says "I am not allowed to this page" or some sort. Now the Studio button is missing. I'm only seeing the Data, MarketPlace, Search  and Help Center

“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

I have a few Architects who want training material for mapping Scenario Process maps - we have had minimal training for this and cannot find any documentation.One question is, once a Scenario is published to the Navigator and its associated processes are clicked on to view, there is no easy way to be taken back to the Scenario home page to explore more processes with in that scenario? 

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