- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months ago

Home
Community
Product Q&A
General Product Q&A

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

1,425 Topics
3,374 Replies

When you subscribe we will email you when there is a new topic in this category

1425 Topics

Most replies

Most views

Newest first

kandi.naiduLevel 4

asked in General Product Q&A

Hi Team,I am trying to export my data from datamodel to dataframe in the ML Workbench.

I'm getting this PyCelonisPermissionError. Even though I provided all permissions to user key Please find the attachment,

11 months ago

kandi.naiduLevel 4

asked in General Product Q&A

Hi Team, Anybody have any idea about how to use uptrend and downtrend with other kpi in Knowledge model

I am sharing an attachment for reference . Thanks, Kandi Ajith Naidu.

11 months ago

emre.karadLevel 2

asked in General Product Q&A

Hello everyone, I am trying to count distinct number of shipment ids from ShipmentTable and i want to count only the ones occured in 2023. Celonis doesnt allow me to use count distinct in case when function.How can i write it,thanks a lot

11 months ago

julia.bauerLevel 5

asked in General Product Q&A

EBAN Data Model - Set Up Error

Hello everyone, I'm trying to set up a new DM as the P2P Data model (with join EKPO and EBAN) only makes requisition numbers visible that were already converted into an order. With a separate DM I only want to see the requisition numbers that are open and not processed yet (with some other filters from other tables). Does anyone of you already set up such a data model? I'm currently getting this error message and I have already all the keys that should provide distinct data rows. Thanks so much! BR Julia Bauer

11 months ago

manuel.wetzeLevel 4

asked in General Product Q&A

How do I activate/deactivate Dark Mode for SQL windows?

In the Windows under Data Integration where I write SQL Code for Transformations I sometimes have dark mode (white font on black background) and sometimes the other way around. It seems this changed from time to time and from environment to environment.Where can I set this? How is this being influenced? Obviously being a developer I want dark mode all the time 😁

11 months ago

joyce.cardo12Level 4

asked in General Product Q&A

Action flow sending several emails, I need to consolidate everything in one table.

Hi group! I am working on an action flow that will send a table with some information, the action flow is looking good, but it is sending separated emails, I need the full information in one table, being sent one time. The source is pointing to the query data, so not sure why is doing that..

11 months ago

vinod.kumar.ummadLevel 2

asked in General Product Q&A

I have 5 sheets in Analysis.When I select the dropdown value from sheet1 the data is getting filtered in all the 5 sheets.Instead of that how to apply the dropdown filter applicable to only the sheet1

11 months ago

.146003813Level 2

asked in General Product Q&A

How can I sort the KPI in a Pivot table in an Ascending or Descending order?

11 months ago

thumu.srava11Level 1

asked in General Product Q&A

How many cases are covered by the five most common variants.A.734,890B.404,562C.988,000

How many cases are covered by the five most common variants. A. 734,890 B. 404,562 C. 988,000

11 months ago

hector.torreLevel 2

asked in General Product Q&A

The dynamic filters from throughput time are currently non-functional.

We used to the default throughput time template, and when attempting to filter based on a specific distribution range, the filter fails, causing the distribution to revert to its initial state.

11 months ago

hector.torreLevel 2

asked in General Product Q&A

How to join multiple columns?

Hello community, nice to greet you. In my project the need arose to join several columns into one. In addition I need to create a calculated field that adds the amounts that match the same description in different column, i.e. I need to add the 1223 that belong to "incomplete documentation" in the first column plus the 854 that belong to "incomplete documentation" in the second column. I have tried to make a distinct function but it does not work. Have any of you had a similar case? I hope you can help me, if more details are needed I will be happy to help.

11 months ago

tushar.kondeLevel 3

asked in General Product Q&A

Hi all, is there an option to also create pop-ups when a viewer is moving with the mouse over a field or analysis? E. g. there is a button in the analysis that shows a KPI and when I am putting my mouse over the field there will show up the explanation how the KPI is calculated. I only no the functionality to create message buttons but this makes it confusing. Thanks.

11 months ago

kailash.potha12Level 5

asked in General Product Q&A

Is it possible to carry the filters from one view to another view which are created on top of different knowledge models

11 months ago

nagarani.tssLevel 1

asked in General Product Q&A

I have a query on views part were I am working on a table, I have already differentiate the column based on the color similarly I want respective values from the other column should come in the same color using custom objects?

Hi all,I am sharing the relevant screenshots for the reference.The below YAML cade is written for predicted type column. Similarly for the relevant data on the other column Date I want the same color. How we can achieve this?

11 months ago

joos.buijsLevel 6

asked in General Product Q&A

Until which version is pyCelonis compatible with Celonis 4.7 on premise?

We are currently migrating from Celonis 4.7 on premise to the cloud EMS. I have certain 'old' pyCelonis scripts that I would like to run against our local Celonis instance. I'm currently using pyCelonis 1.2.8, which is of course greatly outdated and which I would like to upgrade. However, as of 1.6.0 (where the docs start) I don't see any mentioning of connecting to an on premise instance. Before I start to trial-and-error update, I hope someone here would be able to help me pinpoint to which version I can update without issues. Does anyone have any experience with this???

11 months ago

omar.elmouLevel 3

asked in General Product Q&A

Dear Celomates,I would like to add the rework rate as a KPI without using PQL.

I have added an OLAP table with three columns where the Count of activities is compared to the Distinctcount activity for each case key. Please find attached the OLAP table. Besides the OLAP table i would like to show the rework rate as one number by referring to the formula and outcomes of the OLAP table. How can i add a number (without using PQL) where the ration of cases with a YES", as displayed in the OLAP table, is returned as one percentage. Many thanks!

11 months ago

andres.naran12Level 4

asked in General Product Q&A

Hi everyone, I'm trying to send a .xlsx file from sharepoint to machine learning workbench.

Unfortunately, we couldn't find any documentation that explains how to send the data from a .xlsx file into a param in the HTTP module, the documentation that Celonis provides only explains how to push data for a CSV file into the datapool directly. In our case, we want to send the data of the .xlsx file to Machine Learning workbench to create a table that we can send to the data pool, but we don't know how to include the data of this file into the params in the request content from the HTTP Module. Does anyone know how to do that?

11 months ago

ravi.kumar23Level 4

asked in General Product Q&A

Celonis Task Mining - Effectiveness and Use Cases

Hi All,We have few use cases where we want to do task mining quickly and show results.What all use cases you have used Celonis task mining are there other better tools to do it

11 months ago

naveen.arumuLevel 1

asked in General Product Q&A

How can i combine two n-relational tables to get all the data at the analysis dashboard level?

I have two log tables, Tables A and B, that are in n-type connection with my main table (the Case table), i.e., the Case table is 1: n type relation with Table A, and the same with Table B. As log tables, Table A and Table B record certain activity, whereas Table B records others. I need to identify activities that are repeated by merging the data from Tables A and B at the process analysis level. Requesting advice

11 months ago

ishiduka.misaLevel 3

asked in General Product Q&A

Action Flow Errer[ModuleTimeoutError]

Hello.I'm Ishizuka. How and where can I modify it to avoid module timeout errors? What is the cause? My guess is that the error occurred because there was so much data extracted in the "SELECT" statement of the query that it almost exceeded the one minute limit.---------------------------------------Error SummaryError details (example)

11 months ago

julia.bauerLevel 5

asked in General Product Q&A

Webhook for DataPush API - Error: Internal error while converting the CSV file to parquet.

Hello everyone, I have set up an AF that sends data to our purchasers and also sends the data via a HTTP module to a Webhook: About 6.5k data rows will be submitted in the queue of the webhook AF and will be pushed to a table in the data pool every 2 minutes (300 data rows per execution). At the end of the run of the AF, the table in the data pool does not contain the same amount of data than the data (deviation to 6.5k). Hence, I was guessing that some execution did not work correctly. When looking at the executions, this was confirmed - some executions have this error message: I tried filtering these executions by adding the BREAK module (with Filter for status code 400 - to stop the execution and store it in incomplete execution) but this does not the desired thing I wanted it to do. Did somebody else have the same issues? Thank you! Best regards,Julia Bauer

11 months ago

joyce.cardo12Level 4

asked in General Product Q&A

Hi group! I am trying to create an AF that sends out an excel file with the informtaion. I followed all steps in https://docs.celonis.com/en/send-excel-file-via-mail.html, however there are two stoppers that I am trying to solve...

1- The AF is running quite ok, but the email is being sent a lot of times, I need to send it out just one time, not sure what is causing it. 2- I need the price to be reflected in USD currency, but when the sheet is being filled, the currency is being set to euros. Can anyone advise? thanks a lot

11 months ago

hector.torreLevel 2

asked in General Product Q&A

How could be replaced the NULL values in an OLAP Table?

In the latest project, an OLAP table was employed, featuring distinct attributes for each individual case. Certain attributes are not universally applicable across all cases. We know that Celonis automatically inserts "-" in null values; however, we aim to modify this default value to "no information." Despite attempts using functions such as coalescence, case when is null, case when isnull(), none of these methods have proven successful. Could you kindly suggest an alternative approach? If additional details are required, please feel free to request them. Thank you for your assistance.

11 months ago

julia.bauerLevel 5

asked in General Product Q&A

DM-Error: The export failed: There is no column on the table to export for schema

Hello everyone, in the data model purchase requistions, I want to add the EINE to this snowflake (with join with EKPO). However, when setting up the join with the needed keys the DM does not load with following error message - what does this mean? Thanks for your help! BRJulia Bauer

11 months ago

christian.lemmeLevel 1

asked in General Product Q&A

Why is twice source / target not possible?

I have calculated two KPIs. Both work and give me a result per each case. Both calculations use the source / target function and they calculate for different status the total time. When I try to substract or add the KPIs i get the following error message. I can't even use them in a chart when using the average of both. Why? ERROR MESSAGE:No common table could be found. The tables [<Temporary table: SOURCE/TARGET configuration _CEL_SF_ACTIVITIES,REMAP_VALUES ( "_CEL_SF_ACTIVITIES"."ACTIVITY_EN" , [ 'Set Status to Information Received - Email' , 'Set Status to Information Received - Email' ] , [ 'Set Status to Awaiting Customer Information' , 'Set Status to Awaiting Customer Information' ] , NULL ),ANY_OCCURRENCE [ ] TO ANY_OCCURRENCE [ ]>] and [<Temporary table: SOURCE/TARGET configuration _CEL_SF_ACTIVITIES,REMAP_VALUES ( "_CEL_SF_ACTIVITIES"."ACTIVITY_EN" , [ 'Set Status to In Progress' , &#39

11 months ago

Page 14 / 57

Badge winners

bruno.carva11has earned the badge Qualified to Build Action Flows
bruno.carva11has earned the badge Qualified to Build Views
bruno.carva11has earned the badge Qualified to Build Analyses
rohit.shukl12has earned the badge Solution Creation Expert
charlie.rigbyhas earned the badge Qualified to Write PQL Queries

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