Skip to main content

AI

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

  • 90 Topics
  • 322 Replies
90 Topics
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

61
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

80
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

490
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
C
Level 3
christoph.schus12Level 3
posted in AI
Hello all,

Hello all, I would like to send an xlsx file as an e-mail attachment. The file is generated by a Python script in ML Workbench. Due to the formatting of the xlsx file, it is not possible to load this file into the data model without further ado. Is it still possible to send the file automatically, e.g. via an action flow or skill?  Best regardsChristoph 

22
G
Level 8
R
Level 4
rahul.bhat13Level 4
asked in AI
Add_Table_From_Pool deprecated in 2.x?

Hi,Im trying to add a table from Datapool to datamodel and i found this function, add_table_from_pool in the release notes of 1.5Now when i try its not present. Is this deprecated?If so, are there any alternatives?Please let me know. Now the error: 

20
R
Level 4
S
Level 2
sameer.hardiLevel 2
asked in AI
Getting pool versions using python

Hello All,   I want to use pycelonis to get all version of data pool (including Draft if present) The below code does not not show data pool version    data_pool = celonis.pools.find("XXXXXXXXXXXXXXXX) print (data_pool)  Output: <Pool, id XXXXXXXXXXXXXXXX, name 000_Extraction (000_CELONIS_DATA)>   Is there any way i could get the data pool versions? 

110
G
Level 8
Z
Level 3
z.bLevel 3
posted in AI
Hi Team,

Hi Team, Can you please help me with the code to extract Knowledge Mode Record information using Py Celonis.I checked the PyCelonis documentation but was not able to get the same. Thank You in advance. Regards,JB

11
matt.witty13
Level 5
S
Level 3
siddhesh.naik11Level 3
posted in AI
Can anyone help me with the code for creating CLI profile?

Can anyone help me with the code for creating CLI profile?

45
G
Level 8
A
Level 2
anurag.jha13Level 2
asked in AI
API Request to using PyCelonis.

Hi,I am trying to send API Request using the api_request() function but i am getting this RetryError. Can anyone please explain how to tackle this error. 

10
R
Level 4
R
Level 3
rahul.bhat11Level 3
asked in AI
Connection to pycelonis after 2.0 upgrade

Hi,I am trying to connect to pycelonis from my local system to IBC .It was possible with all the required values when it was 1.7.4But after the upgrade to 2.0 , we are getting a getaddrinfo errorIs anyone else facing such an issue?If so, What needs to be done.Let me knowThanks

230
R
Level 3
C
Level 3
christoph.schus12Level 3
asked in AI
Load Data Model & table

Hello all, How can I output the data model with a python command in the pycelonis package? in pycelonis 2.0.0this was done with the functionspool = celonis.pools.find('my_datapool')dm = pool.datamodels.find('my_datamodel') In pycelonis 2.0.1 this doesn't seem to work anymore.I get the data pool via:pool = celonis.data_integration.get_data_pool(celonis_pool_id) but how do I get the data models and the tables they contain? Many greetingsChristoph

70
G
Level 8
M
Level 3
maryam.tahmoLevel 3
asked in AI
Is it possible to visualize the ML code in EMS

Hello all, I want to know if is it possible to visualize the output of PyCelonis in EMS. For example, if I have any diagram in Python, I can show it in the EMS environment?Thanks

20
S
Level 2
R
Level 3
rahul.bhat11Level 3
asked in AI
Does upgrading a workbench app in Machine learning upgrades all apps?

Hi All,I want to upgrade a single workbench app in Machine learning.I do not want to disturb any other app present in the the workbench.Is it possible to do it?Please provide any documentation if present. 

10
R
Level 3
M
Level 2
marco.valliLevel 2
posted in AI
I'm getting an error when trying to add a table to a data model

I'm getting an error when trying to add a table to a data modelThe main problem is: it was working last week and, when I tried to re-run today, I got the following error: HTTPStatusError: Client error '400 Bad Request' for url I dont know what could be triggering it, specially because it was working before and I didn't  

52
M
Level 2
C
Level 2
christian.huppeLevel 2
posted in AI
Migration script for instances

Migration script for instances Is there a pre-build python script to move data pools, spaces and analyses from one celonis instance to another?  BR,Christian

71
.
Level 5
M
Level 2
max.schulLevel 2
asked in AI
Datamodel access via PyCelonis 2.0.0

I have a question regarding PyCelonis 2.0.0. It looks like any means to access data (from a datamodel) and use it with a data frame were removed from the package. Is my assumption correct? If so, how would you implement something like an "invoice duplication" app with Python in the ML Workbench if it is impossible to get the data? Thanks

10
M
Level 3
R
Level 3
rahul.bhat11Level 3
asked in AI
Hi All,Is there any way to access the data and display it from the tables from the datapool in the Machine learning module and later do some queries and push it back into the datamodel?

There is a method to push data into the datamodel, but i could not find any that can access it.Please let me know if anymore details are needed.Thank you 

80
M
Level 3
irfan.suria12
Level 4
irfan.suria12Level 4
asked in AI
Hi all,is it possible to execute/run an existing data integration schedule via python?

It is already possible to execute data jobs and data models. But I have not found anything for schedules in PyCelonis Docs. The reason I want to do this is to distinguish between an automatic execution via DI/Python schedule or a true manual one with a "real" user behind. If I execute a data job via Python, it will be shown as "Manual Execution" in the logs. Best regardsIrfan

70
irfan.suria12
Level 4
irfan.suria12
Level 4
irfan.suria12Level 4
asked in AI
Which API/objects can I use to create Action Flow modules via Python?

I have a huge table in an analysis that I want to rebuild with a query data module in Action Flows. Obviously, this would require a lot of copy&paste as there is no feature yet to automatically create a query data module from an OLAP table, similar to the feature that exists for creating an Action Engine skill based on an OLAP table. Now, I want to leverage the MLWB for it. With analysis.drafts.components("table").pql_columns I was already able to get all the column names and their respective pql-queries. How can I transfer them to the action flows?

20
irfan.suria12
Level 4
S
Level 3
saravanan.gopalLevel 3
asked in AI
Hello All,I am working on python code to get the last updated date for tables across multiple Data Models. I am facing an issue while passing the Variable to Filter.Please share your expert opinion ont this topic.RegardsSaravanan.G

30
janpeter.van.d
Level 8
S
Level 3
saravanan.gopalLevel 3
asked in AI
Hello All,I am trying to get details of table from data model directly using Pyhton. Where I need to retrieve the few columns for the last 7 days based on a date column (example: ERDAT > TODAY() -7 ).

Tried using PQLFilter but could not achieve this.

00
S
Level 3
F
Level 1
florian.mansfLevel 1
asked in AI
How can I get the connections from the process explorer/process graph via Python?

I have found two ways to get the activities via python. But I need the connections betweens them. I can check for all activities wether they have a connection to each other but with the complexity of O(n²) thats very inefficient and costs a lot of time for complex processes with many activities. Is there a more efficient way to get the connections?

10
T
Level 1
irfan.suria12
Level 4
irfan.suria12Level 4
asked in AI
Which permissions does an application key need in order to access the objects in Studio (Views, analyses, etc.)?

I have given my App Key the following permissions:Space permissions: Use all packagesPackage permissions: Use packageAnalysis permissions: UseData Pool permissions (of the analysis): Use all data models celonis.spaces.find("Space123") works nicely, but then space.pockages will return an empty list. Consequently, space.packages.find("Analysis123") would not work. Which permissions do I miss? Cheers

50
D
Level 1
.
Level 2
.1460138Level 2
asked in AI
Getting below error while creating RCA using Machine Learning workbenchAttributeError: 'NoneType' object has no attribute 'source_name'Please help us reslove this error

from pycelonis import get_celonisfrom pycelonis.root_cause_analysis import root_cause_analysis celonis = get_celonis() dm = celonis.datamodels.find('c4cb1efc-fa6a-4704-bc51-b3b365c5e796') kpis = {'late_payment': """      CASE WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear Invoice')=0        AND         DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" =       'Create Purchase Order Item'), TODAY()) > 0       AND        DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" =       'Create Purchase Order Item'), TODAY()) <= 60       THEN NULL       WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear I

10
G
Level 8

Badge Winners

  • Qualified to Build Views
    ebru.ulashas earned the badge Qualified to Build Views
  • Qualified to Build Views
    irem.dinçhas earned the badge Qualified to Build Views
  • First Post
    Akshay Hhas earned the badge First Post
  • First Post
    Damianhas earned the badge First Post
  • Qualified to Deliver Business Value with Celonis
    Graham Holmeshas earned the badge Qualified to Deliver Business Value with Celonis
VIEW ALL
Community Code of Conduct