Product Q&A

We would like to automate permission management via PyCelonis. Is there a way to grant access to a package for a group or a user via PyCelonis? Thank you 

Hello everyone, I want to calculate the average delivery time and I chose to do this by calculating the throughput time between activity A and activity B in Studio with this formula: AVG (  CALC_THROUGHPUT (    FIRST_OCCURRENCE [ 'A' ]    TO    LAST_OCCURRENCE [ 'B ] ,    REMAP_TIMESTAMPS ( "ACTIVITIES"."EVENTTIME" , DAYS )  )) However, Celonis warns me that >> The aggregation function AVG is applied on a column from table "_ACTIVITIES_CASES" which has a 1:N relationship to the common table "ACTIVITIES". << Could anyone tell me what causes this and how I can make sure that there are not multiple entries sabotaging the average? Thank you very much in advance!

sir can anyone please help i didn't get my reattempts so please help me

How to collect badge

I am unable to get a reattempt. Kindly help me getting reattempts to complete my certification.

Does anyone have experience in connecting to Ivalua? Wondering what accelerators and prebuilt connectors exist.

Hi everyone,  I'm trying to recreate code for uploading celonis user list by using Pycelonis 2.0+ version, and I've got few questions: A) Do you know how to properly update packages in Jupyter Notebook/ML workbench environment? I've always used just "!pip install --upgrade pycelonis", command "!pip show pycelonis | grep Version" show me newest version isntalled (2.6.0 as for today), however when using PyCelonis I still see message about old PyCelonis version:  Using command mentioned in the logs itself also don't change nothing (also with '!" added in front).  For Celonis guys: it would be good to add it to PyCelonis documentation and maybe changing message text for a working one :) B) When I'm trying to upload file in simplest scenario (no config) I see that data push job is created but cannot be executed successfully, unfortunetly googling error itself doesn't help much (seems to be some old JAVA error)  Data push logs: Error itsel

What are the prerequisites, benefits, pros and cons of using multi event log to integrate two processes

How can an order be matched with an invoice in SAP? In other instances, the amount on the order is not the same as the amount in the invoice.

HI Community, I have created some views on Celonis Studio and published. But these views are not visible on Apps. Do you know what could be the possible reasons for it?

For the following AP KPIs, is there anyone who knows the definition (formula) for each KPI. And in which Apps where can I find the KPIs.・Collection Effectiveness Index・Accounts Receivable Turnover Ratio・Average Days Delinquent・Days Sales Outstanding (DSO)

I use PyCelonis to get Data as follows: analysis = celonis_manual.analyses.find()sheet = analysis.draft.sheets.find()component = sheet.components.find()df = component.get_data_frame()But sometimes get_data_frame() doesn't work and i get the following Error:  Exception: Export failed. Status: {'id': 'aab0d447-a0d5-419d-b25d-36ee3d504b71', 'exportStatus': 'FAILED', 'created': 1702286071091, 'message': 'Encountered " "(" "( "" at line 1, column 10.\\nWas expecting one of:\\n ")" ...\\n "||" ...\\n ', 'exportType': 'PARQUET'}  I dont understand why as the Tables do not seem different from the ones where it works. Im working in pycelonis 1.4.1.  Any help would be greatly appreciated.  Thank youGina

Hi Community, I am trying to create a view, which has 2 different components(Tables/Charts) with different knowledge models behind it. I have created 2 separate knowledge models, but was not succesful referincing them on the same view. Does anyone has experience building components withdifferent knowledge model on the same view?  Best Regards, Sooraj

I've built a simple variable with static value. If I enter in the code editor, it shows a value (like 3.05, that is fine), but if I exit, it shows me NULL, and in the analysis it follows the NULL behaviour, creating lots of messes. I don't understand why it is happening, since if I try to fix it, it shows me the correct value.I can't replace it in the formula of the KPI, since I'm calculating a static QUANTILE value to be compared which every row of a table, if I put it directly in the formula it tells that I can't use aggregation function etc etc...

Does anyone know anything about Extract display value columns?They are displayed in General under Extractions in DataJob.

In marketplace , we are seeing Concur connector, but while installing it it not showing any transformation scripts and Data model. Any help?

How do i access the Partner Performance?

The rescheduled date is sometimes null and in some cases there is an entry, hence the whole module should not stop once the date is null.

Hi folks! I'm trying to get the attributes of shipment activities in the VTTK, but when I link the VTTK through the VTTP in the Datamodel. I have the following error message "Not common table" Do you know how to handle this?

Von: Karl-Friedrich Löschhorn Gesendet: Freitag, 8. Dezember 2023 12:05 An: partnerportal@celonis.com Cc: Marco Poloni <marco.poloni@paw-systems.com> Betreff: How to become a Celonis Partner? Priorität: Hoch Sehr geehrtes Celonis Partnerportal Team,  im Namen der People at Work Systems AG bewerbe ich mich um den Zugang zu Ihrem Partner Portal.Wie kann ich Celonis Partner werden?Was ist das am besten geeignete Partnerprogramm für unsere Organisation?Gibt es einen strukturierten Anmeldeprozess und wo finde ich diesen? Im Marktsegment „Travel and Transportation” gibt es mit der Deutschen Lufthansa AG bereits einen gemeinsamen Kunden mit einem gemeinsamen Projekt. Informationen über uns finden Sie unter www.paw-systems.com Ich freue mich auf ihre baldige Rücksprache. Mit besten Grüßen Karl-Friedrich LöschhornVice President|Business DevelopmentPeople at Work Systems AGFeringastraße 10 AD-85774 Unterföhring Tel:       +49 - 89 - 540 42 45 - 0Fax:     +49 - 89 - 540 42 45 - 11Mobil:  +

We are trying to build a profile view where we are trying to add a date picker into it, but we are unable to find any date picker component in Views as we have it in Analysis. How could we add a date picker in Views? Please assist with this question.

Good morning, I am looking for a way to convert a BLOB field (i.e. a long varbinary in vertica sql) into a string, in order to capture a hidden information. Is there a way to do this conversion? I am not finding anything in the documentation, except for the question in https://www.celopeers.com/s/question/0D50700000lQGtPCAW/converting-from-binary-to-string-in-ems?language=en_US . Thanks

Unable to find Link to Level 2 and Level 3 courses

why do we only see 33 attributes in the KM and when opening the Record we see 79?

Is the process explorer customizable in such way that in addition to the number of activities per process step, the automation rate of each step will also be shown. Is this possible or has anyone tried to implement such a requirement?