Product Q&A

Hello,I am facing a somewhat specific problem with an Action Flow.I am using the Get rows module to retrieve, depending on the input variable, the column from one table or another. The variable directly affects the name of the table I am retrieving. No problem there; depending on the input parameter, the module behaves normally. The problem occurs in the next module, when I use the Text Aggregator to group the data according to this specific field. The name of the Get Rows module variable changes depending on the value of my input parameter. Here is what I tried to do, which works when the parameter is 1 but does not work when the input variable is 2.  

Hi everyone,we are using Object Link functionality to link Manufacturing Orders. In order to show the relevant predecessors and successors of one selected order (order number is written to variable aufnr) we filter as follows:This selects the respective order, but also all predecessors and successor orders.However, in this case, we only want to see the orders, that are created in the same plant, not from previous plants. E.g. in the following examples, the 2 first orders 1 and 2 of Plant A should not be selected, if the variable is set to Order 6.What is the best practice to filter in this case?Thank you, BR Philipp

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?

Hi - I am trying to write back the Variables I used in Studio View to Data Integration via an Action Flow but the attribute where I am storing the variable is showing as blank. I read Action Flows can’t read Variables form the Studio View. Is this true?

Hi!Is it possible to change the Data Source of the transformations of celonis objects (OCPM)?Background: we have migrated a formerly external instance into our Celonis. Therefor we do have several redundant data extractions. I would like to consolidate them in one common Data pool (seperat of the other data pools). This means that I have to change the Data Source of existing celonis objects. But it seems that the Data Source is read only, once an object is created. Is there any solution for that? ...up to now, my only idea is to create views in the old, original data source for each table, that is moved to the new common data extraction pool.

Can we configure CC option in Emails triggered through Celonis Action Flow, without using Outlook component  

Hi,I’m trying to restrict access to my webhook-triggered Action Flow using the IP restriction feature.According to the documentation (https://docs.celonis.com/en/webhooks--action-flow-.html), this should be straightforward. However, I can’t find any field where I can add my IP addresses.Am I missing something?Thanks 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

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

Hello, For the moment my View trigger a Skill with input, and when triggered we can see some details about the record affected by the skill :Skill Input Form However when I change the Skill with an Action Flow it is not possible to show the details, it Only show the ID of the record. Do you know a way to do that with ActionFlows Inputs and Action ? Thanks 

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

Hi Team, I used Get Rows and added column names. Then created a Text Aggregator but i can;t see the columns created in the Get Rows, can anyone help me on this.  I need my column name like  “ 4.Invoice ID “ but i got only the Total number of bundles and Bundle Order Position. I tried publishing, ran only get row, re-loaded, even logout and retired.

I have a usecase in which I want to create an object-centric datamodel. According to the linked video below, it is possible to create events based on the attribute of an event (e.g. the event is order, but there are orders in different domains, e.g. games, clothing, …. which is saved as an attribute of this event). Populating this category as the event is possible in a simple case-centric example like explained in the video, but currently this seems impossible for object-centric models? Is this correct or am I missing something? I would like to avoid creating single events for each category.https://academy.celonis.com/learn/video/create-events-based-on-their-attributes

Hey, I am curently working on creating a dashboard for employees as a view where they can simultanously write back to each line in a custom “comment”-column. Basically the inline editing function from the new Views.Sadly I want to do this for a rather large data model.  Is there a way to have inline editing or something similiar for bigger tables that exceed 30M Rows? Or can I put some sort of filter on that table in the front end to minimize the rows below 30M. Or does it have to be in the back end? Thank you!

Good morning,I need to create a date filter for the start date on a graph, and the date is a user input, so I create a Date Picker as input box and save it as a variable.I struggle with the PQL in my graph FILTER PQL statement:FILTER “table”.”datecolumn” >= {d ‘${my_start_date_variable}’} But I get this error message  How do I adjust my PQL to get the date format correct? The date picker has a standard format that cannot be changed. I also tried this, and it does not work:FILTER “table”.”datecolumn” >= ({d '${my_start_date_variable}'}, FORMAT ( '%Y-%m-%d')) Any assistance will be appreciated.  Thank you,Denise

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 Everyone! Is there a way to download the BPMN model from Process Explorer (New Views) so that I can use it in PAM?

How do I get to see what is the trend of events and connections as a business user? Order count with common number of events/connections - default view nowOrder count with least number of events/connectionsOrder count with most number of events/connections Finally, I want to build a histogram to determine what is average number of events/connections for orders to identify trends. 

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 

BackgroundThree tables and their relationship as below:VBAP(1) : VBFA(N) : Memo(1) RequirementI want to create a table with three columns: Column #1: “Reason Code”( From table: Memo , it is a dimension column)    , it is doneColumn #2 : “Memo#” ,  with PQL: COUNT(DISTINCT "memos"."vbeln" || ' ' || "memos"."mandt"   , it is done Need your help on this:Column#3:  “Total number of VBAP” . I don’t want the value of “Reason Code” cross filter table “VBAP” which means the all the value should be the same , for example: 13298   I have tried 2 PQL below:PQL#1:Global (  SUM (    PU_COUNT (      "Memos" ,      BIND (        "VBFA" ,        "VBAP"."VBELN"      )    )  )) PQL# 2:                GLOBAL ( COUNT_TABLE ( "VBAP"

Hi!Today I noticed that there is a “Transpile” button in SQL editing, and I would like to know if there is any documentation about it as I haven’t been able to find any.  Thankyou for your time

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!

Over the Join Functionality documentation page (Join functionality (celonis.com)), when we get an 'No Common Table' error message - a detailed explanation along with the join path is explained. As I am new to the Celonis world, I wonder how to use the mentioned path to achieve the corresponding result.  Thanks in advance.

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