General Product Q&A

How to set auto increment field while creating table in celonis sql, since identity is not working

trying to make a connection between Oracle EBS and Celonis and I'm getting an error. Need your assistance

Hi, I have acess to celonis partner portal but I am not able to acess https://persistent-systems-sandbox.demo.celonis.cloud/ui/login . Please help me to access Sandbox. My email id is manpreet_rekhi@persistent.com, provide instructions

I'm looking for the use cases using machine learning functions in the Celonis. Could you please share the information?

how to find detail error message by support ID, it takes time to open a ticket to support time every tie.

I would like to keep a KPI analysis and transformation center chart on the same page. Is it possible to have some sort of iFrame, or view to transformation center in the Analyses? Or perhaps a Studio View?

I couldn't find any training tracks for Process Improvement. I have checked under the Categories > Process Improvement. Thanks

Throws this error:Data model load failed during table export: Data model tables could not be exported: O2C_VBRP, O2C_MARC, O2C_KNKK, O2C_VBUK, O2C_VBUP, O2C_VBFA, O2C_VBAP, O2C_KNA1, _CEL_O2C_ACTIVITIES, O2C_KNB1

I have logged into C4C+ and also invited a few of my colleagues. We intend to start a new project shortly.However, I am unable to navigate to the "Team settings" so that I can assign roles to my team members. I dont get the link to Team settings at all!

According to internal Accenture resource, once the engagement is completed, all the instance is decommissioned due to its policy. But we would like to retrieve deleted instances in the following link.  Is this possible? If so, what is the process? The link to the aforementioned environment:https://accenturepts.us-2.celonis.cloud/process-mining/ui?workspaces=f0b0621c-14ea-4f2a-b025-44965f21d257

I want to know more about the cost of your product.

Hello, I would like to calculate a market share by country in a simple table. Problem : i have column 1 : Country, column 2: sum(invoice), column 3: market share by country but i it take the sum just for the country and not the sum of all of it

The following code block was used to connect machine learning workbench to Celonis data models. The code worked for a long period of time until recently it returns an error. Anybody has an idea?  pip install --extra-index-url=https://pypi.celonis.cloud/ pycelonis --upgradefrom pycelonis import get_celonisfrom pycelonis.pql import PQL, PQLColumn, PQLFilter ------------------------------------------------------------------------------------------------------------------------------------------------------ImportError Traceback (most recent call last)<ipython-input-9-175b2f233f28> in <module> 1 from pycelonis import get_celonis----> 2 from pycelonis.pql import PQL, PQLColumn, PQLFilter ~/.local/lib/python3.7/site-packages/pycelonis/pql.py in <module> 4

I need to setup a data push to the API, but I'm not able to find how. I only have a tech. sheet saying that this is possible. Regards,

Hi There,  I would like to get Average throughput time between activity A and whatever activity coming after A. For example;Case 1 / Activity Sequence: A->B->C->D->A->ZI need the sum of throughput times case level (A->B) + (A->Z)I also need number of occurrences of A case level (2)..Finally my resulting KPI formula will be like;Total throughput time (A and next activity) / Total Number of Occurrences of A How can we make it happen in PQL? Thanks in advance, Best Regards,Oguzhan    

In the attached photo, the number of cases is duplicated and counted.I want to know the PQL that solves this.

I have gone through the explanation in documentation, but didn't find it to be detailed enough. Can somebody please explain with certain examples ?

Ready to seize unlimited opportunities?Visit the EMS Marketplace from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners.Visit the EMS Marketplace or find your team. Recently Added: IBM work order management for manufacturing IndustryWork Order Management application provides an operational dashboard to monitor, plan and streamline the end to end lifecycle of a work order, Identifying bottlenecks and processing differences based on various dimensions for continuous improvement and faster lead times, digitally transforming the work order process to improve data quality and reporting & providing automation for faster fixes. IBM record to analyze month end close:

Some times working fine and some times getting below error  Change log extraction failed!. Change log strategy not specified. Celonis Support ID: 889395d9-5218-4e84-a325-da537c6a4aa5

I have a question - how does the function "having" work in Celonis PQL? I need to select case where Count(Activities)>3. How can i do it is Celonis? Thank you so much!

Dear all, I have checked with Coupa and Oracle both connectors, its shows the below error. How to resolve these issues. Thanks Regards,Jayaraman.M

Good evening guys,I would like to calculate the total throughput time of a sub process which can occur multiple times within one case. The subprocess always starts with a unique activity and ends with a unique activity. There might be different activities between the start & end activity (see picture). I tried my best by using the MATCH_PROCESS_REGEX function but didn't succeed. Thanks a lot for any hints and suggestions! Cheers,Alex 

Hi all,  I am trying to transform the data from multiple excel files into a single activity table but while I am transforming the timestamp field. it shows the error below:Execution error: ERROR: Column "_EVENTTIME" is of type timestamp but expression is of type varchar When I upload the file I have already indicated the field as DATETIME field Therefore i am not so sure about how this went wrong, appreciate your time and help in advance!

How to create bar chart and line chart in Celonis as the way we create in excel with secondary excess.

Where i can find Celonis Analyst training ?