Product Q&A

(COUNT(CASE WHEN KPI("VALUE_PAY") <'0' THEN 1 ELSE 0 END))/(COUNT(CASE WHEN KPI("VALUE_PAY") >'0' THEN 1 ELSE 0 END))

Hi, I registered as a Customer with my company account by mistake instead of Partner. How can I switch? I am now not able to create a Partner account with my company email address. Thank you for your help

Hi, Can someone please provide any architecture details or any docs related on how to setup PowerBI connection for Celonis action flow? I already checked the celonis docs but it looks like its not enough or there's no specific instruction on how to setup PowerBI connection actionflow to Celonis. We are planning to use this Celonis PowerBI Action flow modules but we are not able to setup the connection between celonis and powerbi as the 1st step. Thanks!Neil Cascante 

I am calculating freight cost (which is on header level) for orders and would like to show all orders along with order items in an OLAP table.Now there are certain order items which I would like to identify and be ignored for which I created a KPI called "identifier":Now when Identifier is 1, I want POSNR of such order items to be considered and take the first available "POSNR" and put the Freight cost against it.  The result however is coming on the first POSNR which should have been overlooked based on my identifier:

Hi I am creating smart sensor to generate signals but getting below error { "message": "Failed to create task. Augmentation Error: Client Error: The schema of table [DUPLICATE_INVOICES_CEL_TASK] contains [22] columns but [24] columns were given." }

Hi, I would like to use a formatNumber(...) function in the result of the SUM() function. The operation is unsuccessful, I receive information The operation failed with an error. Failed to map 'formula': Function 'formatNumber' finished with error! 'NaN' is not a valid number or using unsuitable separator. Do you have any advice?

I want to import a manually transformed table from datapool to ML workbench to do some operations. Is it possible to do that without loading the data model? Can i import the transformed table directly?

Hello All, I need to export all the Cases in sheet "Cases Explorer" but I can not find the way to do it. I used the method "Flat Files" to building the Event Log and build Data Model from this (not real-time connection, such as cloud, etc.) Does anyone know how to do it? Many thanks All.

initial output : C76_XX_XXXX_INVOICE_LIV_XXXX_XXX.001.pdf what i would like :C76_XX_XXXX_INVOICE_LIV_XXXX_XXX_001.pdf Thanks for your help

Does Celonis provide Snowflake connectors? If yes, Is it a paid subscription?

Is it possible to hide certain activities in the Process Explorer that are not relevant for X user? I was trying the sheet filter FILTER PROCESS NOT EQUALS [Activity Name] but this excludes the cases, not only the activity.

Hello Celopeers, I have a Studio analysis that is super slow because of many filters, it loads often slow when you switch between the sheets. Do you think that moving the common filters to analysis lvl can have a significant impact on the performance? Thank you for any opinion!Jan

Hey Celopeers community! I am attempting to create a change activity based on a changing list of values, below is an example of a case where a change activity should be created.  Case ID | Date | Value1 | 2021-8-20 | A1 | 2021-8-20 | B1 | 2021-8-20 | C1 | 2021-8-21 | A1 | 2021-8-21 | B As you can see the list of values changed from A, B, C on 8/20 to A, B 8/21  I looked at the VERTICA function library and found LISTAGG function that would help solve this by concatenating fields into one single row, but, unfortunately, it is not enabled in Event Collection.  Are there any workarounds you can suggest? 

The following PQL formula is the default for PQL KPI's. Am I correct in understanding that the following only calculates processes that start with a specific activity and cannot be calculated if the flow of a specific activity is included in the middle of a process? KPI("Ratio", PROCESS EQUALS START '' TO ANY TO '' END ) 

Please modify this code,  FILTER MATCH_ACTIVITIES ( "finalResult_0_01"."ACTIVITY" , NODE ['<%=display_code_1%>'] ) = 1; so that it also works with variables similar to display_code_1. I tried  FILTER TO_STRING(MATCH_ACTIVITIES ( "finalResult_0_01"."ACTIVITY" , NODE ['<%=display_code_1%>'] )) LIKE '1%';  this code and also some contains, regex_like etc but Celonis EMS does not recoginze both function. Thank you 

Package creation flow supports object-centric process mining (2023-05-31) You can now include perspectives in Studio Packages for object-centric process mining. Perspectives are views on the object-centric data model including a subset of the object types and event types that is relevant to a process, or to another grouping that you want to analyze. See Perspectives for more information about them. You include perspectives in a Package using Data Model variables. A package can't contain a mix of case-centric Data Models and object-centric perspectives. They all need to be the same type as the one you use in the first Data Model variable that you add to the Package - so either all perspectives, or all case-centric Data Models. To swap a package between case-centric and object-centric models, you'll need to take all the variables of the previous model type out before adding the new type.

How to identify open invoices from BSEG table in SAP ?

Dear everyone, I want to transfer an analysis into a view. In the analysis I use the formula DIstrinct "MD04"."MATNR" to get all distinct Material Numbers as they can show up multiple times in the table columns. I now wanted to do the same in the view, but get the follwing error:Does anyone know how to solve this? Thank you very much for your time and help! Best Ole

Hi, I have a question related to some quality of life changes in UI.We have two Celonis environments PROD and QA. I know that I can see the env in which I am by looking at URL, but I would like to have some more visual ability to distinguish between the two. Is it possible to change the navigation bar (I believe that what it is called - see the image below) to a different color? Or to make some other change to parts of UI that are always visible in order to have that visual difference at a glance of an eye?Thank you,Karol

Hi, We have two Celonis environments - PROD and QA. The latter one was used at the beginning for some tests of initial implementation of the tool and was left unused for a while now. As a result there is some old useless junk in it.I would like to replicate what we have in PROD (not the data itself as there is not enough space in QA, but the entire Data integration part including ETLs and data models, Studio part with knowledge models, views, analysis and all KPI) to QA so that it could serve its correct purpose.Is it possible to do it in an automated way? Thanks,Karol

Celonis does not seem to have any out of the box user load testing solution. How do we test for future increase in users accessing the use cases? Can we user Apache JMeter or LoadNinja for load testing? Would there be any network security or data security concerns?

Hello, For an analysis I have a KPI with cases per quarter. I also want to have an additional KPI that accumulates the data over time. As the dimension is also time-related, I don't know how to really approach this as the data always seems to be separated per quarter. Any tips how to do this? Thank you!

how can we integrate celonis with SuccessFactors

The result I want to obtain is the same we have by default for the hours/case frequency directly on the Process, but from a cost perspective. Is that possible?  Thank you, Giulia