Product Q&A

How we can use symbio in celonis.Do we need to registered separately for symbio?

Celonis CPM - How can one import a Visio diagram in Celonis CPM? The steps in the Symbio documentation didnot help us.

Imagine I have two tables CasesCase IDCustomerActivitiesCase IDActivityEvent Time I would like to get the earliest "Upload" activity event time across all cases for a given customer. It is easy for me to get the earliest "Upload" activity for each Case with: PU_FIRST(Cases, Activities.Eventtime, Activities.Activity = 'Upload) But this returns a row for every case. I cannot figure out how to get the first of all these results. I tried domain tables, but couldn't figure out how to set it up. Any thoughts?

I wanted to use Get Message module of Microsoft 365 email in my Action Flow. But I don't know what does each field mean and what are the accepted values for those fields. For example in the screenshot below.I checked Celonis as well as in make.com documentation, but none of the place I found the proper documentation. Thus, can someone suggest where I should look for documentation on Microsoft 365 module.

PAID AMT is, by definition delayed because people have to do research and request payment before the money arrives. So, it's normal to have NULL in PAID AMT for a while. Any thoughts? Apparently, I wasn't authoring the conditional statements correctly. 

I have the following scenario, there is a component table inside a view each column is related to some KPIs, and in other columns, the values are coming from inputs that the user inserts manually inside the Apps. It means that some values don't exist in the data model or can be generated with any table since they are inserted manually. I would like to know if it's possible to create an action flow that reads all the values from that table in the studio and sends the data to a data pool. I was checking the documentation, but it seems that all modules from Celonis are only capable of reading data that exists in a data model or a knowledge model but not from a table component.  

Hello community,I am struggling to set extraction filter statements for Jira tables. Some column names has a $ character that causes the following error:Extraction failed to start. Error for table 'issue': Field 'project$id' does not exist or you do not have permission to view it.With the INFO:additionalFilter: "\"project$id\" IN ('1234', '5678')" Furthermore, operators such as LIKE do not work. Error executing extraction. Unknown operator: LIKE. Any hints or best practices to share when configuring Jira extraction filter statements? CheersIrfan

Could you tell how to set up the Share Link button?(Attached below) The permissions are also fine for the administrator in the target environment.I would be grateful if you could let me know.

I just completed the "Comparative and Predictive Process Mining" course to learn more about ML capabilities, prediction, simulation, etc. I made an assumption that the example notebook/code that was shown in the video regarding feature recommendation and model training would be OOTB or readily available. I cannot find any examples on Celonis site or web. Are there examples for use or is it on us(me) to develop from scratch?

In my output (OLAP) table I want to have each activity name from the activity table and then an overview of the number of cases in which that activity name has occurred. Then I want to get an overview of the number of cases in which that activity name has occurred two times, three times, or multiple times etc. I know that with the following code I can get the number of cases where the activity happened at least 1 time, but I do not know how to calculate the number of cases where the activity happened 1 time and not more often. SUM(CASE WHEN INDEX_ACTIVITY_TYPE ("ACTIVITY_TABLE"."ACTIVITY") = 1 THEN 1 ELSE 0 END)  The other thing I still miss is how I can calculate the number of cases in which that activity occurred >=2 times. When I change the formula to >=2, I get the wrong count as then a case with 4 activity occurrences is counted as 3 instead of 1 (it counts the s

Hi Team,Im trying to convert the data i need from the datapool into a pandas dataframe for further calculation.In the documentation i could only find how to read the parquet files and convert into Pandas.Is there any way?Let me knowThanks 

I am trying to configure a comment component in the new views. I followed all the steps in the documentation but it is still not working. Is there additional documentation or other steps to configure the component that is not in the documentation?

 I would like to stack bar graphs on top of each other like this - I see there is an option to "Stacked (on Primary Axis)": But it looks like when I add a secondary axis that option disappears -  Does that mean it is not possible in Analysis to combine a stacked bar graph with a line graph on the secondary axis? Or is there a way to combine a stacked bar chart on the primary axis with a line chart on the secondary axis?

"Scroll from right" doesn't seem to work in View

I created a "Chart" component in studio, and it shows the chart from the entire duration of the data on a monthly frequency. I want to show the data month-wise but limit it to 12 months with an option to scroll to the left to see the earlier months data. There is no such option. We have this option in Process Analytics but not when creating the Execution App / View. Is this a product limitation?

In my output (OLAP) table I want to have each activity name from the activity table and then an overview of the number of cases in which that activity name has occurred. Then I want to get an overview of the number of cases in which that activity name has occurred two times, three times, or multiple times etc. I know that with the following code I can get the number of cases where the activity happened at least 1 time, but I do not know how to calculate the number of cases where the activity happened 1 time and not more often. SUM(CASE WHEN INDEX_ACTIVITY_TYPE ("ACTIVITY_TABLE"."ACTIVITY") = 1 THEN 1 ELSE 0 END) The other thing I still miss is how I can calculate the number of cases in which that activity occurred >=2 times. When I change the formula to >=2, I get the wrong count as then a case with 4 activity occurrences is counted as 3 instead of 1 (it counts the second oc

Hello everyone, I'm trying to connect table ekpo and lips in order to get the sum of the field LGMNG for every PO and its corresponding VBELN from VBAP and VBELN from VBFA. The pql code I am using is the following one:BIND("EKPO", PU_SUM("GSR_VBAP", BIND("GSR_VBFA", "GSR_LIPS"."LGMNG"))) This works well when I only have unique VBELN from VBFA for a VBELN from VBAP. My problem is when I have differents VBELN from VBFA for one same VBELN from VBAP, as it sums all te quantities as one, when I want it sepparated.  In my OLAP TABLE I only want to show the first VBELN from VBFA, so I use this code: BIND("EKPO",PU_FIRST("GSR_VBAP","GSR_VBFA"."VBELN")) but i get the quantities from LGMNG for all the other VBELN from VBFA which belong to the same VBELN from VBAP.  I hope can help here. Many thanks. 

SAP Note: 3345663 - Termination of reseller agreement: On-premise solutions by Celonis  I read SAP Support note 3345663 and it says "SAP Support for the on-premise Celonis products will end." Is Celonis no longer supported on the SAP platform to extract data?

We would like to create a bar chart in views where the dimension input is not directly available from any field in the model and where the measure logic depends on the value of this custom dimension. The idea was therefore to create a table in the model and use this as custom input for the dimension while using a CASE WHEN statement to create the different measures depending on the value of the customized dimension like this: CASE WHEN “Custom Dimension” = ‘X’ THEN KPI("KPI1") CASE WHEN “Custom Dimension” = ‘Y’ THEN KPI("KPI2")..... etc. Since the custom table is not linked to the model we get a PQL error that ‘No common table could be found....’. Is there any workaround for this in order to be able to use custom dimensions in an easy way? 

Can we create action flows for views?

I work as a Business Analyst and a huge part of my work involves working with Advance View component. Recently I discovered that the "Edit Mode" button is gone for all the existing elements of my app. Also, I cannot create a new Advance View, I'm getting the error in the attachment. After this update I cannot do my job at all. Any idea what happened here?

How can I answer, do customers have significantly different behavior if these deviations happen in an order-to-cash process? Any ideas of KPIs that I could build? 

I got some error in my console: You have reached your 1GB data upload limit -> in celonis error what can I do What can I do to resolve this ?

Hi all :), is it possible to upload a excel file to the data model and connect it to the other tables only via action flows, or perhaps via the ML workbench. Links and Steps how to do it would be perfect, thanks in advance all :)

Hello celopeers,Between yesterday and today my team has noticed problems in the execution of Skills execution apps from the Marketplace and skills developed by my team, in different productive environments.I opened a support ticket but we have not received a response. Maybe someone else is experiencing the same problems or someone from the Celonis team can give us more information? Best regards.