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

nils.höhlLevel 2

asked in Process Analysis

Reduce the number of shown labels in the dimension axis

Hello everyone, Im currently working on an analysis for viewers which is going to be exported as image, a stacked area chart in the date range of a year. Now to my problem: Their requirement is that every workday has to be shown in the diagram, so the dimension axis gets unreadable because of the amount of dates displayed: (part of the diagram with the date range of half a year as example) Is there any way to only display every second or third label on the dimension axis so it looks less cluttered and more readable? Ive looked through the component options but couldnt find anything related exept the tick count, but that doesnt help me for this case. Best regards, Nils

4 years ago

daniel.diers12Level 3

asked in Process Analysis

Count Cases which are just in one table

Hey all, I want to count cases where an article number is just present in one table but not in the other example TableV1 ArtNr 1 3 4 5 7 9 TableV2 1 2 3 4 5 6 7 8 9 10 Count cases which are in TableV2 but not in TableV1 (Null). In that case 2, 6, 8, 10 -> Count = 4 Thx and br Daniel

4 years ago

daniel.diers12Level 3

asked in Process Analysis

Change table name with variable

Hey pros, I want to upload lots of table with the same columns, like article number and price. To select which version/table should be analysed I want to setup a variable with the name of the table. Example: Currently COUNT(DISTINCT SupplierA_v10.csv.Teilenummer des Lieferanten) Should be something like that COUNT(DISTINCT " || <%= Name_Update %> || .csv".Teilenummer des Lieferanten) Do you have any ideas how to set this up? Many thanks ahead and br Daniel

4 years ago

praveen.kumar47Level 1

asked in Data Ingestion & Infrastructure

Rounding Time Unit based on Custom date slice

Hi ,I would like to know if there are any provision to consolidate the date for the specific date slice to use in the dimensions . For Eg 5 days or 3 days custom grouping etc .I require the functionality similar to ROUND_WEEK() to group date but i should be able to group based on the custom logic of 5 days or 3 days etc for the date range .Thanks ,Praveen

4 years ago

soham.potdaLevel 3

asked in Data Ingestion & Infrastructure

ML Workbench Data Pull

Hi Team,In the ML workbench, we are trying to pull data of a component from a particular analysisThe code that we are using is not able to pull data from some particular analysis. However, if we use the same code to pull the data from a different analysis belonging to the same workspace we are able to pull the data.Are there any Analysis settings that we need to look into for the data pull that might be causing this error.We are getting the following error while pulling the data from the analysis.image571669 70.7 KB

4 years ago

masha.galitLevel 3

asked in Process Analysis

Understand the pie chart

Hi, I am trying to build a simple pie chart and am a bit puzzled by the results. As dimension I added the following statement: CASE WHEN VBAK.BSARK = DFUE THEN EDI ELSE NON-EDI END And as KPI: COUNT_TABLE(VBAK) So, I want to see a pie chart that will be divided into two parts based on the value in the field BSARK: part 1 - DFUE part 2 - anything else But for some reason the pie chart also has a 3rd part which has - value. How shall I understand it? thanks a lot for any advise

4 years ago

joão.francLevel 3

asked in AI

Partial load API - Can’t connect to celonis

In the sandbox, environment following the notebooks, when I run: "from pycelonis import get_celonis celonis = get_celonis()" it tells me i dont have permissions: "WARNING:pycelonis:The IBC did not accept the credentials: " I have given the application key all permissions in the team settings and in the event collection. What am i doing wrong?

4 years ago

Anonymous

asked in AI

Pycelonis get_data_frame method failed when column name is like “#{VBAP.PSTYV}”

Dear Celonis development team, I tried to connect and extract data from IBC to my Colaboratory python environment using Pyceonis. Normally it worked correctly with below scripts. from pycelonis import get_celonis login = {celonis_url: my_url, api_token: my_token} celonis = get_celonis(**login) analysis = celonis.analyses.find('id of my analysis) sheet = analysis.published.sheets.find(id of my sheet) component = sheet.components.find(id of my component) df = component.get_data_frame() But sometimes get_data_frame method returned exception. Exception Traceback (most recent call last) in () ----> 1 df = component.get_data_frame() 2 df 2 frames /usr/local/lib/python3.6/dist-packages/pycelonis/objects_base.py in get_data_file(self, pql_query, file_path, export_type, variables) 647 648 if r[exportStatus] != DONE: > 649 raise Exception(f"Export failed. Status: {r} \\n\\n Query: {pql_query}") 650 else: 651

4 years ago

.14600940Level 2

asked in Data Ingestion & Infrastructure

Connect 1 table to 2 different tables

How can I connect 1 table( that connects all recored time) to two different tables? We have a ServiceNow Timecard table which stores all worked time on a task. But time can be spend on a request record as well as the underlying request task record. Im intressted to know how much time is spend for an request (taking time worked into account for the request record as well as the task record for the request) image1199680 43.2 KB The error i receive is: Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Cycle in table joins detected. Cycle is within these tables: [sc_req_item, sc_task, time_card]. Celonis Support ID: ecb1aec8-c71d-42e8-bd91-41927de8ac51 It looks like Celonis is supporting a multiple table connection (I can make 2 different key relationships). Is this correct?

4 years ago

rita.kiss12Level 4

asked in Process Analysis

Count activity through the whole process

The ACTIVATION_COUNT operator returns for every activity in every case, how many times, at a given point in a process this activity has already occurred. Is there a similar function that counts how many times the activity occurred for every case? 2020-09-01 14_46_43-11 AP First Time Right _ Process Analytics780228 5.03 KB 2020-09-01 14_46_35-11 AP First Time Right _ Process Analytics803138 2.45 KB E.g. in this case, I used ACTIVATION_COUNT for the repetitions. Now the #2 is actually the total number of cases, as it means 2x at this point but it might be more. Is there a way to show when the activity happened exactly 2x (so exclude 3x, 4x, etc.) Thanks!

4 years ago

.14600836Level 3

asked in Process Analysis

Date Picker based on PO Line Item creation date

Hi all, in our P2P analysis we used to filter based on PO Header creation date (EKKO.AEDAT). However, it would be more precise to filter based on PO Line Item creation date. Looking in our SAP table for PO Line Items (EKPO), the date which is available in EKPO is always the last update date (which is not necessarily the line item creation date, in case there are changes in the PO line item after the creation). Thus, we have to also look at the CDPOS and CDHDR tables in SAP to see what kind of change have been done for the PO line item (> Insert = PO line item creation date; Update = change date after PO line item creation date). As we are not having CDPOS and CDHDR tables in our P2P data model, we are now using a date picker with the formula _CEL_P2P_ACTIVITIES.EVENTTIME. However, by doing so we would need to add component filters or an Analysis script in order to consider only the activity Create Purchase Order Item for the event time (FILTER _CEL_P2P_ACTIVITIES.ACTIVITY_EN = Creat

4 years ago

.14600830Level 2

asked in Process Analysis

Throughput Time from a Crop Selection

I want that, when filtering a process using the Crop Selection, that the Throughput Time displayed for a Case is calculated considering the first to the last filtered Activity. I tried to do this using the Standard Components, and realized that it calculates the Throughput Time of the whole Process and not just the filtered segment. How do I set this up?

4 years ago

.14600933Level 2

asked in Process Analysis

Referencing minimum value of calculated KPI

Hello, I am trying to refer to a minimum value of a calculated KPI and calculate another KPI. In this case I am looking at minimum cost and calculating Potential savings. Is there a way to do this? the min function only works on columns as far as i know

4 years ago

dom.tLevel 2

asked in Data Ingestion & Infrastructure

CASE WHEN for multiple conditions

Hi team,i am trying to write a CASE WHEN statement for a process explorer to show only the activities that satisfy a dropdown filter based on multiple selections.Sample dataset:(Case ID, Activity, Source,)Case1, Activity 1, Screen1,Case1, Activity 2, Screen1,Case1, Activity 3, Screen2,Case2, Activity 2, Screen1,Case2, Activity 4, Screen1,Case1, Activity 5, Screen3I would like to be able to filter in a custom process explorer the activities only from a particular screen (e.g. filter dropdown: Screen1 and Screen 3> only Activities 1, 2, 4 and 5 are shown on the process explorer).My current query doesnt allow me to select multiple conditions, and doesnt work with the IN function as well:CASE WHEN BOOKS_USER_05JUN.SOURCE LIKE <%=Source_Process%> THEN BOOKS_USER_05JUN.ACTIVITY ELSE NULL ENDBest,Dominic

4 years ago

.14600841Level 2

asked in Data Ingestion & Infrastructure

Touchless Sales Order Item count

Hi Team,I am trying to calculate the touchless order where have defined in dimension1)COUNT_TABLE(VBAP)in KPI section have defined SUM(CASEWHEN (PU_COUNT(VBAP,"_CEL_O2C_ACTIVITIES".USER_TYPE,"_CEL_O2C_ACTIVITIES".USER_TYPE IN (<%= AutoTypes %>)AND _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (<%=AutomationActivities%>))= PU_COUNT(VBAP,"_CEL_O2C_ACTIVITIES".USER_TYPE, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (<%=AutomationActivities%>)))THEN 1.0ELSE 0.0where AutomationActivities and AutoTypes defined in varibaleAutoTypes has only A which is manual so ideally i want count of records which are manually done and will be calculating touchless based upon the below logictotal number of SO item-(KPI logic- count of manual orders)But am not able to get the count , could you please check and help me on the same.

4 years ago

eike.wellmLevel 2

asked in AI

TypeError: astype() got an unexpected keyword argument ‘skipna’

Hi there, while pushing a dataframe into a datamodel i got the above mentioned error. By checking the parquet_utils.py and a quick research I found out that this (skipna) argument is obsolete and no longer supported. Iam using python 3.7.6, panas 1.0.1 and pycelonis 1.2.8 Is there a workaround for this issue? Best regards, Eike

4 years ago

.14600775Level 4

asked in Data Ingestion & Infrastructure

Static Variables

Hi All,I would like to use a static variable for a % calculation, so that when filters are applied, the denominator will stay static. The issue that i am facing is that i would like the static variable to be static based on the local market and not the sum for all local markets.Such as below:Please let me know if this is possible using the static variable, and if not, please advise if there is another way i can achieve this.All the best,Anna

4 years ago

daphne.van.lLevel 1

asked in Data Ingestion & Infrastructure

Export analysis via PyCelonis with CPM4.4

I have a question regarding the usage of PyCelonis for a single user account with Celonis 4.4. In the documentation it says that PyCelonis allows for a connection with the IBC and CPM4.5.Are there other options for the single user license to extract the analysis details in python?

4 years ago

.14600952Level 2

asked in Process Analysis

Vendor Master Data Analysis

Hi everyone! I would like to build an analysis focused on the vendor master data I would like to show the vendors who are NOT flagged for deletion but at the same time had NO activity in the last 24 months (no invoices) Any ideas how to pt together this data? Thank you very much Tatiana

4 years ago

soham.potdaLevel 3

asked in Data Ingestion & Infrastructure

Count if the instances of Activity A are followed by other activity within a particular scope

Hi Team, We are trying to identify and associate flag to a particular activity based on whether there were some other set of activities post it or not till the next instance of the activity. So for example we want to associate a flag to Activity A if in a case journey activity B, C, D or E are occuring any time between the next occurence of Activity A within the case. We intend to track this for each instance of activity A taking place within a case and associate a flag whether the activities B,C, D or E took place or not in an OLAP table. We are looking for any way in which we can set the scope from the instance of activity A taking place till its next instance and check within this scope whether the other activities took place. Thanks in Advance. Soham Potdar

4 years ago

vamshi.kuchuLevel 3

asked in Process Analysis

First timer to Celonis - COUNT_TABLE

Hi Celonis experts, I am trying to understand what columns are picked up from a table when i do a Count_table(EBAN). When i tried doing, COUNT_TABLE(EBAN) results are 22531. However, when i try to achieve the same with any column in EBAN table, the values are not matching. Thanks in Advance!

4 years ago

holger.meissLevel 2

asked in Data Ingestion & Infrastructure

Strange Results in Ratio KPI

Hello,ive the following issue:The PQL Formula Ratio of Cases flowing through a dedicated activity is used to determine the % of cases that do contain activity Remove Delivery Block. Putting this formula into a number element - works fine. Shows 20%.The same 20% appears when the activity Remove Delivery Block is marked in the process explorer.In my example i have 340 cases, where 68 do have Remove Delivery Block.The 340 cases to have 4389 activities in total, the 68 cases having the acitvity Remove Delivery Block do have 1229 activities.If the KPI Ratio is put into an OLAP Table and shown with dimensions like Company or Sales Org the Ratio moves from 20% to 28%. I figured out that the formula is changing from a case % (68 out of 340) to an activity related calculation (1229 out of 4389) - this does always happen if any characteristic that is joined to the activity table is shown in the OLAP Table.In addition - the same applies - the other way around if sum(vbap.net_order_value) is takin

4 years ago

.14600905Level 3

asked in Process Analysis

Size of Beads in Simulation while moving from one Activity Node to another

Hello Team, I have query and have attached a picture of it in this Topic. While running simulation, I have observed that the beads move from one activity to another but have different sizes. Can you please tell me what does the different sizes of the beads technically/functionally mean(image attached). I was assuming that the size of the beads should be uniform as it indicates individual cases. Please correct me if Im wrong.Thank You. Warm Regards, Jayanta

4 years ago

raghu.raghu12Level 2

asked in Process Analysis

Exporting Workspace analysis to PDF or PPT format

Hi Team, I am new to this Celonis, i have a doubt like can we export the workspace analysis which we created in Process analytics to PDF or PPT format. can anyone please clarify my question. Thanks in advance. Regards, Raghu

4 years ago

.14600839Level 2

asked in Process Analysis

Boxplot filter is correct?

Hi,everyone, I created an analysis using boxplot, but the filter didnt work well. PQL statement Column chart DimensionHOURS(PU_FIRST(casetable,activityTable.EVENTTIME)) KPICase Count TPTAvg. AVG(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(activityTable.EVENTTIME, MINUTES))) Boxplot Distribution AxisCALC_THROUGHPUT(FIRST_OCCURRENCE[<%= From %>] TO FIRST_OCCURRENCE[<%= To %>], REMAP_TIMESTAMPS(activityTable.EVENTTIME, MINUTES)) From,To Activity name Dimension AxisHOURS(PU_FIRST(casetable,activityTable.EVENTTIME)) image20641236 131 KB If I selected 11 on the column chart, I assumed that the boxplot also shows 11. However, it is displayed 0.Same for other values image20631246 136 KB Is it IBCs specification? Or something wrong with my PQL statement? Best regards, Marie

4 years ago

Page 108 / 122

Badge winners

emil.gospohas earned the badge Qualified to Build Analyses
kevin.wellshas earned the badge Qualified to Manage Implementation Projects
dan.morrihas earned the badge Qualified to Manage Change and Scale Adoption
susana.moren11has earned the badge Celonis Certified Data Analyst
ardi.zulfahas earned the badge Value Assessment 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