- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months ago

Home
Community
Product Q&A

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3049 Topics

Most replies

Most views

Newest first

pim.meule12Level 2

asked in Data Ingestion & Infrastructure

Average of PO’s per week over multiple weeks

Hello Everyone,I need to compare for each Vendor the amount of POs of last week to the average number of POs per week of the 12 weeks before (from today -2 until -13). Im only not totally sure on how I can solve this issue?I use this formula for the amount of POs of last week.PU_COUNT_DISTINCT(LFA1, EKKO.EBELN,(CASE WHEN ROUND_WEEK(EKKO.TS_AEDAT) = ADD_DAYS(ROUND_WEEK(TODAY()),-7) THEN 1.0 ELSE 0.0 END)=1.0)And tried using Moving Average for the average over multiple weeks, but Im not getting this solved in a way which would provide me with just 1 average.Table need to look like this:Vendor POs last week Average # POs per week over the earlier 12 weeksXYZ 8 3,2Thanks in advance for any help on this topic.Best Regards,Pim

4 years ago

antoine.spiriLevel 1

asked in Data Ingestion & Infrastructure

Warning Transformation Task : SELECT INTO - Please use CREATE table AS insted

Dear everyone, I hope you are all doing okay ! When executing a transformation task (Cancel Invoice for M2C) i get the following warning : Warning! SELECT INTO statements currently only insert 100 rows. Please use CREATE TABLE AS instead I do not understand why this happens since it appears also when i do not use a select into statement but only a distinct count statement See below my script if needed Very thankful for some advice ! Best regards, Antoine SPIRIDON SELECT DISTINCT COUNT (*) FROM EABL JOIN EABLG ON 1=1 AND EABL.MANDT = EABLG.MANDT AND EABL.ABLBELNR = EABLG.ABLBELNR JOIN EVER ON EABLG.MANDT = EVER.MANDT AND EABLG.ANLAGE = EVER.ANLAGE JOIN ERCH ON EVER.MANDT=ERCH.MANDT AND EVER.VERTRAG=ERCH.VERTRAG AND ERCH.BELEGART IN (VA, SA) JOIN ERCHC ON 1=1 AND ERCH.MANDT = ERCHC.MANDT AND ERCH.BELNR = ERCHC.BELNR JOIN ERDK ON ERCHC.MANDT = ERDK.MANDT AND ERCHC.OPBEL = ERDK.OPBEL AND ERDK.INTOPBEL IS NOT NULL JOIN DFKKOP ON 1=1 AND ERDK.MANDT= DFKKOP.MANDT AND ERDK.OPBEL= DFKKOP.XBL

4 years ago

steven.berndLevel 3

asked in Data Ingestion & Infrastructure

Adding numbers doesn’t work for 100% - why? weird Problem

Hello community,I hope you can help me.I have a simple problem I think, but too difficult for me Here my Formula that not works(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Vorgang beendet],REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))+(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Ausgleichsbeleg_gend.],REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))+(TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[Skonto Flligkeitsdatum berechnen] TO LAST_OCCURRENCE[Vorgang auf Status Zurckgeschickt gesetzt.],REMAP_TIMESTAMPS(T_CEL_AT_ACCOUNTS_PAYABLE.CREATED_AT, DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5))if I speak e.g. with numbers, it is like7,6+8,5+-= - (dont work)another examble7,6+8,5+5= 21,1 (work)My Problem is the - (it is like #NV or no result). Th

4 years ago

.14600946Level 2

asked in Process Analysis

How can I create a self join on a column in an OLAP table?

Hi Team, I have the following situation: 1 column reflects product IDs and the other column are attributes of the product like color, size, etc. Example: I have the following table: Ids Attributes 1 Red 1 5 1 3 2 Blue 2 3 2 1 I have created new columns for each attribute but the result looks like this: Ids Color Size Pieces 1 Red - - 1 - 5 - 1 - - 3 2 Blue - - 2 - 3 - 2 - - 1 I need to transform this table in the following format: Ids Color Size Pieces 1 Red 5 3 2 Blue 3 1 I am not sure if a self-join on the attributes column and based on the Product IDs is the right solution here. If yes does anyone know how to do it? If not then is there a better solution? Thanks for the feedback!

4 years ago

fabian.fabia12Level 2

asked in Process Analysis

Throughput time between one activity and multiple others

Hello everyone, Is there the possibility of calculating the throughput time between between one activity lets say Create Order and multiple occuring activities, lets say Change date. The problem is that Change date can happen multiple time and at each occurance the time between create order and change date should be caluclated. The process is for example: Create Order-> -> Change date -> -> Change date The result, which i want to see is a histogram chart with the information: number of occurances number of days between create order and change date In this example giving me 2 bars for each time difference. Hope i made my case clear. Thanks for any support!

4 years ago

kaijiang.kai.jLevel 2

asked in Data Ingestion & Infrastructure

Does Celonis 4.6(OP version) Support HANA 1.0 SP12?

Dear Experts Does anyone know if Celonis 4.6 (OP version) support HANA 1.0 SP12? And is there anywhere I can find more documents regarding the OP version? help.celonis.com consistently ask me for logon but I dont have an account Thanks!

4 years ago

dave.benneLevel 2

asked in AI

Machine Learning Training - Missing Permissions

Im following the Machine Learning training and am having problems with permissions. Ive created and entered the API token, but get this error: WARNING : the Application key of this App is missing the necessary Process Analytics permissions to use this App properly. I have added these permissions, but still get the error and when I try to Fetch Data Preview not data is returned. Is this a known problem or am I missing a step to add additional permissions? Dave

4 years ago

fabian.fabia11Level 2

asked in Process Analysis

Throughput time from one activity to multiple others

(topic withdrawn by author, will be automatically deleted in 24 hours unless flagged)

4 years ago

.14600929Level 2

asked in Process Analysis

First Credit Release Date and Time

Hi Experts, I am new to Celonis and PQL. I am trying to build a PQL query to fetch, First Credit Release date of of each sales order /Sales Order Item. Can some one guide me on this? Thanks in advance Babu

4 years ago

.14600902Level 2

asked in AI

Machine Learning training course - Duplicate Checker does not deploy

Hi everyone, I am not able to deploy the duplicate checker prebuild model. I am currently doing the ML training course and the app does not start. The issue has been discovered last Friday (24.7.20). The screen looks like the picture below. I have provided permission to access the dataset and gave the app further permissions as a Data Engineer, but this did not solve my problem. I am able to deploy a Jupyter Notebook app. This seems to work fine. image1380282 6.1 KB What can I do to solve this issue? Kind Regards Simon

4 years ago

daniel.muellLevel 2

asked in Data Ingestion & Infrastructure

Data model is unloading itself

Hello celonis community, i discovered a strange behaviour in one of our data models. It seems to unload itself when im using some specific components. I found out it happens often when i use the alternative dimensions in the process explorer or variant explorer to filter the activities based on some attributes. Our Processes have a wide variety of activities per case. So often the view over everything is not the best way for a deeper sight into the process. So i just set a filter on the activities which are created from a specific ressource or something like this and want to display only these activities in the process explorer. But then suddenly the whole data model is unloaded and needs to be reloaded from source. Has someone the same issue or does someone know why this is happening? we are Using On-Premise 4.6

4 years ago

paul.perkuLevel 2

asked in Process Analysis

Convert String to formula

Hello, I have a data field which includes the conformance check formula. The formula is generated by a python code (We are using the OnPrem Version not IBC/EMS). Is it possible to take this data field to execute this formula in the analysis? Actually Celonis think it is a string and show the formula but not the result of the formula. Thank you in advance. KR Paul

4 years ago

.14600848Level 2

asked in Data Ingestion & Infrastructure

Pycelonis subfolder creation

Hello Team,Could you please guide on how to create subfolder structure as same as UAT in DEV using pycelonis and how to push all the analyses in each folder

4 years ago

katharina.tLevel 2

asked in Process Analysis

Calculate ratio of sales document where cancellation reason for items = 0

Hi there! I have a little problem here with a single KPI. What I have are two tables (Sales Document Header VBAK, Sales Document Item VBAP). Only the VBAP includes a column with cancellation reasons (which are always the same for one sales document). The offer is still open, if the cancellation reason is null. However, I dont know how to calculate the ratio of open offers, but only for the VBAK table/ VBAK.VBELN (just for the headers, not for every item). I could only create a OLAP table with the VBAK.VBELN and the cancellation reasons by clicking on distinct values in the advanced options. I tried different PU functions to join the tables and the filter ISNULL, but did not succeed Any help is highly appreciated. Thanks! Best regards

4 years ago

.1460018Level 2

asked in Process Analysis

Getting different average throughput times between components using same formula

Hi everyone, I am currently creating a P2P dashboard analyzing different times between activities. The dashboard includes a single number KPI component as well as column charts visualizing the different average throughput times between certain activities. Both the single number component and the column chart are calculated based on the following formula: AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Create Purchase Requisition] TO LAST_OCCURRENCE[Create Purchase Order], REMAP_TIMESTAMPS(Data_csv.EVENT TIME:TIMESTAMP, DAYS))) The only difference is that the column chart uses different company areas as dimensions (Data_csv"."CASE SPEND AREA TEXT) while the number component only uses the formula above. If I then select/ filter for one specific area in the column chart component, the number component updates but always shows a different number than the column chart. I dont understand why two components display different times if they are based on the same formula. I guess it must have som

4 years ago

matt.mattLevel 2

asked in Process Analysis

Filtering Graph on 2 KPI’s with Filters

Hi All, Im trying to implement a bar graph between two of the same KPIs but with different filters on them. Ive created the bar chart with both KPIs displaying by month, and then I added two dropdown buttons that select the plant/warehouse of interest. Both of these dropdown buttons values are then set to text variables I created. I want to now filter each KPI bar segment based on the button values. So the end result would be two bars for each month, with one bar being filtered on the first buttons value and the second bar being filtered on the second buttons value. Below is what I have now, just without the functionality of the filters to distinguish each bar. Any help is greatly appreciated. Thanks. image1811666 40.4 KB

4 years ago

.14600905Level 3

asked in Process Analysis

‘Search for Value’ Option in Dropdown Button

Hello Team, I have created two Dropdown buttons for my Dashboard. Cost type dropdown has limited number of values 10 to 12, Order number dropdown has large number of values (more than 200). In Cost type drop down, search option is appearing (highlighted in the attached screenshot) but in Order number dropdown there is no search option. Can you please tell me the reason for this. Thank You. Warm Regards, Jayanta

4 years ago

kavya.kadiy13Level 2

asked in Data Ingestion & Infrastructure

Add two results of PU SUM

Hi ,I need some help.I want to add two results from PU_SUM ( child_table, parent_table.column [, filter_expression] ).I wroteADD (PU_SUM ( child_table, parent_table.column [, filter_expression] ),PU_SUM ( child_table, parent_table.column [, filter_expression] ))orPU_SUM ( child_table, parent_table.column [, filter_expression] ) + PU_SUM ( child_table, parent_table.column [, filter_expression] )But there is a rule: If no value in the parent table exists for the element in the child table (either because all values of the parent table column are filtered out, or because no corresponding value exists in the first place), NULL will be returned.If the result of first of them = NULL, then the result from ADD is also NULL, although the 2nd result is <> NULL.But I would like to have the sum of both. How should I do that?

4 years ago

rita.kiss12Level 4

asked in Process Analysis

Table compiler not implemented - error message

I have 2 variables. TPT_Unit can be days, hours or minutes and the user can change / set the value via a button drop-down. TargetCT_Days is the target cycle time in days, inputted via a Variable input field. I would like to calculate the cycle time corresponding to the unit selected (and use it to calculate the difference between the actual CT and the target CT). However when I try a CASE WHEN statement I receive an error message Table compiler not implemented What am I doing wrong? Thank you for any pointers on how this can be achieved! 2020-07-23 18_12_19-Requisitions - Process Cockpit _ Process Analytics613770 9.64 KB

4 years ago

lingzhi.lingzLevel 2

asked in AI

FileNotFound when trying to read csv file using python

Where should I put the file so that I can using python to read csv file in machine learning?

4 years ago

soham.potdaLevel 3

asked in Data Ingestion & Infrastructure

Conformance | Whitelisted Violations

Hi Team,We are working on the process conformance module in Celonis. We are currently getting the details of a violation through the use of the conformance query in an OLAP table.However, we need to get the count of the whitelisted violations also exported to an OLAP table.When a violation is whitelisted it gets added as conforming activity and we are not able to differentiate a whitelisted violation from conforming activity.Is there a way in which I can obtain the count of the Violations and also the Whitelisted Violations in a component using some formula.Thanks in Advance

4 years ago

rahul.bhat11Level 3

asked in AI

Python:Database Type:unavailable

Hi team, I have been doing the auto-assignment of tables and DBconnection for the datamodel from python. But i am getting a problem in which the store type for a table is appearing as unavialable. This happens only some times when the datamodel is copied from some other server. But this completely removes the object of doing this in the first place. below is the screenshot. Any help would be appriciated. image722226 35.9 KB Edit: It should be as below image701141 39.7 KB

4 years ago

dayvson.nasciLevel 1

asked in AI

Error running ML suite examples fom ML workbench

Hello there, Im trying to use the notebooks from the examples_ml-suite folder, specifically the 04_root_cause_analysis.ipynb notebook, but Im facing the following error when running the cell: image1636228 38.8 KB image1359568 104 KB

4 years ago

stefan.grossLevel 3

asked in Process Analysis

Master Data Check eg. INC01 (EKKO.INCO1 vs. TINC.INCO1)

Dear all, I want to do some master data check. For certain fields check if they are used within 3 years (we have 3 year of data in Celonis). E.g. I want to mark all Incoterms from the master table (TINC) which are not used in EKKO.INCO1. First problem was the join of the mastertable. We did it via EKPO <-> T001 <-> TINC With case key SID, BUKRS and MANDT. Dont know if there is a better way. The idea was now to store the distinct values of EKKO.INC01 in a static variable like the following (there is no parent table between TINC & EKKO) static_var = distinct EKKO.INC01 CASE WHEN TINC.INCO1 in <%=static_var%> then USED ELSE NOT USED END Any ideas how to do this? Thanks in advance Stefan

4 years ago

luc.lucLevel 2

asked in Data Ingestion & Infrastructure

IBC: Parallel Processes Option

Im currently working on the implementation of the Celonis IBC at a client. The process were analyzing contains parallel process steps. In the old version of Celonis there was an option to indicate Child/Parent columns in the acitivity table (https://celonis.cloud/help/display/CIBC/Parallel+Processes), however I cant find this option in the IBC. Is this option already available somewhere in the IBC? If not when can we expect a release?

4 years ago

Page 105 / 122

Badge winners

matt.witty13has earned the badge People Person
Floboyohas earned the badge First Post
ardi.zulfahas earned the badge Qualified to Manage Implementation Projects
rose.guptahas earned the badge Qualified to Build Analyses
antoniojesus.garcihas earned the badge Celonis Technical Expert

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Celonaut Login Celonis ID Login

Login to the community

Login with SSO

Celonaut Login Celonis ID Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook