Product Q&A

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. BRDennis

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 if all the json objects keys contain values that are not null. Is there anything i can do so

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

Basically we would like to be able to track Skill Execution, is there a way to massively extract User Names and Timestamps of the Users running the skills? Thank you in advance! Best Regards,

I have a use case where I need to create separate views for different business functions using the core process data. Is there any way I can built an analysis just that for each view I am able to exclude certain activities (filter them out of the analysis

Using celonis for O2C mining of Oracle EBS system. In one of the view, I go to edit, select on component and then go to component options. For the units, I see it configured as <%=currency_symbol%>. Can you please let me know where I can find this parameter/variable defined. I find the value as Euro, where as it should be $

syntax[A]=1,syntax[B]=934patern1: syntax[A]/934=0.0010706638115631692patern2: 1/syntax[B]=0.0010706638115631692patern3: syntax[A]/syntax[B]=0.023554603854389723​Only patern3 will give different results...Please tell me the solution.

Affected rows: kickstart.messages-panel.more-than-100

Were can I found the latsted Step-by-Step guide for setting up Celonis on-Prem Agent?