- - 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

.146004338Level 1

asked in General Product Q&A

Hi,I have acess to celonis partner portal but I am not able to acess https://persistent-systems-sandbox.demo.celonis.cloud/ui/login . Please help me to access Sandbox. My email id is manpreet_rekhi@persistent.com, provide instructions

Hi, I have acess to celonis partner portal but I am not able to acess https://persistent-systems-sandbox.demo.celonis.cloud/ui/login . Please help me to access Sandbox. My email id is manpreet_rekhi@persistent.com, provide instructions

2 years ago

connor.manthLevel 3

asked in General Product Q&A

Is there a way to show the transformation center chart within an analysis or a Studio View?

I would like to keep a KPI analysis and transformation center chart on the same page. Is it possible to have some sort of iFrame, or view to transformation center in the Analyses? Or perhaps a Studio View?

2 years ago

dharma.tekipLevel 1

asked in General Product Q&A

Not able to load Data to O2C Use case

Throws this error:Data model load failed during table export: Data model tables could not be exported: O2C_VBRP, O2C_MARC, O2C_KNKK, O2C_VBUK, O2C_VBUP, O2C_VBFA, O2C_VBAP, O2C_KNA1, _CEL_O2C_ACTIVITIES, O2C_KNB1

2 years ago

sriram.sampaLevel 1

asked in General Product Q&A

How to get access to "Team settings" in C4C+

I have logged into C4C+ and also invited a few of my colleagues. We intend to start a new project shortly.However, I am unable to navigate to the "Team settings" so that I can assign roles to my team members. I dont get the link to Team settings at all!

2 years ago

antoine.leducLevel 3

asked in General Product Q&A

Hello,I would like to calculate a market share by country in a simple table.Problem :i have column 1 : Country, column 2: sum(invoice), column 3: market share by country but i it take the sum just for the country and not the sum of all of it

Hello, I would like to calculate a market share by country in a simple table. Problem : i have column 1 : Country, column 2: sum(invoice), column 3: market share by country but i it take the sum just for the country and not the sum of all of it

2 years ago

xiao.huangLevel 2

asked in General Product Q&A

Error code: 'ImportError: cannot import name 'CelonisCollection' from 'pycelonis.utils.api_utils'

The following code block was used to connect machine learning workbench to Celonis data models. The code worked for a long period of time until recently it returns an error. Anybody has an idea? pip install --extra-index-url=https://pypi.celonis.cloud/ pycelonis --upgradefrom pycelonis import get_celonisfrom pycelonis.pql import PQL, PQLColumn, PQLFilter ------------------------------------------------------------------------------------------------------------------------------------------------------ImportError Traceback (most recent call last)<ipython-input-9-175b2f233f28> in <module> 1 from pycelonis import get_celonis----> 2 from pycelonis.pql import PQL, PQLColumn, PQLFilter ~/.local/lib/python3.7/site-packages/pycelonis/pql.py in <module> 4 from collections.abc import Iterable 5 ----> 6 from .utils.api_utils import CelonisCollection 7 8 ImportError: cannot import name 'CelonisCollection' fr

2 years ago

.14600125398Level 2

asked in General Product Q&A

Where can I find specifications to connect with the Celonis Data Push API?

I need to setup a data push to the API, but I'm not able to find how. I only have a tech. sheet saying that this is possible. Regards,

2 years ago

ryotaro.manabLevel 3

asked in General Product Q&A

Is it possible to display the number of cases for each rework count?

In the attached photo, the number of cases is duplicated and counted.I want to know the PQL that solves this.

2 years ago

rohith.sriniLevel 1

asked in General Product Q&A

What exactly is the difference between Process Connector, Data Connection (Extractor) and Extractor builder ?

I have gone through the explanation in documentation, but didn't find it to be detailed enough. Can somebody please explain with certain examples ?

2 years ago

.146004027Level 1

asked in General Product Q&A

Why does getting an error when tying to do delta load?

Some times working fine and some times getting below error Change log extraction failed!. Change log strategy not specified. Celonis Support ID: 889395d9-5218-4e84-a325-da537c6a4aa5

2 years ago

anna.bohneLevel 2

asked in General Product Q&A

I have a question - how does the function "having" work in Celonis PQL?I need to select case where Count(Activities)>3.How can i do it is Celonis?Thank you so much!

I have a question - how does the function "having" work in Celonis PQL? I need to select case where Count(Activities)>3. How can i do it is Celonis? Thank you so much!

2 years ago

.1460012569Level 1

asked in General Product Q&A

How to Connect Purchase to Pay Coupa and Salesforce , Oracle is required to connect these systems with Celonis?

Dear all, I have checked with Coupa and Oracle both connectors, its shows the below error. How to resolve these issues. Thanks Regards,Jayaraman.M

2 years ago

alexander.kwaukLevel 3

asked in General Product Q&A

Total throughput time of a sub process which occurs multiple times within a case

Good evening guys,I would like to calculate the total throughput time of a sub process which can occur multiple times within one case. The subprocess always starts with a unique activity and ends with a unique activity. There might be different activities between the start & end activity (see picture). I tried my best by using the MATCH_PROCESS_REGEX function but didn't succeed. Thanks a lot for any hints and suggestions! Cheers,Alex

2 years ago

david.liu13Level 3

asked in General Product Q&A

Execution error: ERROR: Column "_EVENTTIME" is of type timestamp but expression is of type varchar

Hi all, I am trying to transform the data from multiple excel files into a single activity table but while I am transforming the timestamp field. it shows the error below:Execution error: ERROR: Column "_EVENTTIME" is of type timestamp but expression is of type varchar When I upload the file I have already indicated the field as DATETIME field Therefore i am not so sure about how this went wrong, appreciate your time and help in advance!

2 years ago

mercedes.mill√Level 2

asked in General Product Q&A

I want to have two kinds of events/activities in the same activity table and add a filter to the process explorer depending on what I want to display.

I've created an activity table in which I've created a level column that will contain 1 or 2 depending on what I would like to display. In a dashboard, I have made the following tests with no desired results: Created a process explorer sheet and add the activity table to it. Add a filter to the sheet in order to display on the process explorer activities of level 1.Created a new sheet to which I added a process explorer component and added a filter to the component itself. None of above cases worked. Is is possible to filter activities display in a process explorer? Thanks

2 years ago

.14600117678Level 1

asked in General Product Q&A

I would like create a single KPI that uses a conditional count. This KPI should display the count of the number of cases within a process that has a duration < 60 days between two specific events.

2 years ago

salma.zepedLevel 4

asked in General Product Q&A

How can I find the profile for pycelonis when using content-cli pull data-pool?

We are trying to obtain the profile name of our Team URL for using it in the Machine Learning Workbench. So far, only one of them works correctly.

2 years ago

.146003930Level 1

asked in General Product Q&A

Am i able to amend the 'Happy path' flow of tasks?If yes - can this include parallel gateways to reflect activities that can be done at the same time?

Am i able to amend the 'Happy path' flow of tasks? If yes - can this include parallel gateways to reflect activities that can be done at the same time?

2 years ago

j.smithLevel 1

asked in General Product Q&A

Time difference between previous line

Hi! I have a large activity table and am confused how to calculate the difference between current line timestamp and prior line timestamp. example: line 2 timestamp - line 1 timestamp, then line 3-line 2, etc through all the steps of the case I can do this in the PQL with a lag function but was advised to look into this from a Celonis calculation. Is there a particular function I should be looking at or a way to do this? While the case explorer, this seems to be done automatically, but I cannot figure a way to do this within a dashboard. Thanks!

2 years ago

sammer.puranLevel 1

asked in General Product Q&A

How to update the activity table with a new version of a CSV file for second time?

I am trying to update an activity table in an ongoing analysis, I tried to follow this guide https://community.celonis.com/t/how-to-update-the-activity-table-with-a-new-version-of-a-csv-file/3764 But I get the error 403 (same as discussed in the question). I have updated the table once sucessfully but updating a second time yields this error. Is it. a restriction in Celonis that this feature is only available one time per user?

2 years ago

alfredo.craveLevel 2

asked in General Product Q&A

Is it possible to make values of a bar chart visible on views mode?

Hi, i'm starting working with views, and I couldn't find any options or YAML code to visualize the values of a bar chart on views mode. I've been looking on Celonis cloud help as well but couldn't find it. Any help would be appreciated. Thanks!

2 years ago

.146004301Level 1

asked in General Product Q&A

How to escalate ticket for non-response reply from celonies

I have raised a ticket but i did not get any response from Celonies , how to escalate this ?Can you please suggest on this

2 years ago

roan.schuu13Level 3

asked in General Product Q&A

What is the XML format when implementing an endpoint that returns XML?

I see the in Configure Response, the XML but the values are not in there. Problem i have now is that I can not use this end point as a dependency for another end point due to no values.

2 years ago

so.yahatLevel 2

asked in General Product Q&A

How to use LIKE in CALC_THROUGHPUT

Hi Community,I have a question : I'd like to use LIKE operator in CALC_THROUGHPUT function like this.---FILTER (CALC_THROUGHPUT(LAST_OCCURRENCE[LIKE 'A_%']TO FIRST_OCCURRENCE[LIKE 'B_%'],REMAP_TIMESTAMPS("TABLE"."TIME_STAMP", DAYS))) <= 7 /* only within 7 days duration.*/---but this doesn't work and I found the page* that is similar to my question.This page is helpful, but in my case, the first half of the first argument(LAST_OCCURRENCE[LIKE 'A_%']) requires LIKE operator as well. Please let me know if you have any ideas.Thanks.*Reference : https://www.celopeers.com/s/question/0D50700000GC6lJCAT/using-ldquolikerdquo-in-process-functions-as-calcthroughput?t=1645409602164

2 years ago

rui.peixoLevel 2

asked in General Product Q&A

Is it possible to restrict users' access to dashboards by company code?

Hi, We are a shared services company and we would like to provide differentiated access to users depending on client/company code.For example: User A Access: Company codes 1000 & 1001 User B Access: Only company code 1010 Is it possible? Thanks

2 years ago

Page 48 / 57

Badge winners

yoko.fujikhas earned the badge Value Realization Expert
yoko.fujikhas earned the badge Qualified to Manage Implementation Projects
kunal.baner11has earned the badge Qualified to Get Data Into Celonis
patrick.rossi11has earned the badge Celonis Certified Data Analyst
vivuhas 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