Product Q&A

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. ?

Dear Experts, For an analysis we need the data that is shown in the ''list'' view of the ''connections'' area from the Process Explorer. We have many different activities and need the count and time between two ''activity pairs'' as shown in that list view.  We can manually copy this but that would be a very tedious task. We were wondering whether it is possible to export this data somewhere.If not, is it possible to get a list of all activity pairs and their respective throughput time between the two activities if they follow each other directly. Kind regards, Dirk

How can I get a more precise time for the median throughput time and the fastest and slowest case on the automatically generated page "Throughput Times (Details)"? I always get only: fastest case 1.00 min or slowest case 14.00 min. But I would like to have a more precise time with seconds. I have already read the documentation & tried various things, but I am not getting further here.  Can someone help? Thanks a lot 



Hi all,Is "component is not filtered with selections" as attached below available in a Celonis View? I want to add a KPI card that ignores all selected filters, such as sheet filters, so it can display a comprehensive number without any filters applied.Thanks. 

This app does not feature as an app in the app store, but it is fully integrated into Celonis.

Hi Experts, How to create public link to make my dashboard available for use by external teams ?  

I have a chart where the x axis contains a lot of values. Here I don't want to display every single case, but to include a certain distance in the values. For example I don't want the values 1,2,3,4 .. 10 etc. but 5,10 etc. to be displayed. Unfortunately I didn't find a way to do this in the options.  Thanks for the help

Dear experts , i wish to verify some metrics using different case id after i created my analysis on first case id. Can you advise how can i reconfigure the case id ?

Hi, I was looking through Celonis documentation but I cannot find the information were to find detailed Extractor Info. Uplink Integrations in Admin & Settings show only the connector version without details, while I'm looking for something like that: Thanks.