- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month 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,416 Topics
3,354 Replies

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

1416 Topics

Most replies

Most views

Newest first

marco.ciacc12Level 1

asked in General Product Q&A

We created an OLAP table which KPIs are calculated through pu_function (it is the only way to ensure analysis correctness). If we filter the sheet with a "date picker" , KPIs have values not coherent between themselves.

It seems that date picker filter is not applicated in the same way for:the KPI in the high side of the sheet (Sales Order Items value and Number)the KPI in the table that shows year by year Sales Order Items value and Numberthe values (Sales Order Items value and Number) for a specific customer if we add also this filterBecause for some customers each of them shows different values ..

3 years ago

.14600906Level 3

asked in General Product Q&A

Flat file (Excel) upload fail because of Null values

Hi,We have Excel files with few columns are always/sometimes blank. When we try to upload the excel, Celonis automatically identify and select the datatype for each column based on the first x records . Even though column has null values Celonis considered them as INT and then during the data model load this gets failed. We have many columns and manually checking data type for each column is very time taking. Is there any solution to this?

3 years ago

.14600906Level 3

asked in General Product Q&A

Using CASE WHEN in component filter does'nt work

Hi, I am trying to filter the data using CASE WHEN statement in the component filter section but it is not working.Scenario: when DATE_1 is not NULL then show data only till yesterday using DATE_1 (DATE_1 < TODAY()) else show data till yesterday using DATE_2 (DATE_2 < TODAY()). This works file if I execute single statement like FILTER DATE_1 < TODAY() but it is not working when I combine into CASE WHEN like below: FILTER CASE WHEN ISNULL(DATE_1)=0 THEN DATE_1 < TODAY() ELSE DATE_2 < TODAY(); Any help is really appreciated. Note: We are using Celonis on-prem 4.5

3 years ago

shayan.sarka11Level 2

asked in General Product Q&A

How do you add comments to activities in process model?

Can we add comments against activities to cite the reason as to why the activity occurred? If so how to do it?

3 years ago

dennis.albreLevel 2

asked in General Product Q&A

Migrate analysis from CPM > 4.5 to IBC

Hi everyone, we have a lot of use cases and dashboards created on our CPM that we updated to 4.6 and we want to migrate our analysis from CPM to the IBC. Before the update from 4.5 to 4.6 we used a python script with pycelonis to transfer the analysis. After the update the script is not working anymore. Is there a specific adjustment to the script or is there any other way to transfer the analysis?

3 years ago

abdul.mabudLevel 1

asked in General Product Q&A

PU_LAST filter condition with Max function

Hi Guys,we wanted to use PU_LAST filter condition with Max function, can you help here.

3 years ago

vamshi.kuchuLevel 3

asked in General Product Q&A

Data-model is not working for task mining. The activity log is appearing in Data models, but the same is not

Data-model is not working for task mining. The activity log is appearing in Data models, but when I create analysis based out of data model, I am getting 'No Process is Configured'. Anyone, Any thoughts?

3 years ago

tomoki.tsuneLevel 3

asked in General Product Q&A

How can I designate multiple tables as Activity Table?

HI, I have embarked on learning the usage of MERGE_EVENTLOG in Celonis Snap environment. I cannot set two tables as Activity Table at the same time, making it unable to go further investigation.How could you set several tables as Activity Table (and Case Table as well) at the same time?

3 years ago

charles.picotLevel 2

asked in General Product Q&A

Hi, I would like to know what I have to put on the "realm" box when installing a connector from the EMS to connect to an APP. Thanks

3 years ago

.14600775Level 4

asked in General Product Q&A

Hi Community, I would like to align my text vertically. Is there a way to do this in the BB code function. I am using Celonis 4.5Thanks,Anna

Hi Community, I would like to align my text vertically. Is there a way to do this in the BB code function. I am using Celonis 4.5 Thanks, Anna

3 years ago

harsh.panch12Level 1

posted in General Product Q&A

Hi All,

Hi All, While working with multiple systems and Vertical Scenario (where different steps of a process are tracked in different source systems), do we have any documentation/ best practices on how to set up a data model? The training covers the Horizontal scenario in detail but I couldn't find any material for the Vertical scenario. Any tips/suggestions would be helpful!!

3 years ago

orlando.reis11Level 1

asked in General Product Q&A

Hi everyone,I would like to know if there are connectors ready to extract data from the Oracle HCM platform. We´re planning to use EMS to map and analyze personnel moves through positions, including transferences, promotions, demotions, etc.Thanks.

Hi everyone, I would like to know if there are connectors ready to extract data from the Oracle HCM platform. We´re planning to use EMS to map and analyze personnel moves through positions, including transferences, promotions, demotions, etc. Thanks.

3 years ago

philip.fredeLevel 1

posted in General Product Q&A

[Salesforce Extractor - Pseudonymization] Hi guys, assuming that the SFDC extractor is within the celonis cloud, it seems to us that non-pseudonymized data is at least for some period of time brought to the celonis cloud before it gets hashed. If this understanding is correct, would you know for how long would that be storaged (is the non-pseudonymized deleted at some point?) and how can we make sure that this information could not be accessed at all at anytime? Thanks a lot

3 years ago

cristóbal.muñozLevel 1

posted in General Product Q&A

Hi.

Hi. I'm starting with Celonis and I was wondering if any of you guys have any suggestions of filters in AP, Cash Discounts that can show the customer the discounts for early payments that he is missing.

3 years ago

alberto.genov11Level 2

posted in General Product Q&A

Where I can find Celonis installation document? What's the servers architecture to setup for an on premise installation?

3 years ago

Page 57 / 57

Badge winners

zachary.flynn12has earned the badge Qualified to Write PQL Queries
zachary.flynn12has earned the badge Qualified to Build Analyses
Nkosiyamntuhas earned the badge First Post
gaurav.shekh12has earned the badge Celonis Certified Data Analyst
nikhil.gauta11has 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