Product Q&A

I am trying to create a filter for the action engine, that filters out cases, where CHANGED_FROM attribute of a change order quantity activity has specified value (<1). Important is that this attribute CHANGED_FROM is maintained also for other activities, but these values are not relevant for me. First I did just two separate filters: Cases include change order quantityCHANGED_FROM <1 But the second filter apparently looks also at other activities, so it took some of the not relevant activities, which gave me false positives. How can I configure that filter that it really only looks on the value of CHANGED_FROM of activity change order quantity? Thanks a lot in advance

Hello, Is there a way to change data row extraction limit in data jobs in Celonis Cloud. Only 100 first line are displayed in output. Thank you in advance

Hi , I would like to build a Overview where I need to have the count of Activity on header level for different dimension. For Example: I want to have a Olap table as per below. Column 1:Plant Coulmn2: Number of Purchase order header. column3: sum of Count of activity for these purchase order at header level. This is for P2P use case. Where few activities are at header level but the use case is built on item level. So the count get multiplied by the number of item which I want to avoid.

I need to filter my analysis by a specific value of a specific activity attribute. I.e. I want to only show cases when the attribute CHANGED_FROM of an activity change quantity is <1. The point is that other activities also have this same attribute, but these cases are not relevant for my goal. thank you very much in advance for the advice!

How do platform updates affect previous versions of the software?, or if have an Analyzed process in place on a lower version of the software and then i upgrade the software, will my process works smoothly on new version also?, or do i need to make changes to the modeled process ?

Hi, We have several activities which have the same sorting and same event time. Is there a possibility to change the sorting of the activities in Process Explorer in the front end Celonis ? Best regards Adam

Hi everyone,Im curious if there is any other possibility to force the order of the dimension in a chart instead of putting a) / b) / in front?And if not, is there a possibility to make a)/b) transparent or change text colour? I tried some HTML statements but without success.Looking forward to your feedback.p.s. I only found this thread, where the solution with a)/b) is suggested: Sort chart by hidden dimension Analysis Hello Team, a quick question: in Celonis chart components is it possible to perform sorting on the dimension which is then hidden? In OLAP we can hide the dimensions, I dont see such option for example for column chart. In our case we want to sort payment terms with their due date from earliest to latest (so 00 is due immediately, 30 is due in 30 days etc.) But now we need show a combination of payment term and this additional number with days). [image] Best regards,David

Hi Team,We are trying to build a dashboard to monitor our Conformance modules across analyses. We want to see in an OLAP table, the throughput times or the longer by/shorter by timefor each of the violations.Is there a way by which I can use the Conformance formula to find the throughput time for different violations in an OLAP Table? Right now I am successfully able to pull the list of violations using the readable command on the Conformance formula using Petri nets. However, the throughput time I add to the table is different from the ones that I see on my Conformance Module.Please let me know if that is possibleThanks in advance

Hi Team, We have two project folders (example- P2P and Master Data) but data required in few analyses is available in the same data model (P2P_DM). Is it possible in Celonis, to create two project folders but they share the same data model? Note- I do not want to create a copy of P2P_DM because it is very huge in the size Regards, Amogh

Dear Experts, Hope all are doing good and keeping safe and healthy. I am about to start working on an analysis for assessing the efficiency of an R2R (Month Close) Process. It will be my first analysis and wanted to go through any analysis some one has done on Celonis already (if any). Insights and best practices can be leveraged for a quicker and quality analysis and deliver better solution/actions. Yout advise and guidance on any front will be highly appreciated. Regards@dinesh.kumar35

In file uploads option,TIMESTAMP couldnt choose any data type other than string format. If selected [data and time]or [integer] format it is showing exception. How to solve it ?

In process Analyst, the Case / Actitvity table is not arranged in proper sequence. How to arrange the process in process sequence using Query?

Dear Celonis Community,I am trying to count how many invoices have single line items, and how many have more then 2, 3, etc.I am able to get the formula to work when i create a OLAP table as per the below:image744307 5.36 KBThe Dimension = BSEG."_CASE_KEY"KPI = COUNT_TABLE(BSEG)In the third column I have the below code that produces the correct result as indicated in my table.case when COUNT(BSEG."_CASE_KEY")=1 then 1 else 0 endHowever, my intention is to count the total number of cases where invoice has only 1 line item. When i remove the dimension of Case_Key and replace it with CASES.CompanyCode, it produces a zero value.I have tried different statements such as:COUNT(CASE WHEN PU_COUNT(CASES, BSEG."_CASE_KEY") = 1THEN BSEG."_CASE_KEY"ELSE NULLEND)But this only produces a count of 0.Can you please advise what i am doing wrong, and how i can correct for this error.Thanks,Anna

Hello Team, How to get the timestamp on when the file has been last uploaded in the celonis. Senario : A Excel File has been uploaded and a transformation job has been created for the same to add the details to the DM. The Excel uploading is manual and transformation job has been scheduled. The extracted details has been represented in an Analysis. Need to mention the details of the date when this file has been uploaded.

Hi teamThis feels like a simple question but I cant seem to find a way to do it so thought of asking - Im looking to create a OLAP table to support data validation that looks like the below:Table Name__Table CountLFA1__123EKKO__456The idea is that the OLAP will list all tables in the model to easily see the current Table Count for each table.Is there a way I can define a dimension to list all tables in the model that would populate the 1st column of this OLAP table with all table names?ThanksOliver

Hi allI am trying to calculate throughout time from a date column (Scheduled Due Date) to an activity event time (Record Goods Issue). I have tried CALC_THROUGHPUT and SOURCE/TARGET but it looks like the only way these will work is if I define Scheduled Due Date as an activity.Is there a way of coding this without creating a new activity?ThanksOliver

Hi, We have 2 Data Models both with the same customer table. In the first data model I have customer_credit with a 1-1 relation with the customer table. Celonis links them in the data model as 1-n (customer-customer_credit) However in the second data model the same 2 tables are linked with n-1 (customer-customer_credit). How can I ensure the link is 1-n when the tables are 1-1? Best, Joo

What if i create subsequent/multiple versions of the process in the platform and wants to retrieve previous versions, how can i access it ?, where are they stored?

When i open analyses the following error message is occurred. Error Message: com.Celonis engine transports exceptions CrashedEngineException Process Engine Node 100975043 has been shutdown Could you please advise what needs to be done to fix it.

Hey all,Is there a way to filter out all cases that start before a certain year?I tried the following:FILTER YEAR(P2P_-_Q2_2018_csv.TIMESTAMP) => 2016But this still gives me cases that start in 2015 in an OLAP table, because there are also activities performed in 2016.

Hi ,I am encountering wrong results with change ratio formula below.SUM(KPI(Priority - Change_Indicator))/ COUNT_TABLE("_CEL_ITSM_CASES")where KPI(Priority - Change_Indicator) isCASE WHEN MATCH_ACTIVITIES(NODE_ANY[ Change Priority Medium to Low, Change Priority Low to Critical, Change Priority Low to High, Change Priority Low to Medium] ) = 1 THEN 1.0 ELSE 0.0 ENDFormatting used is Percentage With DecimalsThis KPI was working fine in our dashboards from long time and started giving weird values since few weeks with same formula.The results of numerator and denominator are ok when executed separately . The only problem is when I combine with both / operator.It also works fine when I change the numerator from MATCH_ACTIVITIES to CASE WHEN _CEL_ITSM_ACTIVITIES.ACTIVITY LIKE %Change% but I dont want to use this because there are tens of formula which need to be modified.I could not identify the exact issue so far to address the customer question-why do same formula give wrong res

Hello everybody,I have a problem, which is definitely easy to solve, but I lack the idea.I have a KPI 1:COUNT (DISTINCT CASE WHEN EBAN. LOEKZ = X THEN EBAN. BANFN ELSE NULL END)I have a KPI 2:COUNT (DISTINCT CASE WHEN MATCH_ACTIVITIES (NODE [Technical Clarification]) = 1 THEN EBAN. BANFN ELSE NULL END)I would like to divide KPI 2 / KPI 1 in a new KPI 3.The new formulaCOUNT (DISTINCT CASE WHEN MATCH_ACTIVITIES (NODE [Technical Clarification]) = 1 THEN EBAN. BANFN ELSE NULL END)/COUNT (DISTINCT CASE WHEN EBAN. LOEKZ = X THEN EBAN. BANFN ELSE NULL END)unfortunately does not work that way.Can anyone help why?Thanks a lot

Hey All, im doing some evaluation for process mining and want to know the pre- requisite for this. Thanks, sandhya

Hi Community,I need some help on this logic in code editor to give % of completed orders at second time.Sum(All Completed orders with conditional activity = 1 Reason) & Sum of all completed ordersThere are multiple REASONS in Activity column but i need only completed orders with one REASONTrying to calculate the % from a table based on certain activities but limited to the count = 1 .Can you please help with the case statement how to get the % based on above. Here i want to get only count of REASON = 1 for the status & activity = completed for each case.COUNT (DISTINCT CASEWHENtable.ACTIVITY = REASONANDtable.status = COMPLETED ANDtable.ACTIVITY like %COMPLETED%THEN 1 REASONWHENtable.ACTIVITY != REASONANDtable.status = COMPLETED ANDtable.ACTIVITY like %COMPLETED%THEN NO REASONELSE OTHERSEND)Thanks

Hi everyone, Currently I have a table where I list all my process activities, where one of the KPIs is a calculation of the ratio of cases where a given activity is present. The calculation Im making to get this is the following: COUNT(CASES.CASE_ID)/GLOBAL(COUNT(CASES.CASE_ID)) I would then like to filter this table, so that it only shows me the activities that have a ratio of less than 1%. However, Celonis does not allow to filter on aggregate functions. Ive tried other workarounds, unsuccessfully. Is there a way for me to accomplish this and show only the desired activities? Thanks in advance for your help, Joo