Product Q&A

Dear Community, I'd like to make a OLAP table that have Activity count and Connection count.  Is there any way to make this OLAP table? Thank you. Best regards,Takayoshi Ichikawa 

Hello, I am trying to modify an Action Flow by adding a column to the final result which is a Gsheet file in shared drive but although the query seems modified in the Action Flow, the final resultat in the Gsheet is not. I have save and published.

Need help woth pql code. For example, in a particular 1 hour the count of activity is 89 or 56 or 05, then that count has to be considered as 1 How can I achieve this? ​

I have installed the O2C app on S4. This app has no KM/views but analysis. In the analysis there sort text variables like #{development}. I thought I read something about this but don't know anymore how this works. cannot find it in the help as well.

Hello all, When exporting Case Explorer sheet to an xlsx file, the Duration column comes as seconds, despite showing in days when viewing on browser. So the viewers keep asking what this value is, is it possible that Duration column shows in days after export? Regards, and thanks in advance. 

I have been provided data in a parquet file, and the activity names are quite long and verbose. What's the best approach to editing the activity names to make them more intuitive/user friendly?

I am revisiting this issue because my new approach did not work properly. The Case I'm trying to program is:  I have two OLAP tables where one table filters (component filter) data with:(DATE < TODAY()) and the other has the component filter:(DATE > TODAY() AND DATE < TODAY() + DAYS()).  My aim is: Column 1: Material NameColumn 2: Material NumberColumn 3: The KPI of the Material as a whole from the OLAP Table 1 which is a Detail Table of all Materials The filter is only a simplified representation of the code. In summary, I have one table that looks at dates from the past and one that looks at dates from the future (future orders/deliveries). However, I now want to connect KPIs from the table that maps from the data from the past on the table that looks into the future.  For example, if I have the sales of a material from day 1 to today (past until today), I would like to be able to display that as additional info for the future orders of that material (considered the pas

I have a button dropdown, where I've different inputs like: EINDTSLFDTMENGENETPR  Separator : ,I'm wrapping with:start = 'end = ' My variable I'm writing into is changeFields So I did a KPI where I'm using this case when: CASE WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT)' THEN 'EINDT'WHEN <%=ChangedFields%> = 'Stat. Datum (SLFDT)' THEN 'SLFDT'WHEN <%=ChangedFields%> = 'Preisaenderung (NETPR)' THEN 'NETPR'WHEN <%=ChangedFields%> = 'Mengenaenderung (MENGE)' THEN 'MENGE'END THe problem is, when I'm using more than 1 input my CASE WHEN state the project doesn't work.  I tried it like:  WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT),Stat. Datum (SLFDT)' THEN 'EINDT,SLFDT' But this idea doesn't work. I also tried to do it with logic gates. Does anyone have an idea how I can filter multiple inputs and check it in a case when function?

Dear community, I am using a formula to compute some KPI (based on the shown table), which is (SUM(PU_COUNT_DISTINCT( DOMAIN_TABLE("S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."CASEKEY","S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."EVENTTIME"), "S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."AKTIVITAET","S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."AKTIVITAET" = 'Eskalation durchgeführt')))However, using this formula for a type chart and a column chart, I receive two different results.The type chart correctly counts the unique combinations of the columns casekey and eventtime for column aktivitaet with value "Eskalation durchgeführt", which is 8.Meanwhile, the column chart does not only count the distinct values, but all, and therefore returns a 10 (dimension is round month, which should not be important, as all table entrances result from the same month). Does anyone know why the column chart does not solely count

For eg., I want to represent the avg kpi as one of t​he kpi in a column chart and makes it static so I can basically see a straight horizontal line to the dimension to compare which dimension value has achieved the avg.

Now I'm looking for data connector template from SAP to celonis.Do we have something pre-fixed data connection template for basic SAP module? if yes, please let me know where to find it, or do I really need to build something RFC setting in SAP from the first step?

I would like to show the changes of figures comparing to the previous period, I think of ways like through defining multiple variables with date input, is there a more convenient date in doing that? thanks!

where do I go to enroll in a certification exam?

On click on a drop down button it should show more drop downs like cascading. Is it possible to add like that?

How can I set conditional filter in load script page? I have tried Case When, but it gives me error. Is there anyone who has suggestions? Filter "xx"."yy" = <%= option1%> (it works)  i want to do multiple conditions like that in component filter case when <%=option1> = 'a' than Filter "xx"."yy" = 'value' ;case when <%=option1> = 'b' 'than Filter "xx"."yy" = 'value2' end  Is there any way to add conditional filter in the component filter section?   

I noticed that PyCelonis has some functionality in adding records, variables and the like into Knowledge Models but I was wondering if there was a script or way we could mass import/add variables or KPIs from Process Analytics into a Knowledge Model. I've got a script that extracts and formats all KPIS and Variables into a pandas dataframe so it's just a matter of calling the right function. I don't really see any examples on the PyCelonis Github in terms of adding variables/KPIs

Hi, I have built three KPIs that calculate throughput times. Lets say: KPI 1: 20 hoursKPI 2: 30 hoursKPI 3: 40 hours.  Total: 90 hours. I would like to make a simple pie chart with all three of them in it. KPI 1 showing 20/90, KPI 2 30/90 and KPI showing 40/90.  The KPIs are calculated through different formulas.  Anyone knows how to make this simple chart?

I currently use this load script: FILTER MATCH_ACTIVITIES( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", EXCLUDING_ALL ['Record Goods Receipt'] ) = 1 But as far as I can tell this is only item level, so POs that have any item in which "Record Goods Receipt" doesn't occur still show up. I want to exclude any purchase order that has "Record Goods Receipt" anywhere in the process of any item in the PO.

We are trying to create a report which shows contract information with different validities. I can see the information in rows but ideally need them shown in columns.Layout in rows means I have 8 rows for 8 different validities but in columns this would reduce the number of rows massively

Hello everyone,I would like to get the variation and percentage variation of a KPI generated in a Knowledge Model.I would like to know if there was an increase between the last value of the KPI and the value of the previous month.I can't think of a PQL to do this, anyone has an approach? Thank you.

Any idea on how to counter this?

Am trying in my Studio but nothing is getting updated or showing.

Hi - I tried executing the action flows named "Creating CSV file from Celonis output". I am not getting the results as mentioned, instead of this I am getting output as a direct values separated by coma (,). The result I am getting is given belowbut the result should be in the form of file as shown below.Kindly help me to fix this.

How to check whether after a certain activity , a transaction has occurred or not ? ACTIVITY_EN is the activity field and EVENT_TYPE is the transaction field

I am confused why we use Reload from cache, does it provide some kind of undo functionality? Also I am confusing it with Partial reload, are they same?