General Product Q&A

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?

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

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

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

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?

This Action Flow's purpose is to produce a CSV file to be sent via e-mail to a few business users. I have already been able to filter out the records completely based on the condition I want, but instead of stopping the e-mail from being sent, it just delivers the business users a CSV file with 0 records. I have tried to do it with the filter I show in the images. The 'Variable Value' in Set Variable - 39 is exactly the same that is being used to filter out the records in the first stage (Query Data - 10 - which produces the records basically).  I have tried multiple approaches with this solution so I guess there should be another way around the problem I'm facing, which I don't know. Thank you

Good day, is anyone else struggling to access the Knowledge Model in Studio? I can not create a new Knowledge Model. My collegue has the same issue. If I try to create a new Knowledge Model and I click "Create", then the program is hanging.

Hello,I need a Help on a KPI about OTC . I want to calculate time by hours between,(Cases which goes through "Lead Status Set To: Open" and does not go throught "Lead Status Set To : Assigned".) and current time. Or can you say what is wrong with my code ? HOURS_BETWEEN ( CASE  WHEN MATCH_ACTIVITIES ( NODE [ 'Activity Status Set To: Open' ] ) and NOT MATCH_ACTIVITIES ( NODE [ 'Activity Status Set To: Assigned' ] ) THEN "ACTIVITIES"."EVENTTIME"  ELSE   -TODAY ( ) END , TODAY ( ))

Hi there, The Activity Selection filter has an option where we can filter cases that flow through all or any multiple activities.I want to select a bunch of activities and filter cases that flow through any of them. Since this filter is used frequently I created an OLAP table with one category per row.   I assumed that, selecting a row and inverting the selection would give the same result as activities flow not through ANY cases in the Activity Selection. However the results are not the same. In fact, inverting the selection does not change the total amount of cases.  So this raises some questions. What does the invert selection option do and where can I read about it?Can we get the same functionality as in the Activity Selection filter (multiple activities flowing through any ) in an OLAP table?I used a CASE WHEN statement to create the categories in the OLAP table. Is there another way of doing this?  CASE  WHEN "_CEL_O2C_ACTIVITIES"."ACTIV

Hi everyone, looking for advice from Celonis customers. How did you work with your internal IT team to grant permissions to allow Action Flow emails using a company email address? I've got a functional ID set up with a mailbox to manage security. My internal IT group is struggling to understand what to do. Appreciate how you navigated this with your IT group. Thanks!

Hello,I am preparing an automation sheet on studio and I need a KPI like, if a user type is not selected calculate ratio as activities done by "B,C,S" type user divided by all activitiesBut if a user type is selected calculate ratio as activities done by user which selected user type divided by AGAIN all activities. So, If I use simple dropdown it filters all activities and my numerator is also filtered with my denominator but I don't want this.furthermore, I tried to use dropdown button and write selection to a variable. So I could control KPI formula and I could calculate however I want but, I cant choose how to control if a user type is selected or not. I am trying to control is variable NULL or not. is My way wrong ? I can do it neither on code either nor visual editor. Here is a SS to explain myself. Any help will be appretiated.Best Regards.