Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 1,457 Topics
  • 3,458 Replies
1456 Topics
janpeter.van.d
Level 8
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

10
janpeter.van.d
Level 8
V
Level 4
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!!

30
V
Level 4
.
Level 2
.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

70
biswajit.jena12
Level 3
G
Level 8
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!

40
G
Level 8
G
Level 8
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 

90
G
Level 8
B
Level 1
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

30
B
Level 1
A
Level 1
aniketh.vLevel 1
asked in General Product Q&A
There is a problem while connecting ebis and oracle ?

There is a problem while connecting ebis and oracle ?

00
A
Level 1
D
Level 3
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!  

20
A
Level 1
N
Level 1
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.

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

10
A
Level 1
S
Level 3
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?  

00
P
Level 1
.
Level 1
.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

30
S
Level 1
.
Level 3
.1460040856Level 3
asked in General Product Q&A
i have a column that contains date and time , i want to increase the time by 5 hours 30 minutes for each cell what would be the syntax for that . thankyou

i have a column that contains date and time , i want to increase the time by 5 hours 30 minutes for each cell what would be the syntax for that . thankyou

00
florian.mrkvi
Level 4
N
Level 2
naoyuki.tomizLevel 2
asked in General Product Q&A
Login screen is power intensive

Every time I access Celonis login screen, my PC starts going crazy; CPU and GPU usage up +50%, draining memory and fan spinning like a jet engine. I am pretty sure it is caused by the fireworks animation that adds no value whatsoever.Once I pass the login screen and land to Celonis main screen, everything goes back to normal. So not a big problem. But it is kind of annoying that it happens every time I try to use Celonis first time in the day. Checked with my colleagues and they have similar experience.I only experience this kind of problem only for Celonis login screen. All other web sites work fine. Can you stop this animation please? It's not adding any value, in fact, it deteriorates our experience.

00
G
Level 8
G
Level 8
guillermo.gost12Level 8
asked in General Product Q&A
Where to get the planned roadmap of Celonis?

Where to get the planned roadmap of Celonis?  In particular I will like know more about the EOF of Action Engine, future of Skills, evolution and improvements in Action Flows, ...

20
G
Level 8
S
Level 1
siddhartha.ghoshLevel 1
asked in General Product Q&A
How can i license for snap+ as snap does not have full features

How can i license for snap+ as snap does not have full features

00
gabriel.okaba11
Celonaut
monica.marqu
Level 1
monica.marquLevel 1
asked in General Product Q&A
Oracle Cloud Extraction gives error for Invoices and PayableHi,When trying to do the extraction of the data (using the template for the Oracle AP Cloud Connector) I get this error for invoices and payables tables. Error Message in Details:

Error message:Error during extraction. Exception message: Unexpected character ('?' (code 63)): expected a valid value (JSON String, Number, Array, Object or token 'null', 'true' or 'false')at [Source: (String)"???<html class="gr__stbeehive_oracle_com"><head><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><metaname="description" content="____This_pod_is_enabled_currently____"><title>Unplanned Outage</title><style>html, body, div, span, applet, object, iframe,h1, h2, h3, h4, h5, h6, p, blockquote, pre,a, abbr, acronym, address, big, cite, code,del, dfn, em, img, ins, kbd, q, s, samp,small, strike, strong, sub, sup, tt, var,b, u, i, center,dl, dt, dd, ol, ul, li,fiel"[truncated 3308 chars]; line: 1, column: 2], body: ???<html class="gr__stbeehive_oracle_com"><head><meta http-equiv="Content-Type"

10
monica.marqu
Level 1
praveen.ojha12
Level 3
praveen.ojha12Level 3
asked in General Product Q&A
What are the ways to check which query is running in a transformation?

If a transformation has many Insert statement in the table. How can we know which insert query is running in the execution log if the transformation is running as a job.

00
.
Level 7
.
Level 4
.14600103626Level 4
asked in General Product Q&A
How can I show KPIs specific for a period and Same KPI from the beginning till now , side by side in same sheet

I am building an analysis.I have a period Filter :( YYYY-MM ) format.While I choose a Period I get to see KPIs specific to that period , but the requirement is , even if I select a specific period, same KPI should show me 2 different values , 1. For the specific period choses 2. KPI value since beginning till date , it should ignore the Period filter value chosen. These two Same KPIs to be placed side by side on the same screen. Can we do this ? If yes, then How ?RegardsAyan

30
.
Level 4
.
Level 1
.14600124133Level 1
asked in General Product Q&A
My original activation key with associated privileges and access rights was overwritten by some generic no privileges account when I went in 2 second time to sign up for your course work.

Can you restore my account to its original higher privileged and more useful/accessible account that used this Activation Key:6f1332ff-5b9a-471c-ac24-08b36d6dce21And this username: Reynoldsj@sysmex.com This inadvertent Training Membership Key:76f439aa-e45d-4288-89b7-dd7fe69de838seems to have overwritten my original account and now I'm a generic user, which is NOT what was intended nor what is useful to me. Thx! James Reynolds

00
L
Level 1
F
Level 3
florian.hoerl12Level 3
asked in General Product Q&A
HOW TO IMPLEMENT: selecting multiple entries from a dropdown should be more restrictive and not less restrictive

Hi all, Just to frame the use case: I have implemented the ML Workbench duplicate customer master data checker. Each customer can be flagged by none, one, or multiple duplicate search patterns.  Suppose I have 2 different search patterns A and B.  Further, suppose I have 5 customers: 1, 2, 3, 4, and 5. First, I have created a OLAP that has three columns (as can be seen in the attached screenshot):Column 1: The customer numberColumn 2: A simple case when flag, showing if the search pattern A identified the customers as a potential duplicate (1 = YES; 0 = NO)Column 3: Same as column 2 but for search pattern B  Now, I want to define a button dropdown / dropdown that lets me select none, one, or multiple search patterns and behaves in a certain way if are MULTIPLE entries are selected from the dropdown. If none is selected, all 5 customers should be displayed (i.e. all customers). (works fine)If one is selected, then only those customers should be shown for which the search pattern identif

20
E
Level 1
.
Level 1
.14600105143Level 1
asked in General Product Q&A
How to filter output from MATCH_PROCESS_REGEX(some statement). All the results with value=1 is expected. I am using CASE WHEN (MATCH_PROCESS_REGEX(some statement) = 1) THEN 'A' else 'B' END;However, it is not working. (error attached)Pls suggest

00
Z
Level 3
Z
Level 3
z.bLevel 3
asked in General Product Q&A
Need to export table data from Transformation Job by running SELECT statement.

Hi Team, I need your help.I have a table (T1) which has 5000 records. Wanted to extract all the records in CSV from the Transformation Job by the query (SELECT * FROM T1).Problem : In transformation job, I can only view 100 records.Also the table is not in the data model, so I will bot be able to create an OLAP table in the analysis and download the data. Please advice. Regards,JB  

00
Z
Level 3
A
Level 1
anshu.panwa12Level 1
asked in General Product Q&A
Hello everyone, wanted to know how to create a pie chart in views with help of YAML code?

Hello everyone, wanted to know how to create a pie chart in views with help of YAML code?

00
.
Level 7
M
Level 3
marco.messnLevel 3
asked in General Product Q&A
KPI Multiplication Error: OCR (optical character Recognition)

... we set up a custom process to analyse ourSoftware and evaluate its performance. Therefore we would like to "simply" multiply two KPIs. (Calculation a.) * b.)) However the calculation does not work. a.) (SUM (CASE WHEN PU_COUNT ( "BITMPT_OCRHIST_BATCH", "BITMPT_OCRHIST_SOURCE"."SOURCE" ) = 0 THEN 1 ELSE 0 END) ) / COUNT("BITMPT_OCRHIST_BATCH"."MANDT") (( b.) ((SUM(CASE WHEN PU_COUNT("Case_Invoice_Processing", "View ABBYY_Invoice"."AutomationState","View ABBYY_Invoice"."AutomationState" LIKE 'manual' ) > 0  THEN 1   ELSE 0END) /((SUM(CASE WHEN PU_COUNT("Case_Invoice_Processing", "View ABBYY_Invoice"."AutomationState","View ABBYY_Invoice"."AutomationState" LIKE 'manual' ) > 0  THEN 1   ELSE 1END))))))

00
.
Level 7
A
Level 2
anoop.singh.rajpuLevel 2
posted in General Product Q&A
We are trying to add same KPIs but with different filters on same column chart (side by side), but not able to do.

We are trying to add same KPIs but with different filters on same column chart (side by side), but not able to do.For e.g. we want to show number of emergency breakdowns for two plants, this will require to calculate same KPI but using a filter. Another example is to calculate downtime for two different type of work orders ( Emergency and Preventive maintenance). We want to show comparison in same chart with two columns.

21
.
Level 7

Badge winners

  • Qualified to Manage Implementation Projects
    maria.troyahas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Write PQL Queries
    danila.farinhas earned the badge Qualified to Write PQL Queries
  • Qualified to Build Action Flows
    danila.farinhas earned the badge Qualified to Build Action Flows
  • Qualified to Build Analyses
    danila.farinhas earned the badge Qualified to Build Analyses
  • Celonis Technical Expert
    danila.farinhas earned the badge Celonis Technical Expert
VIEW ALL
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Portal arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025