- - 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,427 Topics
3,376 Replies

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

1427 Topics

Most replies

Most views

Newest first

zeliha.otgözLevel 4

posted in General Product Q&A

What is the difference btw.

What is the difference btw. an event log and a digital footprint?

1 year ago

timothy.brown12Level 2

asked in General Product Q&A

Is there a Variant Explorer or Case Explorer in Views?

Looking to add a variant explorer in the Views based on my knowledge model. Similarly - is it possible to have a case explorer? I believe I can create an analysis linked to the Knowledge model, but then I don't seem to have the ability to select the case table I want to use in the explorers...

1 year ago

denise.kruge12Level 4

asked in General Product Q&A

Hi, can someone help me with a filter script. I need to show a KPI with a date filter for today at 5:00 am.The client wants to see a snapshot every day of the cases open at 5:00 in the morning.Thank you,Denise

Hi, can someone help me with a filter script. I need to show a KPI with a date filter for today at 5:00 am. The client wants to see a snapshot every day of the cases open at 5:00 in the morning. Thank you, Denise

1 year ago

jonas.friscLevel 3

asked in General Product Q&A

i want to setup a olap table in the studio and I have this PQL formula: Do you know how I would work?

CASE WHEN "AE_SIGNALS"."AE_SKILL_NAME" LIKE ('%Veredelung%') THEN COUNT ( "AE_SIGNALS"."SIGNAL_ID" ) * 30 / 60 ELSE NULL ENDI get the following error:The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

1 year ago

gundappa.s11Level 3

asked in General Product Q&A

Hi Team, Do we have an Variable Input Component in Views?

I wanted to create a KPI with reference to Variable <%= Discount %> (Users could define their Discount value). For example KPI as Actual Sales: (KPI (Sales)- KPI(Sales)* <%= Discount %>)).I'm able to create it in Analysis by defining Variable and adding the VARIABLE INPUT (Users may add their discounted values) Component however not in Views.

1 year ago

reenu.josep12Level 4

asked in General Product Q&A

Hello,Is it possible to create the slider bar component in Analysis?

Slider Bar component like below:

1 year ago

masahiro.hayasLevel 2

asked in General Product Q&A

I would like to create a screen to monitor the operating status of the equipment in Analysis.

Is it possible to create a Gantt chart like the image?If so please tell me how. Thanks!

1 year ago

milan.demelLevel 3

asked in General Product Q&A

Why does the Data Pools>Data Consumption table SIZE (on the web page) not equal results from query PROJECTION_STORAGE.used_bytes?

I assumed one is actual data size and the other is allocated storage space, but that does not seem to be the case as in some cases A>B and in some B>A.

1 year ago

pablo.siegeLevel 2

asked in General Product Q&A

Export to Excel not working error "Failed! Bad Request. Data Export is not supported"

I loaded data into EMS (C4C+) from an Excel file, using the Quickstart for CSV/XLSX. The load works Ok, but when I try to do an Export Data from an Analysis component, I get the error message "Failed! Bad Request. Data Export is not supported". How can I resolve this issue? (The export to Excel is activated in the Analysis Settings). If I try the same steps using a model I created from scratch, the export works fine. Regards,Pablo

1 year ago

milan.ericLevel 3

asked in General Product Q&A

How to add a conditional filter to a component filter (load script)?

Hello everyone, I am writing here because I couldn´t solve my issue with other questions asked. My Situation: I have an OLAP-Table with a lot of Data and dates regarding finances.Now I want to add an Input Variable where User can input a single date.Depending on that input, the OLAP-Table should change (2 columns)The field is OPTIONAL and I am struggling with handling the case of "null" as input. My current idea: FILTER "Table"."SomeDate" >= CASE WHEN <%=DATE_OPEN_ITEMS%> is not NULL THEN TO_DATE( <%=DATE_OPEN_ITEMS%>, FORMAT ( '%d-%m-%Y' ) ) ELSE ignore the filter all together END; Now if I type in '31-12-2022' it works great! But 1. If the input field is empty there is an errorand 2. the User has to use ' ' while typing it in. Any ideas? Thanks!

1 year ago

william.ross12Level 2

asked in General Product Q&A

How do you calculate throughput time from the first instance of one activity to the first instance of another when both activities are repeated multiple times in the process? (See example below)

I have process sequence: BCADBCBA..... I would like to calculate the throughput time between the first instance of activity "A" and the immediate next instance of activity "B"

1 year ago

hridesh.mishr11Level 2

asked in General Product Q&A

Hi Team,What will be best solution to resolve below error to load data model."The load failed: Could not load data model. Disk quota exceeded"

Hi Team, What will be best solution to resolve below error to load data model. "The load failed: Could not load data model. Disk quota exceeded"

1 year ago

william.ross12Level 2

asked in General Product Q&A

How do you convert date column from string to datetime at the extraction stage? I tried configuring the column but keep receiving an error.

1 year ago

andres.naran12Level 4

asked in General Product Q&A

Hi Folks!Does anyone knows what this message means in Celonis Starter kit 'NaNM'? We have this value for those KPIs regarding currency conversions.

Hi Folks! Does anyone knows what this message means in Celonis Starter kit 'NaNM'? We have this value for those KPIs regarding currency conversions.

1 year ago

deepak.kumar30Level 3

asked in General Product Q&A

How to convert string(format YYYYMMDDHHMMSS) into the timestamp(date) value using either SQL or PQL?

1 year ago

satyajit.saman11Level 1

asked in General Product Q&A

Get records count (Single KPI) between minimum date value and specific date.

I have a table like this: "Table1". And I want the records count (Single KPI) between the MIN("Table1"."Posting Date") and TOday-7 and "Table1"."Status"='In Progress'. I tried following PQL query:SUM( CASE WHEN ( DATE_BETWEEN ( ROUND_DAY("Table1"."Posting Date"), ROUND_DAY(MIN("Table1"."Posting Date")), ROUND_DAY(ADD_DAYS(TODAY(), -7)))=1 AND ("Table1"."Status"='In Progress') )THEN 1 ELSE 0 END) Note: Formatting = Rounded Number But it is giving me following error:The aggregation function MIN cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs. Could anyone please help me out on this?

1 year ago

gaurav.bade14Level 2

asked in General Product Q&A

I want know why I am getting error : "SAP Job not yet Started. Status: Scheduled"?

We have installed extractor in VM and established successful connection between them. We are creating extraction Data Job and trying to load tables but not moving ahead from log "Job not yet started in SAP. Current status: SCHEDULED", so it could be issue in SAP RFC module, unable to understand the issue please suggest.

1 year ago

sree.cLevel 4

asked in General Product Q&A

Hi Team, have built an action flow to push data to data pool. Getting status code error "409" and "runningJob":"34a865e3-f92a-491c-b05b-4e95cdb45420","message":"A job on the same target is already running. Parallel job executions are not allowed

1 year ago

akshaya.naik11Level 1

asked in General Product Q&A

I am unable to connect to training database. It was working fine last week. Is the training database down?

"Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Telnet connection to the host 3.120.99.40:1433 failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions."

1 year ago

pierre.aless12Level 2

asked in General Product Q&A

How can I enable the Transformations Center in my Sandbox team? Currently I don't the the option in the "More..." drop down menu.

1 year ago

harsh.sinha12Level 1

asked in General Product Q&A

We want to migrate our Views and Analysis from 1 Celonis environment to other. Is there any quick and easy way to do this?Our last option would be to make the data model from scratch.

We want to migrate our Views and Analysis from 1 Celonis environment to other. Is there any quick and easy way to do this? Our last option would be to make the data model from scratch.

1 year ago

hamood.farid12Level 3

asked in General Product Q&A

Having issues connecting to SQL server database for extraction task

I am trying to connect my SQL Server to Celonis to extract data from one of the created databases. It's unable to connect with the following error "Test ConnectionThe connection test failed, please check the Data Connection's configuration and ensure that the system is running: Telnet connection to the host ###### failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions."I have enabled telnet, and checked host/port settings,. Also, I tested the connection using DBeaver and it works well there.Has anyone faced a similar kind of situation? Any help would be highly appreciated.

1 year ago

federico.sparaLevel 3

asked in General Product Q&A

Extract day of the week or holiday from datetime

Hi all, I need to filter some instances occurred on sunday and on holiday. Is there a PQL function that can help me out?Something like this:CASE WHEN DAY_OF_THE_WEEK("EVENTTIME") = 'Sunday' or HOLIDAY("EVENTTIME") = 1 THEN "ID" ELSE NULL END Thanks! EDIT: Solved the day of the week part, still missing the holiday one

1 year ago

andres.naran12Level 4

asked in General Product Q&A

Hi team! we downloaded the procurement starter kit and the P2P S4HANA Connector. There are some KPIs that request the TCURR, TCURF, and TCURX, but there is not any transformation for these tables inside connectorDo you know how to add those tables?

1 year ago

pavan.bhara13Level 3

asked in General Product Q&A

Is there a way to select the scale to be picked in a chart in views?

so here if the count is just one then i just need to display 1 in the legend/axis. it should not show 200m, 300m.... etc. is there a way to achieve it?

1 year ago

Page 32 / 58

Badge winners

bruno.carva11has earned the badge Celonis Technical Expert
bruno.carva11has earned the badge Qualified to Get Data Into Celonis
Niveditahas earned the badge First Post
sunil.rai12has earned the badge First Post
uma.penmehas earned the badge Qualified to Build Action Flows

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