Success Hub
Product Updates
Groups

Home
Community
Product Q&A
AI

AI

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

86 Topics
301 Replies

When you subscribe we will email you when there is a new topic in this category

86 Topics

Most replies

Most views

Newest first

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?

404

2 months ago

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-f999dffd6357 and https://docs.celonis.com/en/tool-activation.html#UUID-3c37cb75-0631-254f-a5b1-1a70ffd8d5f4_UUID-b801ca95-08b6-fe38-c5c5-89bffe3f22aa I 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 regards Jan

370

3 months ago

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 help best regards Louis

182

4 months ago

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.

1410

5 months ago

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?

382

6 months ago

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

640

7 months ago

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)

180

8 months ago

filippo.venutLevel 2

asked in AI

MLWorkbench: Data Push status: QUEUED

keval.shahLevel 2

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)

111

9 months ago

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.

410

9 months ago

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?

11 months ago

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_celonis import pycelonis.pql as pql from 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_model tables = 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 "), "column3": table_columns.find("column name for column 3"), } ) pandas_df =

akshay.haridLevel 4

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.

104

1 year ago

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

1 year ago

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-01-31 13:39:56] DEBUG: Request: 'POST' -> '/pql-language/api/lsp/publishDiagno

1 year ago

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

1 year ago

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

1 year ago

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

akshay.haridLevel 4

conny.brintLevel 3

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_historic_POs df_references['historic_POs'] print(df_references['historic_POs'].empty) True The

1 year ago

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.components component = 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.components component = components.find('Table_Title_Here') Hope you can give me a hint. Best, Conny

1 year ago

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

1 year ago

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

1 year ago

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

josep.cunquLevel 2

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?).

1 year ago

Page 1 / 4

Badge winners

yuri.fujimhas earned the badge Qualified to Manage Change and Scale Adoption
samer.odehhas earned the badge Value Realization Expert
samer.odehhas earned the badge Qualified to Manage Implementation Projects
zayneb.alsum11has earned the badge Value Realization Expert
zayneb.alsum11has earned the badge Qualified to Deliver Business Value with Celonis