AI

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

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. 

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  

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

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

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 

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

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?

Tried using PQLFilter but could not achieve this.

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?

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

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

 

Please find below attached error snap 

getting this error

I get the following error when setting up DegitalTwin in Simulation.What kind of time format should I use so that Celonis can read it correctly?​Error Message​Timestamps are rounded at the Eventday. This could cause problems to the Digital Twin Extraction, please check your Data Model and include the hours and minutes in the Timestamp columns of the data model.

Good morning, Recently, at Solvay, we've been trying our hand at using Celonis' Data Deduplication ML solution Now we've reached a point where we want to further customize it, which means we need to understand what is behind it! For example: Here, in point 3), it is mentioned that common scanning errors in Invoice References will be checked like "8" <-> "B".  Is it possible for me to see (and modify) the list of Similar Characters? How do I access / change this code? Thank you in advance! Best Regards, Vasco Carona, Solvay

Hi celonis team, I am looking at the APC reduction script documentation posted in the partner portal. However, i am unable to find the App Store Filters.xlsx file that is required for me to complete the python script. The documentation says Download the attached excel file., however, i cannot locate this in the word file or the download loaction " Celonis Partner Portal". Could you help me as we require this for a client project. Thank you.

Hi Team , I am trying to connect with Oracle Database from Celonis ML using cx_Oracle python Package but getting error as : cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: libclntsh.so: cannot open shared object file: No such file or directory. See https://oracle.github.io/odpi/doc/installation.html for help . Any help or information about this would be highly appreciated . Thank You, Amruth Muddana

Dear Team, similar to what someone has previously posted I am also following the ML Training and am receiving an exception saying that I am either missing the correct permissions to query the datamodel or that I havent loaded them correctly. Neither seems to be true, because I set all permissions as required and I cross-checked that the datamodels have been successfully loaded. Could you kindly help me out on this one, please? ! Screenshot is attached, my training environment is: Process Data Models | Event Collection (celonis.cloud) Exception|690x359

Hi All, Am currently working on ML. Can I get the sample Dataset for the ServiceNow or SAP Applications ? Br/VM

Hello, All. We were working on the examples that once you published your ML suite website. Such as, Anomaly Detection, Duplicate Payments, Root Cause Analysis However, yesterday when I visit the website I couldnt find the samples. Coul you please let me know where can I find them? Since we are trying to adapt those logics into our P2P and AP processes. Thank you! Latife

Hi, is there a way we can use the python API to find and replace field names specified in PQL within an analysis? For example, Im linking an existing analysis to a new data model and some of the field names differ slightly e.g. BSEG.TS_AUGDT is now BSEG.AUGDT. Is there a way I can easily update the PQL to use the new fieldname definition via the API without having to update manually via the front end?

Hi Team , Is there any simple way to write a PQL query for select * from table name in celonis ML for get_data_frame(query). As of now we need to add all the column names separately one after the other PQLColumns(). Any suggestions would be helpful. Thank you Amruth