Solved

In order to run a MLWB program on the last Sunday of each month, I want to use custom cron to setup it but I don't know how to write the wildcard. Could you help me? Yours,CLaire

Could you teach me will a two-way connection occur between the On-premise Extractor and the EMS Data Integration?

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 

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

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

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?

Hi, I have a client calendar with their working days uploaded to my data model in a SAP TFACS format.  This TFACS table is also added to the model but not connected to any other table. I have done a complete reload properly already. When I go to my analysis and see the throughput time, it didn't change, even if I put all the working days to "0" in the TFACS table. It seems that isn't tacking into account my calendar. How can make it works in my analysis? Do I have to use functions to make the analysis use the new schedule?  Many Thanks, Paula.

Hello everyone, we have an analysis sheet that we export as a pdf via action flow. In this sheet we normally filter on a specific plant number before exporting. We want to add the plant description in the analysis as a text field, but only if just cases of one plant are selected. When there are multiple plants selected, the text field should show "Multiple plants selected". I have tried to create a formula and add the result in the text field: CASE WHEN COUNT(DISTINCT "AUFK"."WERKS") > 1 THEN 'Multiple plants selected'' ELSE "AUFK"."WERKS_TEXT"END  This throws an error as I am mixing aggregate and case based info. I have also tried to add a PU_FIRST to the ELSE statement, but this does not help. Is there a way, how this can be done? Thank you for your help.

Hello, for a complex formula, I need to substract two percentages in order to multiply it afterwards However, the formula including a filter is successful and consistent for a Count but not for an Avg (the result is inconsistent, far from the to-be result) :   Also, I tried to put the filter in a Case When where I obtain the percentage thanks to a division between the ‘Change Items’ (= Count) and the ‘PO Items Not Auto’ (= Count_Table’) but I have the error :    Please note that my client has the OnPremise Celonis, therefore some functions available on the Cloud may be not available here. Any help would be the most welcome, thank you and have a good day ! Best regards 

Hi, In the Set Variable module in my Action Flow, the 'If' expression below evaluates to 'A' whereas it should evaluate to 'B'. Where am I going wrong? if(1=2; A; B)  Thanks !Bhasker

Hi All, I'd like to add a button to my sheet that allows the user to automatically filter for the last 7 days, and a separate button that allows the user to filter for the last full week. Bookmark selection doesn't seem to work, since the bookmarks are static. Thanks!

Can anyone please give me the explanation about their difference with respect to a business point of view. Like if a client asks why you are showing me case frequency and activity frequency for change price. That what should we say?

When to build an extractor from scratch and when to use uplink connections differentiate?

Is there a way to calculate the throughput time also for negative values (activites in different order) than start -> end in "throughput time search" visualization?Like also having end -> start included in the same visualization, if there are variants that follow different order of activities.The default of "throughput time search" is to only show variants that follow the defined order.My work-around was to create custom datetime columns for the two activities in the case table, and then just use datediff calculation between two columns. But it seems rather clumsy way, and also binning is required to make it look nice..Thank you for comments

---------------------------------------------------------------------------KeyError Traceback (most recent call last)Input In [1], in <cell line: 13>() 29 for sheet in analysis.published.sheets: 30 # if sheet.pql_filter is not None and re.search(find_pattern, str(sheet.pql_filter), re.IGNORECASE): 31 # print ("Sheet filter of analysis: " + analysis.data["name"] + "; Sheet: " + sheet.data["name"]) 33 for component in sheet.components: 34 # if component.pql_filter is not None and re.search(find_pattern, str(component.pql_filter), re.IGNORECASE): 35 # print ("Component filter of analysis: " + analysis.data["name"] + "; Sheet: " + sheet.data["name"] + "; Component: " + component.name)---> 37 if len(component.pql_columns) > 0: 38 pql_columns =

I am not able to interpret why trigger tables are used. Data that will be extracted on real time, doesn't it automatically be refreshed in all tables?

SAP Tables for P2P-Process Hello, is there any list where the required SAP Tables for the whole P2P Process are listed? If only the tables of the sample files are included, a lot of information is missing. Best regards!

Hi, I'm working on a first time fix calculation. The function flags a case, if there is a new case for the same serial number within 7 days. What I found out, is that the PQL window functions (such as Index_Order / Lead / Lag) are not taken into account any filters (even not on analyis level in the 'Load Script' area) or Selections. This is quite disturbing, since we use some filters to simplify the data set.  A workaround that I applied, is to include the filters also in the First Time Fix formula, but this is not preferably, since we have to state them twice, which could lead to mismatching when applying changes in the future (Load script section doesn't accept variables).  Is there a way to let window functions incorporate already present filters in the analysis?  Next to that, the behavior is quite unclear since the index is based on data that is not shown in the analysis when a 'Load Script' analyis filter is applied. Even if that is the intended behavior,

I have the following PQL Code and it is working. TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM"); How am i able to get the Max value from it? So overall the expression should give me the name of the most frequent value in this table column

HelloI was doing this exercise of adding custom KPIs in conformance, and I am not able to get that at one place it is showing 78% and on the conformance it is showing 65.79%. What is actually going on here?

Where is the Problem in my expression and where can i find documentation that isn't blocked by Celonis firewall? When i try to open the celonis. help website i get blocked by the firewall no matter from what and where i try to access the website. Every help is much appreciated, thank you!

What does dotted lines depict in a Variant Explorer?

After TM installation and data capture (including screenshots) I tried to visualize the Screenshots and follow all the steps for the configuration but screenshots arent apearing.,