Data Ingestion & Infrastructure

Hi there I would like to use nested variables:I have a dropdown button with two items: 'dont filter and filter according to parameters.When I choose the option dont filter I, well, dont want to apply filtering on certain components.When I choose the option 'filter according to parameters I want to apply a filter that also takes one or more other variables into account.Currently I have a variable that I use for filtering, where the variant including filters looks something like this:FILTER "MY_TABLE"."MY_COL" > <%= myvar %>;However, this does not seem to work as the myvar variable is not replaced by the value of the variable.Any ideas how I can have a filter that is disabled, or executed using other variable(s)?

Hello,can someone from Celonis please provide proper documentation for RCALL and RAGG functions? I do not understand how to do the syntax of the code (it is obviously a bit different than in R studio) and errors in Celonis do not really say anything.Best Regards and Thanks in advance,Vclav Juren

Hi, I would like to understand why when I extract the movement type for a cancellation of reception, the result appear in positif in Celonis ? SAP : CELONIS : I verified that are the same ligne (mvt type 102, same PO, etc) Thanks in advance.

Dear Celonis Community, I have a tricky statement to built and could not find a solution yet - maybe one of you have a nice idea! In our company we have so-called local customer hierarchy which is used on the one hand for grouping of customers and have settings on higher level than customer number. On the other hand used for reporting on different levels. This hierarchy is our a-level-hierarchy and it is usually used by the local affiliates. Technically the assignment can be found in entries from KNVH, where KNVH-HITYP = A. When reporting in headquarters a-level-hierarchy-numbers are grouped into f-level-hierarchy (also called GCN=GlobalCustomerNumber) and reporting is based on f-level. Technically the assignment can be found in entries from KNVH, where KNVH-HITYP = F. Basically as not always the lowest level of a-level-hierarchy is assigned to the lowest level of f-level-hierarchy, I have to check every a-level-value against the lowest level of f-level-hierarchy. I built a statment t

Dear Colleagues,I am trying to calculate average workload for a selected subprocess within the whole process.For that I wish to assess the average number of activities between specificed SOURCE and TARGET.It should show that from the moment invoice is received by AP accountant up till the moment invoice is posted, certain number of additional steps has to be executed. I wish to present it in various dimensions (for example in OLAP table by company code as dimension).I tried the formula presented in attached picture, but unfortunately it does not work.How can this scenario be applied?Thank you in advance for any suggestions.image.png957765 16.6 KB

Hi All,I am looking to build a case when statement in the load script area. Basically, I am building an analysis where certain local markets want to exclude fields . For example, for the Germany local market, we would like to exclude all FI vendors starting with 3 and in Spain they want exclude all real estate invoices, and so on and so on.As these filters will apply to the entire spreadsheet, I was hoping to write the code into the load script area, for ease of use, instead of each olap table but I am getting an error. Is this because you cannot write case when statement in the load script setting? And if not, can you please propose a workaround?Thank you,Anna

We have a data structure with case, activity, customer and contact tables.A contact is linked to a customer (N:1),A customer is linked to an activity (1:N),An activity is linked to a case (N:1).A case can be executed for multiple customers, hence this relationship structure of customers linked to activities.The challenge/question is to count the number of contacts for a customer of a specific case.Bonus challenge: only select those contacts that fall within the case runtime (which are attributes in the case table).The problem were facing is the famous no common parent between tables could be found error, and we believe the even more famous PULL UP functions could help us, combined with a DOMAIN_TABLE possibly. However, the relationship is such that we cannot just access a parent or grandparent table, but need to go to the parent (case) of a sibling table (activity) of our child table (contact), through customer which is our direct parent.In our example Customer is the parent table of b

Im having some trouble understanding how the built-in Number of process variants KPI is calculated. I dont understand why these two statements are not equivalent. KPI("Number of process variants") versus COUNT( DISTINCT VARIANT( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" ) ) image.png900323 21.4 KB

Hi,I am trying to calculate payments terms in an Accounts Payable Analysis. Right now, my formula is:SUM((CALC_THROUGHPUT(First_OCCURRENCE[Vendor Creates Invoice] TO Last_OCCURRENCE[Pay Invoice], REMAP_TIMESTAMPS("_CEL_AP_ACTIVITIES".EVENTTIME, DAYS)))*(BSEG.WRBTR))/SUM((BSEG.WRBTR))Is it appropriate to do calculations combining BSEG and CEL_AP_ACTIVITIES Table? I would be curious to know if there is a better way to do this.

Hi,I am trying to create a table that will show me which vendors operate in two different markets one of them being Spain. Some of vendors will be listed more then once in the market thus making the pull function a bit difficult to use I believe.Not sure where to go from here but Ive been trying different codes with no luck.Case when Cases.VendorName = Cases.VendorName AND WHEN Cases.LocalMarket = Spain AND Cases.LocalMarket = % THEN Cases.VendorName ELSE NULL ENDPlease let me know.Anna

Hello, Can someone please help with table loader pool types? What is difference? Impact on data load? When and which type should should be used? Thank you in advance! KR, Kalpesh

I am trying to convert the data present in an OLAP table to a dataframe.c = get_celonis(**settings)w = c.workspaces.find(KPI Analysis - CSAT,None)a = w.analyses.find(CSAT Model,None)q=a.published.components.ids[7ae951ac-b933-4e62-b8c0-ee21e6a15845].dataCan anyone please help me what can be the command to convert q into a dataframe.Thanks!!

Dear Community, We are trying to understand the Data model status option Reload all partitions. We have tested this option with one data model and the data model load completed and the remaining data models load not started automatically. Could anyone explain this option Reload all partitions! data model - reload all partitions.png1588506 40.7 KB

Hello Community,We are developing a new algorithm to help users detecting duplicates.As an inspiration we toke the blog: Celonis 5 Steps to Reduce Costs Caused by Duplicate InvoicesCelonis customers have already saved millions by taking action on duplicate invoices. Find out how to how to use fuzzy matching to find duplicates and save money using the Celonis Intelligent Business Cloud and Python. We have noticed that the algorithm detects false positives. In the algorithm, this might happen because we do fuzzy matching and searching. Now the users like to flag these false positives in the sheet. Moreover, they want the flags they made to be visible for other users using the sheet. How would you implement such a flagging system?One idea we had was creating an additional column in the table that can be adjusted by users in the frontend. In this way, the adjustments could be visible for all the users. Does somebody have any idea whether this is possible?Happy to hear your thought

Hello everyone!Ive got some trouble with unique case aggregation. Ive got case table with column Amount, and events table with status of process. I want to build table wich consist of some columns from case table, avg timestamp between two activities, and sum (casetable.amount).So, I build filter on list:FILTER PROCESS EQUALS (X) TO (A) ;And filters on component(Table):FILTER SOURCE(Celonis_events.activity) LIKE (X) ;FILTER Target(Celonis_events.activity) LIKE (A) ;Next, i build table dimensions:CELONIS_CASES.BUNAMECELONIS_CASES.GJAHRSOURCE(CELONIS_EVENTS.ACTIVITY) - not visibleTarget(CELONIS_EVENTS.ACTIVITY) - not visibleAND KPIS of table:AVG(TARGET(REMAP_TIMESTAMPS(CELONIS_EVENTS.EVENTTIME, MINUTES)) - SOURCE(REMAP_TIMESTAMPS(CELONIS_EVENTS.EVENTTIME, MINUTES)))2)SUM(CELONIS_CASES.AMOUNT)All good, but if within one case we got more than one change status from (X) TO (A) activities - we got (CELONIS_CASES".AMOUNT)*(Count of (X) TO (A) ) and its wrong, because case got fixed amoun

Hi everyone!I want to build a pivot table with year as pivot, month and day as dimentions and the KPI that counts distinct CASE_IDs within the day but just simply sums them up for month or year.So my daily KPI looks at the moment likeCOUNT(DISTINCT (CASE WHEN table1.Activity1"=A then table1.CASE_ID ELSE NULL END))The problem is that I want a simple sum of daily counts for the months and years result. Is there a way to aggregate the values by day in the formsum(for each day COUNT (DISTINCT (CASE WHEN table1.Activity1"=A then table1.CASE_ID ELSE NULL END)) )?Thanks!Best,Maria

Hello, Good day. We had setup a continuous data flow connection from PROD SAP ECC to Extractor Server to Celonis IBC. When running the extraction, we are encountering this kind of error. Metadata changed for table BKPF. Datatype of the column REINDAT changed from DATE to STRING. See screenshot below: CELONIS_IBC_DeltaLoadError3.PNG1080233 51.9 KB Weird thing is when we use the exact same data pool pointing to the TEST SAP ECC system, the extractions works. Would anyone know what is causing the issue and how to solve it? Thanks, RJ

Hello, We are trying to connect IBC to SAP ECC hosted by the client. We successfully connected the extractor server. Upon keying in the SAP configurations then clicking on Save, we are prompted by the error message: Connection test failed, please check the Data Connections configuration and ensure that the system is running: Error invalidating caches: Initialization of repository destination [host]-[system number]-[client]-[user] failed: Password logon no longer possible - too many failed attempts on [host] sysnr 00. What is the root cause and how can this be solved?

Hello!For the sake of performance analysis, I want to create an OLAP table to cover the following aspects of a certain part of a process (Activity 1 -> Activity 2):PerformerTaskThroughput time, daysPercentage from a total workloadATask 1520%ATask 2180%BTask 1120%BTask 2270%BTask 3710%There are a number of encountered problems however.First, a standard THT KPI formula calculates only a difference between FIRST / LAST occurrences of an activity, thus it does not work for measuring time strictly between two activities taking into account all rework and process deviations (like Activity 1 -> Activity 3 -> Activity 4 -> Activity 2 ).To overcome this issue, I used SOURCE / TARGET function, and it works when I just calculate the THT KPI only, but I have not managed to add other dimensions in the table (no common parent between tables could be found).Second, to determine the ratio of a specific task among all of other tasks I again - need to clean the number of cases as it turned o

Hi,I am trying to allow a bit of Text Mining in my analysis and do smth likeCASE WHEN table1.column1 LIKE <%=Variable1%> THEN table1.column1 ELSE NULL ENDIt works fine with a Variable defined with the help of the Variable Input component with to show thats a text piece. What I would like to do is to manually define some categories as a Variable and use them.For exampleI would like to define Categories like Green, Red and Apples (for example in dropdown) so that i can just choose them without need to type them down everytime I need.Any ideas?Cheers,Maria

Hello Everyone,We have some KPIs which are the result of a Criteria over the population. I.e cases that follows directly from process A -> B DIVIDED all the cases that went through AThere are cases where the numerator and denominator are Zero , Celonis manage 0/0 as NULL which is correct, but for my KPI I should present either 0% or No Activities instead of -Can you please advice the effective way to manipulate the output of the KPI to manage the Nulls?Regards,Example:SUM(CASE WHEN BKPF.AWTYP IN (BKPF, BKPFF, BKPFI, IBKPF, TRAVL)AND BSEG.BSCHL = 31AND PROCESS EQUALS Invoice posted TO Pay InvoiceTHEN BSEG.WRBTR_CONVERTEDELSE0.0END)/SUM ( CASE WHEN MATCH_ACTIVITIES(ENDING[Pay Invoice] ) = 1AND BSEG.BSCHL = 31AND BKPF.AWTYP IN (BKPF, BKPFF, BKPFI, IBKPF, TRAVL)THEN BSEG.WRBTR_CONVERTEDELSE0.0END)

Hello,we want to add two dropdown filters to select purchase order items by creation year.One by calender year and one by fiscal year.The one for calender year would just be YEAR(EKKO.AEDAT).For the fiscal year the dropdown option 2019 should contain all purchase order items with EKKO.AEDAT between 1st of May 2018 and 30th of April 2019 and so on. Can this be implemented?I tried the following, but the error not implemented yet appears.CASEWHEN EKKO.AEDAT BETWEEN 2018-05-01 AND 2019-04-30 THEN 2019ELSE END

Hi there,Im getting the wrong values in two different cases when Im dividing in celonis:Case 1:(Sum(CASEWHEN ((EBAN.MENGE)/(EKPO.MENGE)) < 1 THEN 1ELSE 0END)+Sum(CASEWHEN ((EBAN.MENGE)/(EKPO.MENGE)) > 1 THEN 1ELSE 0END))/(1.0*COUNT_TABLE(EKPO))Individually the first sum evaluates to 455. The second sum evaluates to 249. the numerator is then 704. The denominator comes to 3555.The output should then be 704/3555 = 0.19803But the output on Celonis is 0.2068762Case 2:SUM(CASE WHEN ISNULL(EBAN.FLIEF) = 0 AND EBAN.FLIEF != EKKO.LIFNRTHEN EKPO.MENGEELSE 0.0 END)/SUM(EKPO.MENGE)The numerator comes out to 4069455The denominator comes out to 1521749967The result should be 0.0026741The result is 0.0077356Any ideas whats causing the wrong values?

Situation: We have a data model with an activity table, cases table, and some other tables.Problem: We would like to only consider those records in the cases table for which an activity exists.Details: This works if both tables are used in the same component, because in the backend the tables are automatically joined from activity to case (left join). However, when for instance counting the number of cases (count_table(cases_table)) all cases are considered. We therefore would like to set a load filter or pinned filter that filters out those cases for which no activities are recorded. Any ideas on how to do this???Ideally we would also like to automatically filter our other tables to only keep records linked to an activity.We are coming from a single table setup where all tables where joined into one large table. This problem did not exist then, but performance (especially when reloading) was sub-optimal. The new setup performs better, but apparently has its limits.PS: I feel the PQL f

Hello Community, following config-custom.properties setting is offered: # Query Settings # -------------- # Maximum number of threads used in a query. To use an unbounded pool, use the value -1. By default, 30 threads are used. # query.parallel.maxthreads=30 How is this setting influencing a) end user (frontend) performance? b) backend ressource consumption? Is there a best practice about how to configure this setting? Best regards Sebastian