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

janpeter.van.dLevel 8

asked in General Product Q&A

Extractor Builder: Escape single quotes in extraction filter field

While extracting data using an API, we got stuck at a point that in the extraction filter field no strings with a single quote can be inserted, such as: filter = 'content_description eq '*purchase order*' ' It will return an error, see screenshot below. Is there an way to insert string values here with a single quote in it? Things we tried:Escaping the single quote characters using two single quotes (as in Vertica) or with a backslash, without success.Wrapping this value in a variable. It looks as accepted in the first way, but will return in parsing error during te extraction (see screenshot below). Thanks in advance!Jan-peter Screenshot 1: Filter Statement Field Screenshot 2: Error when text string is wrapped during the extraction:

2 years ago

.1460040856Level 3

asked in General Product Q&A

Can we create Dynamic Analysis in view ? if yes than How .thankyou

Can we create Dynamic Analysis in view ? if yes than How . thankyou

2 years ago

johann.bangLevel 2

asked in General Product Q&A

Cant edit my analysis! Does anybody know why Korbinian Zieler is in edit mode? It looks like it is a default, as I get the same message on every new analysis.

2 years ago

marco.valliLevel 2

asked in General Product Q&A

Is there a way do reproduce 'logbook' on Studio?

I was looking for a way to take 'pictures' to track a few KPI's through time. I used to do that with Transformation Center using the Logbook feature, but I'm a little bit lost about how to do it on Studio.

2 years ago

.146004267Level 2

asked in General Product Q&A

What is the easiest way people have found to purge data

I want to keep a rolling 2 years of data in Celonis. So each month I would ideally like to delete the 1st month in Celonis and add the new month. I do not want to reload the data each month - full load (as that would take too long for two years of data) and of course a delta load only adds change to the existing data.

2 years ago

harish.c.jLevel 3

asked in General Product Q&A

How to run a data job OR transformation from Machine Learning Workbench?

2 years ago

rino.yasuiLevel 2

asked in General Product Q&A

Now I'm setting up SAML SSO with Celonis EMS.It seems that the SAML Request from SP to IdP is being forwarded by HTTP POST Binding.Is it possible to change to HTTP Redirect Binding on the SP side?

Now I'm setting up SAML SSO with Celonis EMS. It seems that the SAML Request from SP to IdP is being forwarded by HTTP POST Binding. Is it possible to change to HTTP Redirect Binding on the SP side?

2 years ago

.1460098815Level 1

asked in General Product Q&A

Getting below error while setup the DB connectionDB - Microsoft SQL ServerTelnet failure indicates that either the host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions

I am trying to connect the Celonis with Client On-Premise Microsoft SQL Server, and filled in all the required details.Please help to get resolve this issue

2 years ago

.1460012016Level 1

asked in General Product Q&A

Is it possible to trigger an Action Flow when another AF finishes running?

I've built an AF that triggers a skill that write data into a table. The problem is that the skill is triggered as many times as the number of rows in the table. That's fine because the table is really small, but I can't execute an ML script as next step in the same skill, since the ML script is triggered as many times as the number of rows. As a solution, I though that I can build a small AF that is triggered only when the first AF finishes running (so the whole rows will be written to the table). This second AF will itself trigger a skill with the execution of the ML script in it. This way the ML script will be executed only once. I can't find a module that allows me to trigger an AF when another one finishes running.

2 years ago

.1460040856Level 3

asked in General Product Q&A

i have a column contain due date i want to make each value of the due date ,end of the day as due date of the same month ,thankyou

i have a column contain due date i want to make each value of the due date ,end of the day as due date of the same month , thankyou

2 years ago

.14600124228Level 2

asked in General Product Q&A

Hey there, I´m trying to calculate the throughput time of a certain process flow and unfortunally I can´t get any further.

In detail I want to canculate the thoughput time only if ther is an gripper chance in the process flow. This means that we have a batch production and only the last cycle of any batch is relavent. I was trying to solve this problem by using "case when product variant a is unequal to productvariant b" but cant´t get any further. Does anyone know how to solve this problem?

2 years ago

yang.wang11Level 2

asked in General Product Q&A

package celonis with pyinstaller fail!

I tried to use pyinstaller to package celonis program but failed with message "FileNotFoundError: [Errno 2] No such file or directory: 'C:\\\\Users\\\\...\\\\Temp\\\\_MEI109202\\\\mlflow\\\\ml-package-versions.yml'The code is simple as below:from pycelonis import get_celoniscelonis =get_celonis("...", "...")print('success!')

2 years ago

anushmita.rcLevel 2

asked in General Product Q&A

Are on-Prem data models not available in Studio? Haven't been able to add any as data model variables.

2 years ago

leonor.doris.rodriLevel 3

asked in General Product Q&A

How to automatically upload to my Data Pool, a file from a repository using Machine Learning

Hi, I am creating a dashboard (Analysis) based on a Knowledge Model, which was created with database contained in an Excel file. How can I upload automatically thrice a month the Excel file, considering its changes between the different loads. The file lives in a repository (Sharepoint), and the database from the Excel should be transformed by a Data Job. ThanksLDH

2 years ago

janpeter.van.dLevel 8

asked in General Product Q&A

Access SAP data using Python (In ML Workbench)

Hi all, For a use case, we need to iterate over SAP tables and therefore the SAP on-premise extractor is not sufficient. We are investigating accessing the data using a Python script (possible in the Machine Learning workbench) as described in Connecting Python with SAP (step-by-step guide) | SAP Blogs. Has somebody experience with this approach? If we want to do it in the Machine Learning Workbench, this requires (temporal) admin access to install the SAP NetWeaver RFC SDK. Is this something that is possible? Looking forward to your ideas! Cheers,Jan-peter

2 years ago

vasco.caron11Level 4

asked in General Product Q&A

Is there a way to extract Celonis Users Information automatically?

Essentially, we are tracking usage of our Action Views / Skills through an augmented attributes table. Unfortunately, this table refers to users through a code (CHANGED_BY field): We have recently realized that we can extract User Information like this: Which will give us a correlation between User IDs and the actual Users (Name + E-mail):Since we have an ever-shifting user-base, is there a way for us to get this information into/from Celonis' Back-End (Data Integration) automatically? Thank you in advance!!

2 years ago

.146003813Level 2

asked in General Product Q&A

How do I calculate the time spent between the same activities that occur multiple times in a process?

in the example below, Action Section has been updated occurs multiple time, I want to calculate the time spent between each of the "Action Section has been updated"xyz Action Section has been updated 2-Apr-22def xyz Action Section has been updated 2-Apr-22abc def abc Action Section has been updated

2 years ago

guillermo.gost12Level 8

asked in General Product Q&A

Jupiter - What are the data volume limits to be processed in the Machine Lerning Workbench?

Are there any limit to the amount of data to be processed by a Jupiter notebook running in the Machine Learning module? I mean... can I for example load a pandas data frame with 2 billion rows ...or any crazy volume? Is there going to be a cost associated with execution of a Jupiter notebook? or to the data volume processed or the cpu used? TIA!

2 years ago

guillermo.gost12Level 8

asked in General Product Q&A

Ingestion for files - sftp. - how to schedule it?

I will have periodic extractions from the transactional systems once a day into a bunch of text files (.csv) How can I set up extraction jobs to do that? Is it a specific connector? Because it seems the "File uploads" is only for manually upload files. But I need to upload them from a shared folder, and do it periodically and automatically. TIA

2 years ago

benedikt.kleppLevel 1

asked in General Product Q&A

"URL format is incorrect or domain is not whitelisted, please check application.yml". Does anybody know how to fix this runtime Celonis Agent error?

Hi, I would like to run an Celonis Studio Action Flow that calls the API https://magpie.springernature.app/api/users. This API only allows access from certain IP addresses, I therefore have to use the HTTP (On Prem)-module for this. Which connects to a Celonis Agent on our company's server. There seems to be something wrong with the application.yml file of this Celonis Agent, as running the Action Flow produces the runtimeerror: "url - URL format is incorrect or domain is not whitelisted, please check application.yml". Does anybody know what I'm doing wrong? Thank you very much! The application.yml file looks like this:---agent: name: Celonis-On-Prem-Action-Flow concurrent_executions: null id: 44962ead-5b9c-4b94-8e58-d93427c7186fcelonis: authentication: appKey: <I think I better not tell you this> teamDomain: springer-nature-productive env: eu-3 internal-proxy-config-path: null proxy-config-path: nullvault: enabled: false file: nullconnectors: http: enabled

2 years ago

aniketh.vLevel 1

asked in General Product Q&A

There is a problem while connecting ebis and oracle ?

2 years ago

david.liu13Level 3

asked in General Product Q&A

Remove duplicate/almost same-time activity in event log in data collection and delete uploaded file

Hi all, I have been trying to use file upload method to upload the source data, however, i often find that the original event log has a lot of duplicated activities (same timestamp or near same-time timestamp) which created a lot of "noises" in the analysis, for example: Create Purchase Order 2021-01-01 01:00:00Cerate Purchase Order 2021-01-01 01:00:01 This kind of "duplicated" activities are less likely to be performed by human, would you please advise if there is a way to de-duplicate records that happened within a very short timeframe (say 1 s) with all other fields having the same value? Also, as I have been trying using different file and thus this occupy much of my data consumption, may I know is it possible to remove the file uploaded and release some capacity for other analysis? thanks in advance!

2 years ago

nik.khandLevel 1

asked in General Product Q&A

Where I can get the transformations jobs for APC Data Consumption Monitor? In EMS Store I can only see APP not the connector.

2 years ago

sooraj.edayaLevel 3

asked in General Product Q&A

Conformance Checker - Process Model - C4C+

I am using the C4C+ for a sales pitch. While working with the conformance checker, came the question that Is it possible to set some business rules for process model. For example, when attribute x > 100 follow an approval path 1, else path 2 ? And See if both paths are conforming to their respective business rules?

2 years ago

.146004197Level 1

asked in General Product Q&A

How can I connect my SMTP server to my Action Flow modules?

Hi all, I am trying to use the e-mail module in Action Flow and I need to add a connection using my SMTP server. These are the configurations that I should fill but when I fill these configurations, it gives me an error like that :Is there anything that I should do before filling these configurations or in general how can I use my SMTP server in my Action Flows? Thank you,Ugurcan

2 years ago

Page 46 / 57

Badge winners

patrick.rossi11has earned the badge Celonis Certified Data Analyst
vivuhas earned the badge Qualified to Manage Implementation Projects
aakash.choubhas earned the badge Value Realization Expert
aakash.choubhas earned the badge Qualified to Manage Implementation Projects
yusuke.sobajhas earned the badge Qualified to Build Analyses

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