Product Q&A

Hi all, I want to have a dropdown button with the values 0 to 12, which I can generate using RANGE(0, 1, 12) however when I run/use the dropdown button it does not show any items. Is this supposed to work? (were running CPM 4.5) Kind regards, Joos

Hi everyone,I hope you can help me with my SQL Problem.I created the Table Cases and selected my Case Key and a specific filtering for Specific Type.The strange thing is that my output includes two lines but in my row data the conditions are matched for Text1.DROP TABLE IF EXISTS CASES;CREATE TABLE CASES AS(SELECT DISTINCTB.ID AS CASE_KEY,CASEWHEN B.EX = 5 AND B.VW = 4THEN Text1ELSE nextEND AS Specific TypeFROM Data AS B );SELECT * FROM CASES WHERE CASES.CASE_KEY =722OUPUT:CASE_KEY Specific Type"722 Text1722 nextDoes someone know how why I still get next as a output and how can I change the syntax to get sure to get out only Text1?

Is it possible to subtract minutes from a datetime and get subtracted datetime?

Hi - I have two tables ACTIVITY_1 and CASE_1. ACTIVITY_1 has different statuses of PO.Case_1 has all the distinct POs and PO Amount. Now I want to show the sum of PO Amount on each activitity on the Process Explorer. When I use a simple SUM calculation or PU_SUM calculation, it double counts the PO amount, if a PO has gone through an Acitivy/Status more than once. This is supposedly a simple calculation, but I dont seem to be able to create it yet. Can you help please?

Hello Team,We are trying to calculate the rework cases for activity in different approach i.e in column chart where we need if case key has executed more than once , twice or thrice for particular activity then each cases should be unique in each column logicfor eg:-More than once case keys executed should not repeat in more than twice column and same with thrice column.Below is the logic we are looking for to calculate the same but not able to get unique records .greater than 1 =Cases should not repeat in >2 and >3 columngreater than 2=Cases should not repeat in >1 and >3 columngreater than 3=Cases should not repeat in >2, >1 columnKindly let me know how best we can create the logic , awaiting for your response.

Hey everyone, I am looking for a solution for the following issue. I have a bundle of 5 different activities. I need to know the count of cases for every activity.The Problem is that more of one of the bundled activities can occur in one case. Therefore I would like to count only the last occurred activity in the bundle. The required activities can occur somewhere in the process flow.Example picture attached.bundle953551 57.8 KBIs there someone who can help me to solve this problem?

Hi everyone, Im trying to add a rework filter to my analysis that allows the user to choose between activities and how often they occur. Im thinking about something like this: select cases where activity occurs more/less than 1/2/3 etc. In that way we could filter down exactly onto those cases where Celonis identified rework. I just started with Celonis, so Im not sure how to start/implement such a filter so I hope I could get some help from the Celonis Community. Thank you very much in advance!

Suppose I am using PU_AVG function to calculate time between ticket deferred and ticket released activity for each case but in my scenario there are multiple combinations of ticket deferred and ticket released so, will it pick all occurance per case or not.

Celonis offers you a lot of features to share your success stories or achievements with other people. One of them is the so-called functionality Public link which allows you to share the published version of your analysis with this link. First, navigate to Process Analytics aaa11913935 256 KB Click the dropdown menu of the analysis you want to shareThen public link aaa21919931 74.7 KB Click Enable public linkClick Copy to ClipboardClick SaveEvery person who has this link will be able to use (not edit) your analysis. For example, this is my analysis that I share with you via this link: https://snap-er-ndrio-gmail-com.eu-1.celonis.cloud/process-mining/public/df45b38a-46d2-4b4c-9ec2-4fc2293c15a8/#/frontend/documents/df45b38a-46d2-4b4c-9ec2-4fc2293c15a8/view

Hello, I use a data model that has been working well for a long time. Data records are added at regular intervals (weekly). Now I got in a few components the following error message: No common parent between table could be found - please check your schema. The Tables [Table1.DATA] and [Table2.DATA] are connected, but have no common parent table. Join path [Table1]N 1![CASES]!1>N[Table2]. For more information on the join path, search for Join functionality in PQL documentation. I already checked the fields that are linked in the data model. [Table1.Data].[Field] = MULTIPLE keys [CASE].[key] = UNIQUE key [Table2.Data].[Field] = UNIQUE key I checked this with the following code: SELECT Field, COUNT(Field) AS Anzahl FROM Table2 GROUP BY Field HAVING (COUNT(Field)>1); Does anyone have an idea how the analysis of the error can be advanced here? Is it really only due to one of the tables described in the error or is it possibly due to a different table in the data model? Why is the tab

Hello, Please help me to understand what is the major differences between view and analysis, as view needed YAML coding a take time then analysis creation which we are now good in it. Both are used to show insights of the process, and if needed we can develop the analysis in different ways to get the persona based look.

I want to apply a filter to display only the maximum value for each team_resolve column value.problem.xlsx (9.0 KB)

Dear All i would like to build a KPI based on an OR condition But somehow the result is more than 100% how can i combine that per case? thank youSUM(CASE WHEN EKPO.LABNR = 1 OR CEL_P2P_ACTIVITIES.ACTIVITY_EN = Create Order Confirmation THEN 1.0 ELSE 0.0 END)/COUNT_TABLE(EKPO)

I have a variable DateDeliveryOld that takes the last old value from the Delivery Date field, which is in String format (e.g. 20210211). Then I have a formula that should either output the DateDeliveryOld value in date format (TO_TIMESTAMP), else the current Delivery Date (EKET.EINDT): CASE WHEN <%=DateDeliveryOld%> IS NOT NULL THEN CASE WHEN <%=DateDeliveryOld%> LIKE 20% THEN TO_TIMESTAMP(<%=DateDeliveryOld%>, YYYYMMDD) ELSE PU_FIRST(EKPO, EKET.EINDT) END ELSE PU_FIRST(EKPO, EKET.EINDT) END Unfortunately the result I get is the error Day of month value is out of range 131. I thought I already prevented this by taking out null values and invalid dates (not starting with year 20). I exported the data and converted to date in Excel, and following are the invalid dates. I would expect these to be captured in above formula. Is there anything else I should include in the formula to obtain valid dates? Date_Delivery_old Case count 3256711 00000000 1 22010201 1 22010205 1

In my activities table, I have activities like set status and change status. I want to calculate what is second last status value for each case, the status values are given in the changed_to column next to the activity column

Hello Please send help! Im desperatly trying to count all cases with repair in time = 1 (true) If not repaired in time theres 0. SUM doesnt work, because there is more than one activity per case, so there are many rows matching the same case id in the data base. Im looking for the percentage of cases repaired in time (of total cases) carried out by one service point. My KPI: AVG( CASE WHEN "EventLog_UPLOAD_csv"."REPAIR_IN_TIME" = 1 THEN 1.0 ELSE 0.0 END) Unfurtonately, it counts rows, not cases. So the result isnt exact. Can someone help?

Hi All, my problem: I want to calculate the time between two process steps. These Steps are sometimes very often within the process sometimes never. Also they can be linked directly without any acitvity steps between them. Furthermore there is the possiblity that hundrets of process steps are between them. Additionally it is possible that both activities are repeated immediatly. E.G: Repeating Process Sequences like (A, B, C, D, B, D, D, C, E, F, , D, C, C, D) I would like to find the next D to every C and calculate the throughput time. Looking forward to your answers. Thank you! & Have a great weekend

Hi, We have an issue where images in analyses result in errors after transporting them between CPM4 environments. As we have a development and production environment of Celonis CPM4.6 we regularly move analyses and data models from the dev to the production environment. Analyses without images, or with the company logo, work fine. However, recently we encounter issues when transporting analyses that contain images. Is there any way to solve this without manually re-linking all the images?

Hello Celonis-Team, As an extension to my suggestion: Click here A full text search over all transformation scripts would be very helpful. This way you can quickly find out in which scripts a certain table, field etc. is used. Thank you Thomas

Unfortunately searching the Community and internet didnt get me the answer to this problem. Im trying to convert a value to date format with TO_TIMESTAMP, but the value seems to have the wrong type: LONG instead of STRING. Is there an easy way to convert LONG into STRING without changing the underlying table (i.e. involving the developer)? I see there is a function for STR_TO_INT, but not the other way around. My Celonis version is 4.5.0.

Hi All, Im try to get all my data model list in my celonis application, for the purpose migrating to prd to UAT etc is there any syntax in python to get the list of DM. Thanks,

I need to create a filter for Orders on an OLAP table where the delivery note was created in the last 48 hours, and I am struggling with it. Should I use EventTime or something else? (I am new to Celonis, so any advice helps) Thanks!

Hi, I have my automation KPI: AVG(CASE WHEN PU_COUNT(AR_Cases_csv, AR_Activities_csv.USER,AR_Activities_csv.USER IN (<%= AutoUsers %>) AND AR_Activities_csv.TASK NAME IN (<%= AutoTypes %>)) = PU_COUNT(AR_Cases_csv, AR_Activities_csv.TASK NAME, AR_Activities_csv.TASK NAME IN (<%= AutoTypes %>)) THEN 1.0 ELSE 0.0 END) Thats basically considering specific activities carried out by automation users. Now I would like to filter the process where these activities are not carried out by the automation users. Basically I need the negation of this formula, converted as a component filter. How can I do that given that component filter does not like aggregation function?

Good day, I need to set a filter at column level to get the release date of the PO.This would be on a TABLE OLAP and the filter does not have to be at component level.In case I do it in a single table, I applyFILTER _CEL_P2P_ACTIVITY_MASTER_DATA ACTIVITY_EN = 'Release Purchase Order '.I imagine that a PU_FUNCTION is used to set the ROUND_DAY("_CEL_P2P_ACTIVITIES". EVENTTIME) that affects only one activity.Thank you very much.

Hello Celonis-Team, In order to optimize the data jobs and to increase the speed, I try to select only needed table columns und filter table extraction to only needed data sets. Unfortunately, this is not easy because it is hard to figure out which columns are needed where. Therefore, the following proposal: Implement a Where-Use List. This should show which tables and columns are used in which filter and in which transformation, e.g. a indicator in the Extraction Table Configuration (per table, per column)By clicking you can see in which transformations the table or column is used. where_used986443 22.6 KB Also, it would be very helpful to see the execution time per task and step in the job log as list column. At the moment I have to open the tasks and steps one by one and calculate the times manually. execution_time1630511 21.7 KB Thank you Thomas