Product Q&A

I'm a developer and I want to learn about the coding aspects of celonis rather than the analyst courses. Can any of the celopeers please suggest to me the courses for that? Thanks in advance😄

Our jobs are running on SSMS. So we are planning to trigger Data model on Celonis after the job is completed using a shell script. I would Like to know if this is possible? Or if there is any other way to trigger the Data model after our job is done?

We have a high interest and demand in the market to use & implement Celonis for helping the clients in migrating to S/4HANA. I reviewed the frictionless system migration (S/4HANA) webinar. it was useful and insightful, it also showed how Celonis can support their clients throughout the different migration phases.  As stated, in the design phase that Celonis can help in Master data consolidation, Testing, and data transformation. but unfortunately, it wasn’t stated exactly in details how can Celonis help throughout the migration in the previously mentioned areas. Thanks in advance.

Hi, We want to calculate process conformance as a KPI in the OLAP table for each company codes, markets etc as dimensions. Two years back Celonis team showed us that this can be done by opening process conformance analysis -> press F12 and then scan the browser logs for certain keywords and use some part of the logs into the OLPA table KPI editor.However, I dont recall all the steps but would like to understand if someone can share these steps again that would be really helpful. We have 4.6 on premise setup. PS: Tried using CONFORMANE PQL syntax but this proved way more difficult given complex process model design. Regards,Amogh

Do we have cases for Planning & Budgeting Process in Finance?

I am completing a training exercise in the My Exercises Studio and it is not allowing me to get additional options when I R Click on the sheet name

I am trying to create a dashboard or just an olap table in which I can see the open items that will be becoming due in the next few weeks (1 to 3 weeks). My question is how to create a formula that gives me that based on today’s date (not on a fix date), as my expectation is that tomorrow a new set of invoices is displayed based on tomorrow’s date. Data Model B2Cnet due date already in the data model BSEGMERGED table https://bosch.eu-4.celonis.cloud/package-manager/ui/views/ui/assets/fe6ad3d2-c14b-4470-82bc-89f486af4559#!/documents/fe6ad3d2-c14b-4470-82bc-89f486af4559/view

Have a KPI viz. Average Throughput time and I want to give a selection option for Percentile (50%, 80%, 90% & 98%). How I can do that?

Looking to improve "right party contact, conversion rate, abandon, etc."

Hi Can someone please help with PQL script to calculate duplicate invoices

We are trying to load the out of the Box OTC model. We have successfully completed - the Full Extraction Job ,the full Transformation Job,The Create data model view Job When we schedule the data load of the data model its failing with the following errorsData 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

how to register for certification program

I want download 2022-01-13-JDBC_Extractor_Package.zip to verify connection with onpremised system. I tried download this URL, but I get only downlaod.html.https://academic-*****.eu-2.celonis.cloud/help/display/CIBC/Downloads+and+Version+HistoryHow can I get JDBC_Extractor_Package.zip?

Hi, I have a data table that has 3 columns: -, 0, 1with a load of data rows below them. How do I go about calculating the total percentage for each column? I would potentially want a KPI in my dashboard that immediately tells me0 = x%1 = y%- = z% thanks,Terence

I would like to know where I can find it and if it is possible to install Task Mining on MAC machines? Where can i find the installer?

Is it possible for an user to retrieve a signal that has been resolved? In other words getting the signal back in the signal list from the history section.  Use case: end users are completing signals, but if/when they mistakenly resolve the signal they would like to retrieve it back to the signal list.  Best,Selma

My data-model is loaded twice a week: currently a complete reload from source is done for all tables on Monday and Thursday.I would like to exclude one given table from the Monday reload, because this table is empty at this time, due to the process.I did not find any option to do that. Do you confirm?The Celonis version is 4.6 (on premise)Thank-you for your supportJulien

There are challenges in getting data again from customer.

Hi, the link "Please reload and link the data models as stated in this guide" leads to a protected google drive ressource and is therefore not available (I requested access with my gmail account, but nothing happened the last days)What needs to be done?Thanks in advance!

Hi all, First post here. Pleasure to meet you.  I just finished the Solution Professional Track and would like to start taking the exam soon, but one thing striked me as curious.  Except I have been missing it, VSQL was not included in the training except the "Best-Practice" module. That was like being thrown into the cold water, since I do not have a technical background. The Exam Prep mentiones SQL knowledge as prerequisite for the exam.  Since the academy does not seem to provide for a course, is there anyone who could tell me the depth which is needed to pass the exam and where I could learn that (i.e. youtube)?  Ideas would be appreciated. If someone is willing to do a personal exam prep and offers on fiverr or similar, feel free to shoot me a message. Best wishes  

Hi all,we are currently playing with Pycelonis in our CPM environment.The main use case will be the automatic export of OLAP tables already prefiltered with PQL Filters we are using in the Python Scripts.So far we managed to implement most of the PQL Filters we need.Now we want to extract data of a table that contains cycle times based on activities the users are able to select themselves within the analysis. So via dropdown that is wrinting the selected activity into a variable. With Python we now want to extract this table setting a specific activity into a variable before extracting the data, in order to get the correct cycle times. So far I haven't found a way to update/overwrite the variables current value with the activity name we want to use.The Pycelonis documentation is ok but in my opinion not giving so much information and examples than the basic stuff. Thank you very much in advance.

Dear All, I would like to upload a JSON file in Event Collection which contains key:value pairs that are filled with dates. I have a "CancelDate" key, which sometimes contain null value (Date is not null here in the data if some conditions are met).E.g. [{"CancelDate":null},{"CancelDate":"2020-11-10"}]The datatype is set to DATETIME. After clicking the Finish button, i get the error code: „Processing Errorjava.lang.RuntimeException: java.lang.NullPointerException caused by null” .If i set CancelDate to DATE, i get: Data type conversion error for column "CancelDate", value "2020-11-10". Cause: Can not cast value "2020-11-10" to type DATE in column "CancelDate". I also tried DATETIME, as yyyy-MM-dd format, but the error code is the same. The only way i don't get an error code is if i set the datatype to STRING or

After successfully loading a new Excel with "name mapping" on my data model, I don't know how to set up the "language key" in my studio views. What step am I skipping" Thanks for your help.

Hi, recently, we have been registered as a partner. Where can I download the on-prem agent for the data extraction of an on-prem system? best regards