Product Q&A

I need to add aaranyi@schema31.it and I need to remove fgiannuzzi@schema31.it ThxS

How is the membership to 'my team' arranged in Celopeers? Background: We have several users in Celopeers, belonging to a Celonis EMS-team, but cannot view cases created by the colleagues.

Hello everyone, are there any advanced use cases (Material management, P2P-Cockpit, whatever, ...) where one can simply see advanced PQL-functions in action? (For free)I am struggling with advanced PQL-Functions (Nested PU-and BIND-Functions, Domain_Tables, ...) and the learning curve is quite harsh without any actual real world help and examples. Especially Material Flow Management. Like e.g. Analysises about current stock, stock evaluation (future arriving orders vs future used material), stock over time (Stock + Arrived orders - Reserved material for production) etc. The idea behind such things is in my head. But the actual functions to combine the data accross multiple tables is still really advanced.  I´d love to see some examples somewhere. I dont know if Celonis provides something like that? I feel like a lot of stuff is kind of behind paywalls (Consulting firms).

Using action flow can we directly get the data from data pool without using data model

I see the word custom process in Celonis Academy, what is a custom process? For example, is importing the add-on SAP into Celonis a custom process?

Hi Celopeers, Can anyone help with a filter function to select all cases in a 12 month period leading up to a specific date? So like all cases in the 12 months to 30th April 2023?

Dear Experts , I used smart sensor and create task functionality to create 3 Skill objects. Initially before running this duplicated task name as "Missclassified Assets" in all the 3 skills and hence in Inbox task appears same , even though contents are different. Now i have updated the task name by changing it inside task settings , but still its not getting updated. Kindly help me with your advise ? Attached reference snapshot for you

I want to create an ABAP report to extract data, where do I start?

HI Community, is there a way to migrate Analysis from CPM4.6 to the IBC without pycelonis (at least without pulling from the environment)? The problem is, that we do not have a way to connect to the OnPremis Environment via python. So it would be nice if there was a way to use e.g. a Transport-File (.ctp) which can be uploaded to the IBC, or at least used with pycelonis from an external server? Help would be greatly appreciated. Thank you Best Max

XES file upload in Celonis Free Plan doesn't load. File upload works, but the step 2 (configure-activity-columns) doesn't load the screen. Data set I'm trying to use is: https://data.4tu.nl/articles/_/12716513/1 I have set the limit of the space to 20Gb, so this should be enough.

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