General Product Q&A

Is it possible, that I have a C4C+ project, which is only available over an VPN? And if yes, how can I set up this connection? Are there any technical specifications?

How can I get access to Celonis Sandbox? I did not get any mail from no-reply ID after registering to the client portal

Cannot Connect to Data Model on ML workbench

Hello! For a project we want to embed a Celonis dashboard in our own website. I am looking for the best way of doing this. For example with Power BI we were able to embed a dashboard using a iFrame and were happy with the results. Is it possible to embed Celonis using iFrames as well? Or is there an other solution with similar results? Any leads are more than appreciated! Regards,Anshul

While filling up the Simulation Parameter "Even Time start", I am getting an error as "The Event time start column is the same as the Event time-end column (as defined in the data model). Please select a different column or leave empty if the start times are not available." 

Is there a use case highlighting the process of analysis Servicenow ticket dump? Kindly help :)

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

Can a person change the account registered as STudent to 'as a Partner'?

For example, there are two outcomming nodes (B with 25 cases und C with75 cases) from a node A (100). So I am trying to get 25% and 75% :).  Do you have any ideas , how to calculate the denominator?

Hi @ALL i try to do smth like this. one dynamic filter should execute the NULL values in the table. FILTER "table". "column" = CASE WHEN <%=option1%> = 'abc' THEN NULL END; all other filters work but i cannot return null values from the same table. I have tried this formula  FILTER "table". "column" = CASE WHEN <%=option1%> = 'abc' THEN Filter_TO_NULL("table". "column") END; but when i have tested, i realized that i did bring up all values but not Null values from table. Does anyone have an idea?

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 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?

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?   

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.

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?