Process Analysis

Hello. Id like to confirm significant between cycle time and throughput time in Celonis. Would you tell me correct answers If I misunderstand it below. Cycle Time It means the time spent the whole workflow (ex. P2P, O2C, etc) 2.Throuput time It means the time about detail each workflows. (Ex. activity, case, another dimensions etc.) best regards.

Hi all, I am trying to convert my currencies to ZAR using CURRENCY_CONVERT. Here is my code: CURRENCY_CONVERT ("o_celonis_SalesOrderItem"."NetAmount", FROM ( "o_celonis_SalesOrderItem"."Currency" ), TO ('ZAR'),"o_celonis_SalesOrderItem"."CreationTime" ,"o_celonis_CurrencyConversion", "o_celonis_CurrencyConversion"."ExchangeRateType", "o_celonis_CurrencyConversion"."SourceSystemInstance" )But it does not work.  

Hi All,I have created one column Month_Year in one of my tables which I am using for creating the analysis dashboard. The Month_Year column is of type Varchar and so when I am creating a drop-down component in the analysis rather than getting the Month_Year column in date order I am getting it in alphabetical order. Sure I know there would be answers to this query saying to change the datatype to date and then do the to_date function in the front end but in that scenario, I am getting unwanted things like day, time, hour, seconds and all. I only want the month and year to be displayed in the dropdown and that to in date order. Can anyone please help me on this query

Dear all,I am currently working on building a view for the management team to track KPIs across the entire organization. The organization consists of multiple entities, each using different systems (e.g., SAP, MSSQL, etc.), and as a result, we have multiple data models in the backend.In the overview view, we want to visualize data from these different models in a single interface. I have created a space that contains one view and multiple knowledge models. I would like to confirm whether this approach aligns with best practices and if it is possible to achieve my goal with this setup.Looking forward to your insights.Thank you,Yuyao

Hi There, does anyone know if Celonis can take snapshots of values? We determine inventory but its always the newest and latest figures and I cant find a proper data to use for a timeline graph of inventory. So I was wondering if its possible for Celonis to take a daily snapshot of a figure for use in a graph. 

I’m trying to add a total line to a table in Celonis, similar to a total line in an Excel pivot table. In my table, my first column is a dimension and the rest are aggregated KPIs. But my end user needs to see the overall total, too. Any thoughts?

I am trying to filter records using predefined filter assigning value thru parameter in popup view. But the value is not properly assigned to the filter. Its filtering everything and not showing any data. However filter works fine when i assign value in the filter. The value to the view thru variable is passed properly and I can see the value in text box.This works fine: FILTER "o_custom_DeathNotification"."DeathNotificationId"='58b22b1d-771b-4b1a-8937-9fb90d82b491'This doesn't work: FILTER "o_custom_DeathNotification"."DeathNotificationId"='${var_dn_id}'

Hello all,I am struggling to calculate the average count of activities for similar cases. The calculation returns a wrong result. It doesn’t matter if I use PU_COUNT on the activity table or CALC_REWORK. Example DataCase ID Parameter Number of Activities in Activity table 1 A 10 2 A 10 3 A 20 4 B 15  I would like to know the amount (count) of process steps (activities) on average for cases with a certain parameter.Expected ResultParameter Average activities count A 13.33 ((10+10+20)/3) B 15 (15/1)  What I get

Hey community, Is it possible to combine two ocpm objects with each individual eventlog to combine into on object & eventog?My szenario is that i have two objects for two different type of documents. They have the same structure and events but they are not named same as each event ends with they name of their type.And i want to perform on both the same analysis and i am looking for a way instead of duplicating all analysis and adapting the kpi to simply my it. So both less duplicate work for me and easier for the enduser to work with. Is there like a “union” function to join them or is it possible with a parameter to switch the object/eventlog in a view? Thanks in advance 

I extended my duplicate checker perspective, add the objeties what i want, and change my data model variable to my data model extended, but my view warns are records missing, these records have “aug” in the name. Anyone know how to change my data model to my data model extended and create these records missing?my perspective extended:the error when i change my data model:  

I am working on creating views and created Filter check box with on click option , but  Select All checkbox is not coming at right side.Below is the YAML I am usingid: dropdown-list-60b99e03-3e73-459b-87be-9d51464f35type: dropdown-listsettings:  data:    columns:      - id: c3c70431-d853-4ff1-95ac-50bc70a226ff        order: 100        onClick:          update:            selection: multiple            variables:              - name: target_attribute_name1        attribute: TABLE_1_2.TARGET_ATTRIBUTE_NAME        displayName: ""

Hello Community,I'm currently migrating my analyses to the new views and have encountered a “problem”. I hope you can help me solve it:Within “Analysis” the table component has the function “calculate share in percentages”.Hee it is possible to calculate the percentage of a column per line, also what percentage of the total for a column a line represents.How does it work in the new views?Thank you so much for help.Best, Thomas  

Hello crowd,I need your swarm knowledge for this issue:I selected July + August in date picker, which is 9 calendar weeks.My objective is to calculate the average sales orders per customer per calendar week.You can see it in my screenshot. One customer per line, count of sales orders and count of calendar week where sales orders are created.The challenge is, that not every customer is ordering in every week.My question is: How do I get the total number of calendar weeks (9) from the date picker in my formula?I would like to divide the “number of orders” by the “total calendar weeks from date picker” and not by the calendar weeks in which the order was placed.Best, Thomas   

Hi Community, while using Send Email action in Views table, there are 2 options:Launch default email program and Send from serverbut second option is disabled and status is ‘In Progress’ (unable to select it and proceed with this option). what’s the meaning of this? is it a permission issue or what?please check attached image as well. 

what insights generation can be done for production order

Hi All, I need a filter that filters out all activities where activity “A” is not first. So i only want to see all cases where the correct acitivty sequence is A → B → C → D...

Hello Celonis community,I’m building a new view and I need to set-up a line chart with multiple lines. Basically, calculating the same value but for different types and plotting them in differently colored lines.In the analysis set-up I used to duplicate the metric for each type and force filter within the PQL metric for the specific type. Now, with the view set-up we can plot only one line, sicne we cannot add multiple Y-axis.Is there a new way (ex. like the “hue” attribute in seaborn library for python) to do this? Or a tip workaround to be able to do it ?

Hi all, The Celonis module that creates PDF's in Action Flows can't find my View. The Connection seem to work with the App Key that also has the right permissions and the View is also published. I always get the error "Something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID: e9c4bdad-04c3-49ea-b834-0e2dc618323b" from the 'Analysis' dropdown within the module. Does the Module even work with the new Views (JAB) since the next Parameter I need to fill in is 'Sheets' but the new View doesn't have Sheets, it has Tabs?

Hi all,I encountered some problems with the Conformance Checker Sheet in the Analysis.I did model a BPMN model and its rather simple but has some AND parallel arcs as illustrated below.In natural language “A,B,C has to be finished before D starts,but the A->B arc and C can happen independently of each other”.In the Overview I can now see Violations like:A is followed by C B is followed by C C is followed by DAll of which I would consider allowed in the sense of the model. Of course I can manually whitelist all of the violations, but this is rather high maintenance and distributes the single point of truth which should be the model. For me it is about understanding if this is a limitation of the Conformance Checker.Did anyone experienced something similar and

Hi everyone! I am trying to built a Celonis query where I calculate the median time in a process between the Event “DRAFT” and the Event “FINAL”. I would like to additionally get the median value only for one country (e.g. Norway (NO).I have the following query which seems to work without a country condition:MEDIAN( PU_MEDIAN( DOMAIN_TABLE("ACTIVITY_TABLE."ProcessId"), CALC_THROUGHPUT( FIRST_OCCURRENCE['DRAFT'] TO FIRST_OCCURRENCE['FINAL'], REMAP_TIMESTAMPS( "ACTIVITY_TABLE"."TIMESTAMP", hours ) ) ))Now I have problems adding the country condition which would be found in the column ACTIVITY_TABLE.”country”. Maybe I have been starring at the query for too long :D. How do I add it? Best regardsAlex

Good dayI would like end users to be able to configure a time and then be able to use this time in various KPI calculations in the Views that we are building. I created a Runtime variable (package level) called COTime_USD, I then configured input-box Form Component in a view and set this to data type: time (the input-box can also take “date”, “number” and “string”). I would then like to use this variable ${{COTime_USD}} in calculations and typically add it to a date (ie ROUND_DAY("o_custom_Payment"."Date").I have seen for dates, the variable needs to look like this in order to get it to work in calculations: {t ${{COTime_USD}} }, but I am not sure what I should use in stead of the “t” to define it a time.  When I try to execute the calculation I get stuck at “Syntax error near [:]...”. I have tried the following calculations: ROUND_DAY("o_custom_Payment"."Date") +

Hello,Can we create users in Sailpoint and can we integrate with Celonis so that user will be created automatically with a role in Celonis?

Hi all,I try to display the correct throughout time for the process variant in the Variant Explorer (shown to the right for the graph/list) for cropped process flows.I have cropped the process scope using CALC_CROP, both as a custom dimension and as a load script filter. The Variant Explorer returns the correct process of scope, but the total throughput time shown per process variant (shown to the right for the graph/list) is still based on the default CASE_START and CASE_END and not the process defined in the CALC_CROP.I.e, the sum of throughput times between the displayed process steps is not the same as the total throughput time for the variant.Is it possible to show the correct throughput time, given the process defined and visualized in CALC_CROP?Thanks!

Hi All - How can I add a line on the secondary axis to this stack graph in the new views?