Data Ingestion & Infrastructure

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

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

 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.

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.

HI, I am trying to set up an Activity History. I have been following the documentation but it references the objectid of the activity that we want to use. Where can I find/create that object ID so that it references the activity table I want to show in the activity history profile view? Thanks!

Dear Experts, I would like to create an unsorted index on an OLAP table in the Analytics new sheet.​I'm use pql ​dimension INDEX_ORDER (COUNT (DISTINCT "table"."column"))"table"."caseid"​kpicount("table"."caseid")​now If I sort case count, ​Indexes and case IDs are turned into a set.​I want the index value to not change even if I sort by case count.​ex)​index | caseid | case count​1 | A | 32 | B | 23 | C | 1 ​sorting -> ​nowindex | caseid | case count (sort)​3 | C | 12 | B | 21 | A | 3 Goal index | caseid | case count (sort)​1 | C | 12 | B | 23 | A | 3-> This is my goal

New update to Data Pool UI - finally you can filter / search by name, tag (label), data connection and created by!  

Dear Experts, i have question here , lets say if i have SAP GRC and all the transformations are being performed inside it and based on some calculations it generates notification. Can we connect on this this notification to Celonis and based on this notification i have to do something on celonis data model ? So the only thing i am trying to interface with notification from external system without interfacing entire data and want to check if this is possible . ?

Hello everyone, I want to present a KPI using a custom format not available in the default format options. Is it possible to create custom formats somehow? I cannot change the KPI value because it must be used as KPI of a pivot table. Thks!

is it possible to use crop selection to filter the activities within range in Views? the similar function is available in the Analysis module out of box.

Hi can anyone help me in how touse EMS platform of celonis since i am very new to this platform and i want to upload a dataset and try this platform

Dear Experts, I recently created an app and realized that i need to add one more table into data model. Is it possible to go ahead uploading my table and loading data model without disturbing everything i created ( like views , PQL formulas etc )

Dear experts, Lets say there is activity Y that i want to know average time spent on , Also in this there are n number of activities preceding it and n number of activities following it. which i dont care. Will it be possible to identify avg time spent on this activity using PQL ?  Thanks in advance ,

Hi everyone, I have a question please: I would like to display in a view or in a KPI Card a year to date value and a Last year to date value, which are not sensitive to time filters but still sensitive to all other component filters. Can someone help me please? Best regards,Dany

I have 3 tables in excel format Table 1 contains P2P activity data Table 2 contains inventory movement activity data Table 3 contains activity data for production order.  Unfortunately they dont have common key , but each table dont have foreign key to link each other, can still event logs be merged using automerged functionality and represent on process explorer ?

Hi Experts , Lets say i have to compare activity time lets say "Goods Receipt" time which is present in activity table with Expected delivery date which is present in case table. Should i be directly substracting activity time on Olap table and fiter table by activity == "Goods receipt" OR Is there a good way using PQL ?  Thanks - Shaif

Dear Experts , Can you suggest right way to find list of violation users who not only created Purchase order but also approved purchase orders. ? 

Hi Experts,Is there any way to fetch user login history to data pool?Try to build visualisation on user/app performance and I need this data in app/ studio.I have checked custom data pipeline and monitoring but it's not there.

Do any of you know how to count the number of different currencies on a given supplier ? I want to create a condition that determines if the currency on a new incoming document is different from the least occurring currency on previous documents of the same supplier with the same company code.

I have an ACTIVITIES table where I am trying to calculate the time (in hours) between each OPERATION. The way it is set right now, I have CASE_KEY and for each CASE_KEY, there can be 1 to N operations. What I am trying to do is to calculate the time difference between each unique operation (for ex: for operation 0100 to 1000 the difference is 10 hours, for operation 1000 to 2000 the difference is 15 hours..etc) So I was able to utilize HOURS_BETWEEN and using SOURCE and TARGET, I was able to calculate the hours. What I have a column that indicates Operation start and Operation end. Based on that I am able to calculate the HOURS BETWEEN Operation by using End as SOURCE and Start as TARGET. The problem I run into is when there is an operation starting within an operation. So for ex: Operation 0100 starts, then right after Operation 1000 starts followed by Operation 1000 end and then after Operation 0100 end. Given how I am using Source and Target at the moment, it is definitely skewing t

I have cases table with _CASE_KEY and OPERATION NUMBER. Each _CASE_KEY can have N operations. For ex: _CASE_KEY: 01000200OPERATION 0001OPERATION 0100OPERATION 0500OPERATION 0700 (etc)_CASE_KEY: 03000200OPERATION 0001OPERATION 0100OPERATION 0500OPERATION 0700 (etc)The goal is to calculate the time it takes from last operation of a case to first operation of the next case. In the example above, it would be time difference between the _CASE_KEY 01000200, OPERATION 0700 to _CASE_KEY 03000200, OPERATION 0001. I am trying to use the PU_FIRST and PU_LAST to accomplish this goal but unfortunately it is NOT giving me what I am looking for. Any help would be appreciated. I do have the ACTIVITIES table where all of these operations that I've mentioned above are shown.  

If we are using DOMAIN_TABLE in an analysis, the external filters applied (Load script/Sheet level/Component Level) may not work properly in all cases. I could see such cases when DOMAIN_TABLE used, external filters will not work properly. Any thoughts on this or my approach is not correct? Can someone comment on this

I have a complex knowledge model (customized AR knowledge model from the marketplace) which has several KPIs pre-defined. I want to make an action flow using one of these KPIs with the query data module. The issue is that I cannot reference the KPI like KPI("KPI_INVOICE_CALC_PAID_ON_TIME_RATE") in the AF and since the original KPI formula is also referencing other KPIs it is not possible to get the raw code and insert that instead. Is there any workaround to easily use KPIs in action flow that are defined in the knowledge model? Thank you for your help!Balázs