- - Knowledge base overview
Product Updates
Groups

Welcome to the Celonis Community

5 months ago

Home
Community
Product Q&A

Product Q&A

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

3105 Topics

Most replies

Most views

Newest first

soham.potdaLevel 3

asked in Data Ingestion & Infrastructure

Sum of Distinct values

Hi Team,I am working on pulling sum of values from a particular table column in Celonis using PQL. I want the sum of distinct values of the table column. However, when I do SUM(DISTINCT Table.Column) it is giving me sum of all the values in the column and not the unique ones.Is there any way in which I can find the sum of unique values of a table column?Thanks in advanceRegards,Soham Potdar

2 years ago

raul.salom12Level 2

posted in Process Improvement

hello, I would like to know where I can find the different licensing plans that Celonis has to know which one to acquire.

hello, I would like to know where I can find the different licensing plans that Celonis has to know which one to acquire. On the main page of Celonis I can not find that information. RegardsRaul

2 years ago

vasco.caron11Level 4

asked in General Product Q&A

Data Type Conversion in Extraction Table Joins

Good morning community, I'm trying to perform an extraction on a sizeable SAP table (AUSP) by linking it to another table (MCH1). These tables are linked through a field that is not quite the same on both tables. In AUSP, this field will be a value like '000000000000003641', whereas on MCH1 this value will be '3641' Since I don't know if I can use any formulas to add X amount of '0' characters (this would be using something like repeat character '0' 18-Length(3641) times), I want to convert '000000000000003641' to Integer. I have tried a number of variations of the following join: But I always get this error: Can anyone point me to what I'm doing wrong? Is Datatype Conversion perhaps not available for SAP ECC? Does anyone have any other ideas? This is the Celonis Documentation I am following Thank you in advance!!!

2 years ago

andres.naran12Level 4

asked in General Product Q&A

Hi folks! I know I can use a module to get data from a data model in an action flow, but can I get data from a component in analysis for example an OLAP table in an action flow?

2 years ago

emanuele.cardeLevel 3

asked in Data Ingestion & Infrastructure

Would it be possible to automatically download the CSV file from "Admins & Settings > Users" using pyCelonis?

The goal is to retrieve the 'Status' information to highlight the "Invited" users (fetching data using SCIM doesn't give this information).

2 years ago

anusuya.ponnuLevel 3

asked in General Product Q&A

How to order the options in Button dropdown using load entries

How can we arrange filter value in order in Button Dropdown using load entries? Options under button dropdown should be of order. - Committed Case- Violated Case- Others But the 'Others' option is listed 2nd as per alphabetical order. Code:CASE WHENPU_COUNT ("A", "B"."caseid" ) > 0THEN 'Committed Case'WHEN PU_COUNT ("A", "C"."_CASE_KEY", "C"."CHANGED_TO" IN ('In Progress') AND "C"."CHANGED_FROM" NOT IN ('New')) > 0THEN 'Violated Case'ELSE'Others'END Other than rephrasing the options and numbering the options, is there any default logic to order the options as we like.

2 years ago

andré.linkLevel 3

asked in General Product Q&A

I would like to save the third largest Count of Order Items per country as a variable

Dear Celopeers, I would like to save the third largest Count of Order Items per country as a variable.E.g.:DE - 7000EN - 12000IT - 9500...Variable: 7000I only have access to these functions: https://help.celonis.de/display/PQL47/PQL+Function+Library+-+CPM+4.7 Thank you in advance!

2 years ago

patrick.groth12Level 3

asked in General Product Q&A

Action Flow Timeout - Parallel Execution possible?

Hi everyone, we are currently running into the limitations of action flows. Namely runtime. Use-Case: We want to create 2000 PDF Reports from Analysis sheets and send them to different people. Creating one PDF Report takes aprox. 40 seconds. Therefore after only 80 reports, we already reached the runtime limit. Did someone already encounter this issue? Possible Solutions that I already had in mind:Skill to trigger parallel executions of that action flow (I don't think this works because I can't even execute an action flow while it is already running)Duplicate the action flow like 40 times (I don't think this can even be considered a solution) Thankfull for any help that someone might provide!Thanks in advance. Best regardsPatrick

2 years ago

luca.krajiLevel 2

asked in General Product Q&A

Is data stored in AWS or Azure? (There's one post that says its hosted in AWS and another that says its hosted in Azure)

100

2 years ago

sivashankari.chandrasekaranLevel 1

posted in Entry Products (Celonis Free Plan & TryCelonis)

I would like to understand how I can leverage Celonis for my Service Delivery Org and need some personalized statistics to demonstrate the same to my Business.

I would like to understand how I can leverage Celonis for my Service Delivery Org and need some personalized statistics to demonstrate the same to my Business. Which path should I follow?

2 years ago

ravi.kumar23Level 4

posted in Process Analysis

Hi Team,

Hi Team,"Celonis Governance Model "We have multiple tools in our organization for dashboarding.There is often a discussion to decide whether Celonis is the right fit for the requirement or not.Overlap is mainly with the POWER BI which is used for dashboarding. We also have Automation studio using RPA's etc.We are working on a decision matrix to decide which is a process mining use case and which one is not.Anyone has done that already or any inputs with this regard will be helpful.

213

2 years ago

carlos.lopez15Level 1

asked in Data Ingestion & Infrastructure

Test Connection Error

Hello everyone,Were trying to connect SAP ECC to CIBC. We have installed RFC and extractor but when we test, it says:Connection test failed, please check the Data Connections configuration and ensure that the system is running: Error during connection validation: OPEN DATASET - No OS Permission to open file /tmp/CELONIS/CEL_EX_If anyone can help usThanks!

140

2 years ago

anurag.jha13Level 2

asked in AI

API Request to using PyCelonis.

Hi,I am trying to send API Request using the api_request() function but i am getting this RetryError. Can anyone please explain how to tackle this error.

2 years ago

zeliha.otgözLevel 4

asked in General Product Q&A

when constructing an activty in data transformations, we use insert into, select, where, from. but how we will know we will put some joins in "where"? to sum up, how we can construct an activity?

2 years ago

bhasker.sathyLevel 3

asked in Data Ingestion & Infrastructure

Automate deletion of old data

Hi, Does Celonis have best practices on how to automate the deletion of old day (say data older than 1 year)? I understand that I can write my custom scripts with delete statements and execute them. However, given the underlying data model (that also has relationships) and timestamp definitions in each table, is there a way to leverage that and easily automate deletion of old data (ex : older than a year)? Thanks,Bhasker

2 years ago

amari.richaLevel 2

asked in General Product Q&A

Having issues completing leading steps to connect data import once data connection has succeeded.

Hello, I'm attempting to create a data connection via .xlsx file on my computer. I created a space and then made the data pool connection alias. However, once i select "Connect to Data Source" and successfully connect my data, it does not proceed to make the connection. Can you please help and or instruct me on the correct method to complete the next steps? (See images below) Once I selected Esc, the remains equivalent to image one, any help is greatly appreciated. Thanks!!

2 years ago

zeliha.otgözLevel 4

asked in General Product Q&A

How to change the activity order?

2 years ago

antoine.leducLevel 3

asked in General Product Q&A

Date format (timestamp) partially work

Hello, I have a excel database where there is a date column. I try to change the format of this column using this function :CAST( column_name AS timestamp) But it shows me a lot of empty value and its not supposed to... For some raws its working but not all of themDo you have an idea ?

2 years ago

patricia.braga12Level 2

asked in Process Analysis

Have Smart sensors been removed from the skill asset?

I'm trying to create anew skill using the documentation, but it looks like smart sensors are no longer available.What's now the alternative? Where can we find documentation on this topic? Thank you

2 years ago

rahul.bhat11Level 3

asked in AI

Connection to pycelonis after 2.0 upgrade

Hi,I am trying to connect to pycelonis from my local system to IBC .It was possible with all the required values when it was 1.7.4But after the upgrade to 2.0 , we are getting a getaddrinfo errorIs anyone else facing such an issue?If so, What needs to be done.Let me knowThanks

120

2 years ago

melissa.bolkeLevel 1

asked in Process Analysis

How can I make a PQL filter/ statement to show the results once with the newest date?

Hi everyone, I want to add a PQL filter/ statement to my dashboard. I have an OLAP table with the results of multiple IBAN checks that runs every day (so the results are double, but with different dates). I want to add a filter to show the results only once with the newest date.

2 years ago

raman.silot14Level 4

asked in Process Analysis

Can I store profile view selection in variable ?

Hy guys,Is it possible to store whichever ID I select in profile view in a variable, if yes then which variable I should use runtime or view ?

2 years ago

federico.sparaLevel 3

asked in General Product Q&A

Value in variable different from same value in analysis

In the analysis I've a kpi related to a 90th quantile that displays a value = 19.01, some filters are applied. Without any filter, the value is 19.49. Since I need to compare every instance in a table with that value, I stored it in a static value variable, that for some reasons shows the value 18.70. Another strange thing is that if I enter the code editor of the variable, the value displayed is 19.49, so coherent with the not filtered one in the analysis. Why it show me 18.70 outside the editor? And how I can apply the same filters on the variable in order to show the correct value of 19.01? (using case when condition met then compute quantile does not work, since there is the aggregation function error). Thanks!

2 years ago

victor.pLevel 2

asked in Process Analysis

How to use variables both in Views and in KM?

Hi everyone, I am having troubles with variables in Views - both view variables and runtime.I want to set a target days and on change the value to be written to both ${target_ct_days} and ${{target_ct_days_runtime}} so that when I change target days, the bar chart to change simultaneously together with any KPIs which use the runtime variable. This is the YAML code for the input box. -If I have only ${target_ct_days} to be changed, the graphs are being changed accordingly. -But if I have both variables, graphs do not change, only the runtime variable: type: input-boxsettings: styles: position: horizontal: full vertical: top name: "" value: "" placeholderText: Enter Target CT days type: number onChange: update: variables: - name: target_ct_days - name: target_ct_days_runtime I would be thankful if someone advice me what should I do to update both variables so that graphs and KPIs change simultaneously. Thank you in advance!

2 years ago

zeliha.otgözLevel 4

asked in General Product Q&A

What does pink dots represent in Process explorer when we press icon- play button?Is it a case?

2 years ago

Page 53 / 125

Badge winners

karim.abdelhas earned the badge Qualified to Identify and Drive Opportunities
patrick.gruenhas earned the badge Qualified to Build Analyses
elena.mariahas earned the badge Qualified to Deliver Business Value with Celonis
kenji.mitsu11has earned the badge Qualified to Get Data Into Celonis
niels.holzhas earned the badge Solution Creation Expert