Product Q&A

Hey there! I'm having trouble selecting cases from a table, that match a calculated condition.  The data I'm trying to analyse is about quality-checks. A quality-check consists of multiple rows in which the result (minor fault/major fault/no fault/not relevant) of each checkpoint is delivered. My goal is to calculate the quality of each quality-check and display those quality-checks which didn't reach a certain percantage of quality.  What I already did is: Calculate the quality of each check in %1- (SUM(STR_TO_INT(REMAP_VALUES("CASE_QS"."RESULT", ['no fault', '0'], ['minor fault', '5'], ['major fault', '10'], ['not relevant', '0']))) / (COUNT("CASE_QS"."CHECKPOINT")*10))Create condition to evaluate whether the desired quality of 99,9% isn't reachedCASE WHEN (1- (SUM(STR_TO_INT(REMAP_VALUES("CASE_QS"."RESULT", ['1', '0'], ['2&#3

For example - activities within a process flow are dependent on different source information. I would like to show the source of the activity in the process steps. For example, one step would be a letter requesting "Income Information". Another step would be received "Income Information". I guess could concatenate source and Activity, put then I'm stuck with that.

Hi. In views, when designing a benchmark tab, I want to link both the PE and KPI lists to the chosen dimension.I select a dimension in a first dropdown (eg. Company Code) , then select the different company codes I'm trying to compare (in a different pair of dropdowns), but these components (Process Explorer, KPIs, etc..) do not update. In analysis I'd need to create a component filter, but how to proceed working on views?

Is there any best way to identify unused tables and fields from knowledge Models/ Data Models

I am trying to combine multiple KPIs into a CSV, but it doesn't seem to work.Each KPI has different filter so I'm using several Celonis modules to separately get those KPIs. Please refer to the screenshot below. I had the following two problems:(1) The third Celonis module appears to be running repeatedly many times. So I had to stop the Action Flow manually.(2) The CSV file also has a very large number of rows than expected. Multiple rows of the same Company appear. Originally, one company with one row is expected.  Is there any method to combine multiple KPIs with different filters into a CSV?Should I use Iterator/Aggregator to combine those modules? Yours,Chen

What do I have to do to copy the data pool?

Hi Experts , is it possible to receive KPIs from other analytics tool like Qliksense and Power BI. using APIs ?

Hi everyone,  I am trying to modify the duplicate checker app. Precisely, I have a column in BSEG (called MANUAL_CN, of Yes/No type) which I would like to use as a filter which exclude groups of potential duplicate invoices if there is at least one invoice for which BSEG.MANUAL_CN='Yes'. Unfortunately, I am in the situation where no common table could be found so I was wondering if there is a workaround of this issue.  Here is the data model: I have tried to use BIND function, but not successfully... so any suggestions would be highly appreciated!  Thanks in advance!

I want to create a filter of an ELSE inside my condition. The   ELSE 'Área Não Aderente'. Below script. I want to bring only the data from this ELSE, which would be the opposite of my condition below.  CASE WHEN       ("EKKO"."BSART" LIKE 'Y%' OR "EKKO"."BSART" LIKE 'PE' OR ("EKKO"."BSART" LIKE 'Z%' AND "EKKO"."BSART" NOT IN ('ZCG','ZPM', 'ZCAT')))    AND     ("EKKO"."EKGRP" LIKE 'I%' OR "EKKO"."EKGRP" IN_LIKE ('%1I','%2I','%3I','%4I','%5I','%6I','%7I','%8I','%9I') OR "EKKO"."EKGRP" LIKE 'A%' OR "EKKO"."EKGRP" LIKE '01A')        THEN -- Pedido por Área     CASE WHEN         PU_COUNT("EKKO", "EKPO"."MATNR", "EKPO"."MATNR" IN_LIKE (

I need to filter documents by taking the current month. Ex.: Filter documents from the year 2023 taking the month of MAY(Current)

I want to create a filter of an ELSE inside my condition. The  ELSE 'Área Não Aderente'. Below script. I want to bring only the data from this ELSE, which would be the opposite of my condition below.  CASE WHEN   ("EKKO"."BSART" LIKE 'Y%' OR "EKKO"."BSART" LIKE 'PE' OR ("EKKO"."BSART" LIKE 'Z%' AND "EKKO"."BSART" NOT IN ('ZCG','ZPM', 'ZCAT')))  AND  ("EKKO"."EKGRP" LIKE 'I%' OR "EKKO"."EKGRP" IN_LIKE ('%1I','%2I','%3I','%4I','%5I','%6I','%7I','%8I','%9I') OR "EKKO"."EKGRP" LIKE 'A%' OR "EKKO"."EKGRP" LIKE '01A')    THEN -- Pedido por Área   CASE WHEN    PU_COUNT("EKKO", "EKPO"."MATNR", "EKPO"."MATNR" IN_LIKE ('%3001009%',

In Action Flows, I am modifying an augmented attribute. The augmented attribute automatically created a supporting table with an attribute changed_by. this attribute is getting a uuid reference to the user. But, I can't find any documentation to convert it to a name.

I am trying to upload a file provided by Celonis for demo purpose into my Celonis environment. The file already contains the _CEL_CHANGE_DATE column in it. While uploading the file, I'm getting an error "ERROR: Duplicate column "_CELONIS_CHANGE_DATE" in create table statement.". Is there a way I can disable this column generation during upload or any other workaround. Appreciate your help.

is there any way, if we can freeze one column on OLAP table and put filters on rest of the columns on the same table??

 I used some PQL functions like TIMELINE_COLUMN/TABLE to build a common time axis to try to plot the invoices that were open at any given date but I have not been able to make it work.

We have a requirement to connect multiple source systems with the celonis process mining application and then merge event logs from these different source systems to show end-to-end process flow. Also, we wanted to understand how different source systems like Salesforce CRM, SAP ERP, and custom business applications can be combined integrated with celonis process mining application to show the end-to-end interconnected business processes that are flowing through these source systems. Is it possible to combine these event logs from the different source systems within celonis process mining or do we have to connect these different source systems to the datalake system and then perform an event log merge outside of the celonis process mining application.

Dear Experts, I have never created network diagram that is available within View component . When i tried it says following items to be addedSource Target Node Edge  I have added following configuration to visualize user approvals  Source - as Activity table Target - blank Node - user (from activity table ) Edge as values (quantity in transaction )  Diagram is not appearing. Can you please advise me what modification can i do ?

Hi all,  Now I'm looking for the detailed technical document for O2C connector on celonis market place, that contain case table definition that should have column information what the column stands for.Does anybody know such a document?  Thanks

Dear Experts , I have peculiar requirement which i might be making more complicated. Here is the requirement. Lets say X is the document that gets posted every day and Some documents are with "Y" status and some are not . Requirement is to calculate Percentage of document posted each "Month" with Y status . So KPI should look like  Jan 2023 - percentage of x document posted with y status in Jan are 10% Feb 2023 - percentage of x document posted with Y status in Feb are 23%  My challenge is how to ensure in PQL query that in this formula given below i am only using Total document in "Given Month"  Formula = X document with y status / total docs posted in "Given Month" . Any guidance / keyword / help is requested.

I need a filter that doesn't bring me the documents of the current month.

Dear Experts, I want to use case when or if statement in component filter. The reason is that I want to set the default value when the button dropdown is not selected when the condition is set for process explorer using a variable and button dropdown.​For example, I wanted to filter process explorer to the value I selected among "table"."column", so I used a variable and a button dropdown. If the button dropdown is set to "table"."column" and the filter is set to FILTER "table"."column" = <%=variable_name%> in process explorer, if I don't select button dropdown, process explorer has syntax error occurs. In order to prevent this case, I want to set the default value using casewhen or if statement.

Does anyone know how to select multiple elements in order to copy those?I tried with holding Shift or Control but I am not able to select multiple compononets (in order to copy them to the other tab). There is an option to select and copy all components to other tab, but I need to only copy some of those in bulk. Maybe I am missing something?  Bets regards,Krzysztof Rafa

Dear Experts, Can you advise me if there are websites to read recent process mining researches contributed by major experts of world. ?