Skip to main content

AI

Ask questions and discuss using AI copilots, annotations, and machine learning tools for smarter automation and data insights.

  • 86 Topics
  • 301 Replies
86 Topics
utkarsh.rasto11
Level 2
utkarsh.rasto11Level 2
asked in AI
Option to schedule ML Notebooks not appearing

I am unable to get the option to schedule a notebook in my ML workbench.Does it require admin access to get the option?  Documentation says to have a valid executable file, which I have. Any code to be written in the notebook to make it eligible for scheduling?  

394
A
Celonaut
jan.tran
Level 3
jan.tranLevel 3
asked in AI
Does anyone have experience with Process CoPilot (and the built-in Python Tool)?

Hi all,I want to use the Process CoPilot with the built-in python tool in order to execute ad hoc calculations.https://docs.celonis.com/en/tool-activation.html#UUID-3c37cb75-0631-254f-a5b1-1a70ffd8d5f4_UUID-5523d1d0-d4b7-e2d3-4ebe-f999dffd6357and https://docs.celonis.com/en/tool-activation.html#UUID-3c37cb75-0631-254f-a5b1-1a70ffd8d5f4_UUID-b801ca95-08b6-fe38-c5c5-89bffe3f22aaI don’t understand the examples...My question:HOW can I implement this? HOW is the data going to be accessed and loaded in order to generate a dataframe? The examples in the docs don’t help me at all … Why is a df generated from a “KPI”? There is no relation between “get_data” output and the “code” …  HOW should I use get_data and python? HOW do these tools interact?Thank you in advance and best regardsJan  

360
jan.tran
Level 3
louis.forst11
Level 2
louis.forst11Level 2
asked in AI
Coding in the Academy Studio

Hi all, is it possible to code in the Academy Studio or not. For me it always show that there is no data model or data pool that i can use. Thanks for your helpbest regards Louis

182
louis.forst11
Level 2
sree.c
Level 4
sree.cLevel 4
asked in AI
Hello All, Is it possible to push user adoption table to a data model?

Tried with Python script to extract table from the web page, however it didn't work.

1310
marcel.kelle12
Level 2
D
Level 2
david.hunsaLevel 2
asked in AI
Are there ML examples in regard to prediction and simulation?

I just completed the "Comparative and Predictive Process Mining" course to learn more about ML capabilities, prediction, simulation, etc. I made an assumption that the example notebook/code that was shown in the video regarding feature recommendation and model training would be OOTB or readily available. I cannot find any examples on Celonis site or web. Are there examples for use or is it on us(me) to develop from scratch?

372
david.deans
Level 2
R
Level 4
rahul.bhat13Level 4
asked in AI
How to convert table from the datapool into pandas dataframe?

Hi Team,Im trying to convert the data i need from the datapool into a pandas dataframe for further calculation.In the documentation i could only find how to read the parquet files and convert into Pandas.Is there any way?Let me knowThanks 

570
K
Level 2
S
Level 1
srikar.akell12Level 1
asked in AI
Is there a way to get data of a table into ML workbench from schema, I know there is a way to do it by loading the table into a datamodel, is it possible to direcly get it from schema post extraction?

Hi all,I want to extract data from a table in the schema explorer, which is loaded via an extraction, the standard way is to do it is by loading the table into datamodel and pulling the data from the datamodel using pycelonis as mentioned in the pycelonis documentation I am curious to know if there is any other way to do it without loading the table into datamodel (via the schema explorer if possible)

160
S
Level 1
filippo.venut
Level 2
filippo.venutLevel 2
asked in AI
MLWorkbench: Data Push status: QUEUED

Hi all! First time here, but god a question. I am running a python script (pycelonis 1.7.6) that needs to push data into a table. Everything work fine unless the data push:  datamodel.pool.create_table(df_or_path = res,table_name = 'TABLE_NAME',if_exists = 'drop',column_config=column_config)  which returns: [2024-07-23 16:26:09] INFO: Data push job status: QUEUED...[2024-07-23 16:26:14] INFO: Data push job status: QUEUED...[2024-07-23 16:26:19] INFO: Data push job status: QUEUED...[2024-07-23 16:26:25] INFO: Data push job status: QUEUED...[2024-07-23 16:26:30] INFO: Data push job status: QUEUED...[2024-07-23 16:26:35] INFO: Data push job status: QUEUED...[2024-07-23 16:26:41] INFO: Data push job status: QUEUED...[2024-07-23 16:26:46] INFO: Data push job status: QUEUED...[2024-07-23 16:26:51] INFO: Data push job status: QUEUED...[2024-07-23 16:26:57] INFO: Data push job status: QUEUED... Same functionality on another table worked flawlessly, for this specific one it queu

30
S
Level 3
K
Level 2
keval.shahLevel 2
posted in AI
Hi Team,

Hi Team,I need assistance with building a Generative AI-based use case in Celonis. As a starting point to understand the various functionalities of Celonis, I aim to develop a basic chatbot system.Here’s where I need help:I want to create a view in Celonis that mimics the look and feel of ChatGPT, where I can ask questions related to the data and receive responses.I have successfully integrated OpenAI with the Machine Learning Workbench, but I’m not sure how to trigger the Machine Learning Workbench from my Celonis views using a button click and display the response appropriately.As I am new to Celonis, I would greatly appreciate a detailed explanation.Thank you for your help. TLDR : Help me understand to built the UI, where i can write in input box my query, on click the button i want to run my ml work book code and then show it as a text response on my views(my ml workbook has open-ai integrated)

91
K
Level 2
F
Level 2
federico.arribLevel 2
asked in AI
How to call ML Python from Action flow and receive a response

Hello everyone, I am trying to call a ML python script from an Action Flow with some parameters. Do some math with it, and give a response to the same Action Flow.Following the documentation in Trigger Machine Learning Script (celonis.com), I have been able to call the Python code, pass some parameters, process them and then call a NEW Action Flow. Is it possible to make the first action flow wait for a response and make a GET or something similar so you continue in the same action flow? Thank you,Federico Arribas. 

320
K
Level 2
carlos.vinti
Level 2
carlos.vintiLevel 2
asked in AI
How can I show the results of an ML component notebook to an Analysis UI?

I have read the documentation on the Run ML Notebook Component but I don't know how to publish the results of the notebook back to the Analysis UI. Is there any link to documentation that shows how to publish the results back on the Analysis? Do I need to use pycelonis or other python library?

50
carlos.vinti
Level 2
A
Level 4
akshay.haridLevel 4
posted in AI
Hi All,

Hi All,Earlier I had asked a question regarding how we can save/extract a table in our EMS as a csv file in our machine learning work bench, seeing the reactions or the lack of replies I got for the topic I think it would be helpful if I explain the code that I used/found to save the file as csv in my ML workbench. from pycelonis import get_celonisimport pycelonis.pql as pqlfrom pycelonis.config import Config celonis = get_celonis()data_pool = celonis.data_integration.get_data_pools().find("Datapool name")data_model = data_pool.get_data_models().find("Datamodel name")Config.DEFAULT_DATA_MODEL = data_modeltables = data_model.get_tables()table_name = data_model.get_tables().find("Table to find out")table_columns = table_name.get_columns()df = pql.DataFrame(  {    "column1": table_columns.find("column name in the table which has to be extracted "),    "column2": table_columns.find(" column name for column 2 "),    &quot

57
christophe.colin11
Level 2
A
Level 4
akshay.haridLevel 4
posted in AI
Hi All,'

Hi All,'In the past couple of days we are facing an issue in the ML workbench, while running a specific python code which is long and also complex , the kernel suddenly becomes unknown from the busy state due to which we have to rerun the code again from the beginning and this goes on happening as a loop ,we have raised a ticket regarding this to celopeers, but would also like to know if someone had faced this issue before.

74
A
Level 4
pablo.messa11
Level 3
pablo.messa11Level 3
asked in AI
PyCelonis Change-Log / Release Notes

Hello everyone, Is there a change log / release notes of PyCelonis somewhere? This would be very helpful to make decisions when to upgrade to a new version. Thanks a lot!Pablo

70
pablo.messa11
Level 3
pablo.messa11
Level 3
pablo.messa11Level 3
asked in AI
Debug log after upgrading to PyCelonis 2.6

Hello Community, today, we upgraded one of our ML Workbench to PyCelonis 2.6.Since then DEBUG informations are shown (see below). In the Jupyter Notebook we use: logging.getLogger("pycelonis").setLevel(logging.WARNING) If we execute the notebook on local computer, no DEBUG information if shown. On the other hand, if we execute it on the EMS, following DEGUB informations is shown: [2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagnostics/batch'[2024-01-31 13:39:56] DEBUG: Initialize Series.[2024-

30
janpeter.van.d
Level 8
pablo.messa11
Level 3
pablo.messa11Level 3
asked in AI
Return value of api_request changed?

Hello all,we are still using PyCelonis 1.7 and we figured out that since yesterday the response of the function "api_request" has been changed.Before we got a list / dict or string. Since yesterday we get a request.model.response object. Have you noticed that? Are you also having issues with your api_request calls? Our current workaround was to get the "text" of the response object. Like: resp.text instead of: resp

00
pablo.messa11
Level 3
R
Level 4
raman.silot14Level 4
asked in AI
No notebook selected

Hi  I want to execute ML notebook using run_ml_notebook component in analyses but ML notebooks are not visible Is there any additional configurations required to be done ? Thanks 

20
mateusz.dudek14
Level 7
jonas.schei12
Level 3
jonas.schei12Level 3
asked in AI
PyCelonisPermissionError: You don't have permission to perform 'GET'

Hi all, I want to pulling data from a knowledge model through the following code ... space = celonis.apps.get_spaces().find('Default')package = space.get_packages().find('Knowledge Model Test')knowledge_model = package.get_knowledge_model('999-automation-rate-bw-download')content = knowledge_model.get_content() But I get the error "PyCelonisPermissionError: You don't have permission to perform 'GET' ", even I have set all possible permissions (for "Space" / "Package / "Analysis").Any ideas which permissions are missing. Unfortunately the article below does not help me here. Thanks in advance,Best,Jonas 

420
jonas.schei12
Level 3
A
Level 4
akshay.haridLevel 4
asked in AI
Is it suggested to make a backup workbench or a new workbench ? If our current workbench is corrupted.

Is it suggested to make a backup workbench or a new workbench ? If our current workbench is corrupted.

00
B
Level 1
C
Level 3
conny.brintLevel 3
asked in AI
PQL query fail

Hello, I have the following problem when PQL query tables from my analysis (PyCelonis version: 2.5.0): After identifying the required space, package , analysis and sheet, I specify the required table:olap_table_HistoricPOs = published_sheet_OpenPR.components.find("#{Historic_POs}", search_attribute="title") ... and query the table:olap_query_HistoricPOs = olap_table_HistoricPOs.get_query()olap_query_HistoricPOs Some columns are read correctly:(name='_CASE_KEY', query='"freitextbestellung"."_CASE_KEY"')and others are not. These get a hash and a brace like this:(name='#{order_items.SUPPLIER_NR}', query='"order_items". "SUPPLIER_NR"') This incorrect naming is kept in the subsequently created dataframe:df_historic_POs = pql.DataFrame.from_pql(olap_query_HistoricPOs, data_model=data_model) and leads to an empty df in the further notebook:df_references = {}df_references['historic_POs']= df_his

20
C
Level 3
C
Level 3
conny.brintLevel 3
asked in AI
How can I pull an OLAP table into the ML bench?

Hi there,I would like to pull an OLAP table component out one analysis sheet into the ML bench If I try this way by ID it works:components = sheet.componentscomponent = components.find_by_id('Component_ID_Here') But I would like to import the table by name as the component ID might change.So I tried this but it does not work.:components = sheet.componentscomponent = components.find('Table_Title_Here') Hope you can give me a hint. Best,Conny

20
C
Level 3
A
Level 4
akshay.haridLevel 4
posted in AI
Hi All,

Hi All,I wanted to share an issue with you guys regarding the ML app we had in our server in which the app was automatically changing it's python package versions despite of whatever desired versions of python packages we install. Then we figured out that if the ML app had a file named virtual environments and in it's metadata if the versions are already set , no matter what ever desired versions of python packages we install it automatically changes it's version to the one mentioned in the metadata of that virtual environment. The reason for this is that the workbenches where virtual environments were used usually become corrupted and inaccessible. Files will not be recoverable if a workbench is corrupted.  The only way of resolving this issue is creating a new ML app and backing up the files in the current workbench (Excluding the virtual environments) and restoring them to a new workbench. This will ensure your data is protected from possible corruption. For more inf

01
A
Level 4
R
Level 4
rahul.bhat13Level 4
asked in AI
Create the table in Data job

Hi Team,I am trying to create a table in a specific data job before which i have done some calculations using pandas and i want to perform SQL using that table in the datajob.But the tutorial gives the datapool create tables and i am not able to access it in Datajob i need.Is there any way to do this?When i force the data_source_id while creating the table in data pool, it gives an error saying it cannot find that table and source id.Please let me know if there is a way.Thank you

20
R
Level 4
R
Level 4
rahul.bhat13Level 4
asked in AI
Is it possible to retrieve data from Datapool tables into Pycelonis?

Hi Team,I am trying to retrieve the data received from the data connection in a table to machine learning workbench to do some manipulations and write it to another table in datapool.Is it possible?I have tried so far . data_pool = c.data_integration.get_data_pools().find(<pool name>)a=data_pool.get_job(<job id>)b=data_pool.get_table(data_source_id=<sourceid> name=<table name>) But from here i am unable to get the function get_data_frame. Is there any other way?Please let me know.Thank you

260
R
Level 4
J
Level 2
josep.cunquLevel 2
posted in AI
Hi all,

Hi all,has anyone had problems when triggering a Jupyter Notebook from an Action Flow? I cannot even trigger the template provided in the educational page. It is puzzling because the POST requests succeeds with code 200 - so I assume that all required fields are correctly filled - yet the Notebook is not executed, it does not produce any output. I have tried to move the Notebook across folders and apps, to no avail. Anyone else had the same problem? Attached is the POST output (maybe the problem is that the ML notebook is QUEUED? but how would I solve it anyways?).

00
J
Level 2

Badge winners

  • Qualified to Manage Implementation Projects
    maxime.consthas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Write PQL Queries
    elena.minchhas earned the badge Qualified to Write PQL Queries
  • Qualified to Build Action Flows
    elena.minchhas earned the badge Qualified to Build Action Flows
  • Qualified to Build Analyses
    gauri.pai11has earned the badge Qualified to Build Analyses
  • First Post
    Suveesh_adessihas earned the badge First Post
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center 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