- - 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,424 Topics
3,366 Replies

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

1424 Topics

Most replies

Most views

Newest first

ugurcan.aydem13Level 3

asked in General Product Q&A

Scheduling Studio Skills

Hello everyone, I wonder that when I create a skill with Manual Sensor, can i schedule trigger of this skill ? For example I want to trigger this skill once in a month automatically . If I can't is there any differenw way to do that Thank you

3 years ago

zeynep.dirik12Level 2

asked in General Product Q&A

Is it possible to use SQL Procedure in data transformations? If not, is it on the roadmap? Thanks!

3 years ago

Anonymous

asked in General Product Q&A

ServiceNow Connector for IT Service Management - Incident Management - Data model load failed

Hello.I'm currently testing the ServiceNow Connector for IT Service Management - Incident Management. Unfortunately, the model cannot be loaded: Data model load failed during table export: Data model tables: _CEL_INC_ACTIVITIES, sys_user_group, BACKLOG, incident contain more rows than the allowed maximum per table of 0. Please reduce the number of rows. The data jobs ran errorless.Any idea what is wrong?Best regards,Heiko

3 years ago

remington.roger11Level 2

asked in General Product Q&A

Removing an activity from an analysis

Hi!! I'm interested in filtering an activity out of an analysis. When I try to filter out the activity from the attribute selection, the activity still shows in the Process Explorer. Is there a way to do a crop selection type filter in the load script?

3 years ago

.14600994Level 1

asked in General Product Q&A

Can we define action on Single number KPI.

When user click on this single number KPI it should lead to another tab?

3 years ago

mayar.gaafaLevel 1

asked in General Product Q&A

Need support with Data Push APIs (Documentation vs Actual Results)

According to the documentation the API GET /api/v1/data-push/{poolId}/jobs/ Should return the data jobs contained in the Data Pool And according to the below screenshot the data Job ID should be in the position of the 2nd box in the image attached: Source: Help resources, section: Data Job Execution API When we run the API above, it returns Extraction tables, not Data Jobs, and the data in the response has nothing to do with the actual data jobs we have in our team. Can you please explain what the API above returns? Also, when we try to delete a data job it drops in the database and doesn’t show in the GET requests sent after that. However, this doesn’t reflect in the interface on the system. Please Advise.

3 years ago

tamás.mészáLevel 2

asked in General Product Q&A

I am plotting throughput times (ordered by the timestamp of first activity) using a line chart and I also include the average throughput time as constant function. How can I achieve that the value of the constant function also filters with sele

As dimension I have: PU_FIRST("case_table", "activity_table"."activity_time")The KPIs I am plotting/I want to plot are:throughput time: CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("activity_table"."activity_time", MINUTES))AVG of throughput times as a constant function:If I use here AVG(... throughput time ....), then (not so surprisingly) Celonis computes these for the single cases in the "dimension set", i.e. returns the single throughput times --> is not what we wantclearly the same happens if I set up a variable with text/replacement "AVG(... throughput time ....)" and call this when defining the KPI in the plotif I set up a variable with a static value being the PQL query AVG(... throughput time ....), then I get a constant function, but it does not filter with selections, i. e. the value of the constant function stays the same independent

3 years ago

mariana.gnask11Level 3

asked in General Product Q&A

Could you please help me to find out how I can check for empty variable input to prevent the component (specifically - OLAT table) from running into an error?

I have the following case:A Variable Input component is configured to write to a variable called "Target"AN OLAP table with one of the KPIs calculating the difference in days between the actual throughput time and the "Target" inputThe formula I am using is: TRIMMED_MEAN(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS(""."", DAYS)), 5, 5) - <%=Target%>)However, the table output will fail if the user wipes out the value from the Variable Input component (which for sure can be the case). I've tried with different operators to handle CASE WHEN the variable is empty (blank): IS NULL, != '', !="" - it's not working (e.g. CASE WHEN <%=Target%> IS NOT NULLTHEN(TRIMMED_MEAN(CALC_THROUGHPUT(CASE_START TO CASE_END, REMAP_TIMESTAMPS("GTO_Application_Workflow_csv"."CHANGE DATE", DAYS)), 5, 5)- <%=Target%>)ELSE NULLEND) The only solution I was able to found in documentations deals with

3 years ago

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

yusuke.tsutshas earned the badge Value Realization Expert
yusuke.tsutshas earned the badge Qualified to Manage Implementation Projects
matt.witty13has earned the badge People Person
Floboyohas earned the badge First Post
ardi.zulfahas earned the badge Qualified to Manage Implementation Projects

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