- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

2 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,423 Topics
3,364 Replies

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

1423 Topics

Most replies

Most views

Newest first

claire.chen12Level 3

asked in General Product Q&A

Failed to change column config when add table to data pool using Pycelonis

I changed the column config to string, but it seems that the configuration is not applied successfully (still get error message when I tried to add foreign key,)Anyone knows why it happened please help me.p.s. I'm using pycelonis 1.7.0 Thank you in advance.

1 year ago

jumbo.szkLevel 4

asked in General Product Q&A

Question about P2P data connector

Hi all, I have question about Celonis standard data connector Procure to pay.In that data model, we have parameter 'predecessor date ' that is used in SAP ABAP one time extraction program.The description says 'Parameter used to filter the extraction of the purchase requisition table (EBAN) by using the PR creation date. This is done to get PRs that were created e.g. up until 3 months before the PO scope starts.' And my question is why should we set this parameter before the PO scope starts? Is it means PR is created before PO so we should set this as before PO starts and 3 month is the just example and its depends on my client PR-PO relationship?

1 year ago

avishma.sLevel 1

asked in General Product Q&A

To find history type happened before and after 5 minutes of viewing

For the claims. there is history type='viewing', how can we get count of other history types that has occurred other than viewing before 5 min and after 5 minutes of viewing. There are different history typesThere is timestamp that captures what history type has occurred at what time, based on this I want to get the count of other history types that has occurred within 5 minutes of before and after the history type='viewing' has occurred. Kindly help with idea for the PQL query

1 year ago

.146192833Level 4

asked in General Product Q&A

Multiple records getting selected on profile view instead of single

Dear Experts, I have created a profile view where user sees records and we expect to click and update it. When we try to click it , multiple records are getting selected just like shown in snapshot. Can you please advise ?

1 year ago

jumbo.szkLevel 4

asked in General Product Q&A

Question about data job tasks

Hi all,I would like to know wheather celonis data job task have following features or not. 1. Code history feature to compare old to new code.2. Export all SQL on data job task, if #1 doesn't exist I'd like to store my SQL on my local.Thanks and regards :)

1 year ago

keonhyuk.songLevel 2

asked in General Product Q&A

Assgin variable on drop down list

How can I assign a variable on the dropdown component? I want the result of the dropdown component act like a variable input Thank you

1 year ago

maximilian.alterLevel 2

asked in General Product Q&A

I want the general total number of items as the output over all rows in an OLAP. Is there a possibility to have it dynamic and not just type in a fixed number like e.g., '123456'?

For example to calculate the share of items for each region. If I have an OLAP with all regions, I need to have the total number of items divided by the items for the region, but I want to have the total number dynamic to not update the total number manually.So the same output over all rows. Does someone knows how to do it?

1 year ago

fiona.murphLevel 3

asked in General Product Q&A

I want to copy a knowledge model from one package to another. When I use the 'copy to' function the records etc in the knowledge model do not copy. I only get a blank Knowledge model in the new location. Is there a way to do this correctly?

Drag and drop also does not work.

1 year ago

kodimela.navanLevel 1

asked in General Product Q&A

Hi, can we create actions flows out of a Bookmark created in the system. That is sents out to users an email with the content or link to our dashboards?

1 year ago

matt.slocu12Level 3

asked in General Product Q&A

I am looking to count the number of cases where two activities occur within a short window of time, but running into my aggregation incorrectly counting number of activities.

Imagine an activity table like this: Case 1 - Activity A - 1PMCase 1 - Activity B - 2PMCase 1 - Activity C - 3PMCase 1 - Activity D - 4 PM I want to aggregate on another column. I am using OLAP Table and my KPI is: Name: count of cases when Activity C happens < 2 hours from Activity B Formula:SUM(CASE WHENHOURS_BETWEEN(PU_FIRST(Cases,Eventtime,Activity=Activity B),PU_FIRST(Cases,Eventtime,Activity=Activity C)) < 2THEN 1ELSE 0END) When I run this against a list of all cases, I get the right answer 1, but when I aggregate it, I'm getting 4. I thought this would only evaluate once per case... is that incorrect? Thanks,Matt

1 year ago

yiming.sunLevel 2

asked in General Product Q&A

What is the principle of creating the baseline graph in process explorer?

Recently we have got some questions from our clients about the baseline graph in the process explorer in process analytics. The question is, in the variant explorer, the most common variant has 5 different activities, but in the process explorer, only 4 of these 5 activities show up in the baseline graph. If we click to add activities, two new activities are added but none of them is the one from the "happy path" (the most common variant). We have checked the help documentation about the process explorer, such as "The Happy Paths show you the most frequent starting activity and the most frequent ending activity as well as all edges and other activities that are included in the variant connecting those two". But this doesn't really solve the question in our case. Could anyone please explain what the principle is to create the baseline graph in process explorer?

1 year ago

thomas.prellLevel 1

asked in General Product Q&A

I would like to export an end to end representation of the Direct Follower Graph from the Process Explorer, e.g. as an image. My process consists of 60 activities, so I need to zoom in to have the full view. Therefore a screenshot doesn't work.

1 year ago

zeliha.otgözLevel 4

asked in General Product Q&A

Can I operate each KPI components with date pickers which have different SAP table columns. Explained in the image below. thanks.

1 year ago

himanshu.sharm16Level 3

asked in General Product Q&A

Aggregation function together with a dimension function input.

Sum(CASE WHEN "ActivityTable"."Activity" = 'something' THEN 1.0 ELSE NULL END) gives me the count when there is an entry "something" in the table.My challange is following: I need to count Distinct Case_ID, whenever "something" happens. It can happen more than 1 time for an Case_ID, so i need a PQL statement like:CASE WHEN "ActivityTable"."Activity" = 'something' THEN count (Distinct(Case_ID) ELSE NULL END, which is ofcourse not working like this. Ideas and solutions are welcome. Thanks a lot

1 year ago

sean.fergu12Level 3

asked in General Product Q&A

Can I arrange the columns in a CSV within an Action Flow? Seems this should be straightforward, but I cannot seem to organize columns as my customer has requested

1 year ago

jumbo.szkLevel 4

asked in General Product Q&A

Where can I find table list to use celonis market place template?

Hi all,I'd like to know where can I find prerequisites to use celoinis template in market place, which SAP table is required to use it, for example.should I need to check all SQLs or data connections to know it or do we have something Excel list to know it?

1 year ago

chirag.sabha12Level 2

asked in General Product Q&A

I am currently working on the P2P process and right now the last activity of the process defined in my data model is "Clear Invoice". I want to add another activity named "Payment Proposal Creation" which is a non-standard activity. Can anyone h

Like what information do we need to define a new non-standard activity, what tables we need to look at for Payment Proposal Creation!

1 year ago

abhishek.kumar28Level 1

asked in General Product Q&A

Can Celonis be used as a data source to other tools?

1 year ago

jan.pilarLevel 2

asked in General Product Q&A

Calculating case throughput time until first occurence of either one of two activities

Hello everyone!I have the code below:AVG( CALC_THROUGHPUT( ALL_OCCURRENCE['Process Start'] TO FIRST_OCCURRENCE['Incident assigned to a new operator'], REMAP_TIMESTAMPS("activity"."SYS_CREATED_ON", SECONDS) ) / 60 /60 )which calculates averate throughput time until activity "Incident assigned to a new operator" occurs. I have however changed the data transformation script, so that this activity can now either be "Incident assigned to an operator by service desk" OR "Incident claimed by operator from incident pool"Obviously this change broke my KPI, as what used to be one activity can now be either one of the two. I was hoping it would be possible to pass two strings to FIRST_OCCURRENCE[] (such as FIRST_OCCURRENCE['Activity A','Activity B']), indicating I want to measure time until occurence of either "activity A" or "activity B", similarly to NODE_ALL[] vs NODE[], but unf

1 year ago

jayatheertha.ayach13Level 1

asked in General Product Q&A

I am getting error while uploading a file in Data Integration On Premises. The error is : File Upload failed: cloud.celonis.integration.services.datamodel.file.DataPushJobException: ["2023-04-11T04:17:23 - Starting execution, status set to RUNNI

1 year ago

praveen.ojha12Level 3

asked in General Product Q&A

How to write a if/else statement for runtime variable?

1 year ago

e.nLevel 4

asked in General Product Q&A

Dashboard Component

Is it possible to visualize graphs such as scatter plots, correlation plots, box plots, etc. in Celonis?

1 year ago

zeliha.otgözLevel 4

asked in General Product Q&A

How to find your celopeer at the platform?I want to find my Celopeer. Eventhough I wrote her name in the search button I cannot find.

How to find your celopeer at the platform? I want to find my Celopeer. Eventhough I wrote her name in the search button I cannot find.

1 year ago

zeliha.otgözLevel 4

asked in General Product Q&A

Can we add filters to variables?

1 year ago

jonas.friscLevel 3

asked in General Product Q&A

Problem with Login History API parameters

Hi, I have created an application, authorised it and created a custom extractor which uses the Login History API to load the login history into a data pool. Unfortunately, this data is very limited and I don't know how to specify the parameters to load a larger period and analyse it afterwards. Is it possible to include a date filter in the endpoint or in the extraction, so that all data since a certain date is loaded?

1 year ago

Page 28 / 57

Badge winners

valerie.finst11has earned the badge Celonis Certified Data Analyst
md.asif11has earned the badge Qualified to Get Data Into Celonis
tomoko.sasakhas earned the badge Celonis Technical Expert
tomoko.sasakhas earned the badge Qualified to Build Analyses
tim.sandehas earned the badge Qualified to Build Views

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