- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Product Q&A

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3026 Topics

Recently active

Most replies Most views Newest first

carina.carin11Level 3

asked in Data Ingestion & Infrastructure

Explanation of Activity: Invoice Due Date Passed

Hi,can anybody help me understanding how the activity Invoice Due Date Passed is defined?I have a few cases, where this occures more than one time in the process and I wonder how this is possible.image1036535 32.9 KBThank you for your help!Best,Carina

2 years ago

nicholas.clarkLevel 3

posted in Data Ingestion & Infrastructure

Error in the Default Pipeline Script for assembling & pushing tables to front-end.

Error in the Default Pipeline Script for assembling & pushing tables to front-end. Has anyone run into an error when running the default pipeline ML script where you get: "Could not execute foreign key join: There are duplicates on both sides of the specified key relationship. Table: Tm_Activities; Key("CaseID")"? Not sure why this arose out of nowhere.

2 years ago

pritam.roy16Level 1

asked in General Product Q&A

The Public Link has been getting open for all without any credential which is avoiding the security policies

The initial idea was to view some Celonis Pages (Process analysis or analysis form Studio) from another tool which is hosted in AWS. Embedding of the Celonis page on that tool. But when we are sharing the link (not the public link) getting the below error message.<<IBC Cloud >> refused to connect. The issue with the public link is when enabling the celonis public link anyone can open the analysis with high confidential data to everyone, although in non editable mode but cases with confidential data will be visible

2 years ago

somashekar.vishwLevel 2

asked in Data Ingestion & Infrastructure

Transformations for tables and columns in oracle ebs for P2P process

I was able to find a p2p best practices for SAP in the partner asset library. We are interested in building the activity table for P2P on oracle cloud. I wanted to get a sense of what tables and columns are need for various activities such as Create Req, Modify PO etc along the P2P process. Any help is greatly appreciated.

2 years ago

.14600105130Level 1

asked in General Product Q&A

Is there only Cloud solution is available or is there any software as well ? And if it can be installed , can we install it on virtual desktop for process mining ?

2 years ago

satoshi.omach12Level 3

asked in Data Ingestion & Infrastructure

Hi Guys, how to do O2C process and AR process in one analysis.

First, we have created O2C process and added tables that are required for AR process. The extraction part is done, but we have stuck in the data model. The connection between vbap and vbfa may be failing.

2 years ago

.146001214Level 2

asked in General Product Q&A

Usage of Push API with Academic License

Hi, I am a student using a academic licence and tried to use the Celonis Push API to upload a csv file into a data pool. When using the Python sample from the documentation HTTP 403 - Permission denied occurred when I made a request. Before I will further debug my code I want to know whether I can use the API at all. Thanks 😀

2 years ago

sruti.devenLevel 2

asked in General Product Q&A

Demo Sandbox

Hi,I am facing some problems with the Demo Sandbox. It says that all the data models are unavailable for some reason. I tried to reload them, but when I go to the workspace, it still says that they are not available.

2 years ago

.14600107205Level 1

asked in Entry Products (Celonis Free Plan & TryCelonis)

I would like to see all the activites where there is a noise in the timestamp with the values 00:00:00 as the time. What is the PQL for that?I tried things like and it didnt't work

"EventLog_ACME_TeachingCase_csv"."TIMESTAMP" --> this gives me all the timestamps"EventLog_ACME_TeachingCase_csv"."TIMESTAMP" LIKE {t '00:00:00'} --> things like this do not work Thanks a lot! Greetings, Ronja

2 years ago

guturi.rajdeLevel 3

asked in General Product Q&A

Delta load issue for action engine skill with machine learning bench

I have a delta load schedule applied for every hour and every day and I have implemented a action engine skill with Machine learning bench for Duplicate checker on some source tables . But for the 28th Jan , I have some records but they haven't ran on 28th delta load schedule as well as on 29th . But they ran on 30th delta load and a signal is created on 30th . Now I need help on why that 28th data haven't loaded on 28th and 29th but on 30th ?

2 years ago

alex.giorgLevel 2

posted in Process Analysis

Studio Views are very powerful with data and actions but, by default, they are not aesthetically appealing like Process Analitycs.

Studio Views are very powerful with data and actions but, by default, they are not aesthetically appealing like Process Analitycs. For example I dont find this functions: change colors or backgroud colors (and transparency).change borders and borders type.use KPI dedicated components like Gauge tool menu to guide inside big applicationsIntegration with third parts javascripts components....and so onIs there a way to do this things?Thank for every suggestion.

2 years ago

greeshma.kandiLevel 1

asked in General Product Q&A

how can we connect Celonis EMS to Hana Neo cloud (version: 1.00.122.30.1582793455) environment/database?

Do we have any Cloud extractor to connect to SAP HANA neo cloud database?

2 years ago

daniel.riesLevel 3

asked in General Product Q&A

Apply a filter on CALC_THORUGPHUT

Hey,I want to measure the lead time between two activities, but which must contain a certain (variable) attribute. I tried this with the function "BIND_FILTERS" but fail. Does anyone have a solution for something like this? MEDIAN ( CALC_THROUGHPUT ( FIRST_OCCURRENCE [ '<%= Step_1 %>' ] TO FIRST_OCCURRENCE [ '<%= Step_2 %>' ] , REMAP_TIMESTAMPS ( "_CEL_SCHUTZBRIEF_ACTIVITIES"."EVENTTIME" , MINUTES ) ), BIND_FILTERS ( "_CEL_cc_claim","ANS_KNZ_Mapping_csv"."ANS" = '<%= ANS_01 %>' ))

2 years ago

guturi.rajdeLevel 3

asked in General Product Q&A

When i open the Celonis IBC link. I am getting 504 Gateway Time-out . Can anyone help on to solve this issue

2 years ago

cayetano.romerLevel 2

asked in General Product Q&A

Why does hiding activities in Process Explorer reduce the number of cases? (35832 vs 56860)

2 years ago

muthappan.alagaLevel 4

asked in General Product Q&A

Trying to find documentation on pycelonis to get list of pacakges from a space and list of analysis from the package

i am using pycelonis in jupyter notebook to get list of spaces, list of packages and its analysis. I am able to get list of spaces, but list of packages is not possible, also space.packages.find is not pulling one of my package key. If i can get the documentation to find list of packages and analysis that will help. ThanksMuthappan

2 years ago

james.newma12Level 3

asked in General Product Q&A

Task Mining Local File Type

I am setting up Task Mining and want to see what is being saved prior to uploading. It is currently being saved as a parquet file but I cannot install a parquet viewer on the machine due to security restrictions. Is it possible to save the files as a different file type that I can view in plain text?

2 years ago

juan.carlos.solan13Level 1

asked in General Product Q&A

How to create Data Model by using O2C files imported with SAP ABAP output loader?

I've uploaded all the tables that the ABAP reports generated, but now I need to use that tables to create the Data Model and hence be able to use the O2C apps. After installing the O2C app, it gives error as it cannot find the Activity Table. How can I create it? I thought this was automatically performed once the CSV files are loaded. Am I missing something?

2 years ago

.14600792Level 2

asked in General Product Q&A

Solved: How do i get the data consumption monitor to work?Currently, despite the points below, I get the error in the studio that the tables, e.g. data_consumption_events, can not be found.

Hi everyone,I'm new on this topic, therefore possibly a not so solid question. ;-)Can it be a problem with permissions or did I miss a point? I have downloaded and installed the data consumption/pipeline monitor from the EMS store.APC calculation has taken place after serveral daysI followed the instructions in the help center (activating monitoring, looking at problems with bug)activated "Eventlog automerge" in all three data models / also tried without activated automergeData jobs for Data Consumption Monitoring & Data Pipeline Monitoring (Transformation/Data Load) successful executed (= green)Data model was loaded according to log Thanks in advanceJens

2 years ago

.14600104695Level 2

asked in General Product Q&A

How to create the table schema when there is no data

For Oracle EBS, AR, there is no data in AR_DISPUTE_HISTORY (0 rows). Hence when running the transformation, it is giving the following error. How to resolve the same ? Error while executing transformation Create View: AR_DISPUTE_HISTORYERROR: Relation "ar_dispute_history" does not exist

2 years ago

andre.maerk11Level 1

asked in Data Ingestion & Infrastructure

Hi Guys, I am trying to calculate the time between two activities. But the second activity is not unique.

For example: The time between activity A-1 and activity LIKE A. Activity LIKE B can be A-2, A-3, ..., A-n. I always want the activity that is closest to activity A. Between A and B can be other activities. thanks for helping

2 years ago

franziska.sch√§Level 2

asked in General Product Q&A

Format Field vs. Format Function

Why is the format field in the pql-editor offering more options in formatting the output than the FORMAT() function? E.g. I can enter in the format field in the pql-editor the format '%d.%m.%y' without any occuring errors but not in the format function while converting a date to a string.

2 years ago

.14600111679Level 2

asked in Entry Products (Celonis Free Plan & TryCelonis)

Kann man CO2 Werte anzeigen lassen. Ich möchte eine Excel Datei mit Aktivitäten und deren CO2 Werte hochladen, doch bislang habe ich keine Lösung dafür gefunden?

2 years ago

.14600103620Level 2

asked in General Product Q&A

Hello Everyone,I am trying find the duplicate values in one of my field but could not able to write the code for it. I have tried with Count(Distinct) > 1 with Case when statement however I'm not getting the output for it.

In the below table I am checking for duplicate values in Name column. I need the count of duplicate values for example Name ABC has twice, so the out put should be 2. Could you please help me with it. OUTPUT:

2 years ago

sanchit.khann15Level 3

asked in General Product Q&A

Converting from BINARY to STRING in EMS?

Converting from BINARY to STRING is available directly on On-Prem system.But the same is not available on EMS or I am missing out on the feature.Can you please suggest a good way to CONVERT BINARY to STRING. I do not want to CAST AS STRING as that doesn't help. I need to CONVERT BINARY to STRING

2 years ago

Page 81 / 122

Badge winners

勇樹.平野has earned the badge Masterclass in Selling & Positioning
タカヤス.タナカhas earned the badge Masterclass in Selling & Positioning
xin.shihas earned the badge Masterclass in Selling & Positioning
tomomi.yamadhas earned the badge Masterclass in Selling & Positioning
yuya.sasathas earned the badge Masterclass in Selling & Positioning

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

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