General Product Q&A

COUNT(CASEWHEN DAYS_BETWEEN(ROUND_DAY(<%= Earlier_Date %>),ROUND_DAY(CASE WHEN TO_TIMESTAMP('<%=date_to%> 23:59:59', 'YYYY-MM-DD HH:mm:SS') > TODAY()THEN TODAY()WHEN TO_TIMESTAMP('<%=date_to%> 23:59:59', 'YYYY-MM-DD HH:mm:SS') <= TODAY() THEN TO_TIMESTAMP('<%=date_to%> 23:59:59', 'YYYY-MM-DD HH:mm:SS')ELSE TODAY()END)) > 60 THEN "CASES"."_CASE_KEY" ELSE NULL END)/COUNT("Total Average"."Total")

I want to schedule my Sales Professonal exam, but I am having problems with the demo. I am looking for some guidance. who can help me?

i have a column contain due date i want to make each value of the due date ,end of the day as due date of the same month , thankyou

In detail I want to canculate the thoughput time only if ther is an gripper chance in the process flow. This means that we have a batch production and only the last cycle of any batch is relavent.  I was trying to solve this problem by using "case when product variant a is unequal to productvariant b" but cant´t get any further.   Does anyone know how to solve this problem?

I tried to use pyinstaller to package celonis program but failed with message "FileNotFoundError: [Errno 2] No such file or directory: 'C:\\\\Users\\\\...\\\\Temp\\\\_MEI109202\\\\mlflow\\\\ml-package-versions.yml'The code is simple as below:from pycelonis import get_celoniscelonis =get_celonis("...", "...")print('success!') 

Are on-Prem data models not available in Studio? Haven't been able to add any as data model variables.

Hi, I am creating a dashboard (Analysis) based on a Knowledge Model, which was created with database contained in an Excel file. How can I upload automatically thrice a month the Excel file, considering its changes between the different loads. The file lives in a repository (Sharepoint), and the database from the Excel should be transformed by a Data Job. ThanksLDH 

Hi,I want to calculate the minimum of the following calculated column of an OLAP table: SUM (CASE WHEN "Internal_Contol_BD_KPI"."RESULT_VALUE_2" = 'FAIL'THEN "Internal_Contol_BD_KPI"."CONTADOR"ELSE NULLEND) / SUM ("Internal_Contol_BD_KPI"."CONTADOR") but when I try to apply MIN() to all that expression, the following error occurs: "Aggregate expressions cannot be nested inside aggregate expressions." Then, how can I obtain the minimum of that calculated column? I though a solution may be using PU functions, but since there is only one table in my analysis, it is not possible. Regards

Hi all, For a use case, we need to iterate over SAP tables and therefore the SAP on-premise extractor is not sufficient. We are investigating accessing the data using a Python script (possible in the Machine Learning workbench) as described in Connecting Python with SAP (step-by-step guide) | SAP Blogs. Has somebody experience with this approach?  If we want to do it in the Machine Learning Workbench, this requires (temporal) admin access to install the SAP NetWeaver RFC SDK. Is this something that is possible? Looking forward to your ideas! Cheers,Jan-peter

I want to increase the no. of free attempts for engagement certification fundamental exam in celonis. I was not able to clear in free attempts (2 ) and utilized all

Essentially, we are tracking usage of our Action Views / Skills through an augmented attributes table. Unfortunately, this table refers to users through a code (CHANGED_BY field): We have recently realized that we can extract User Information like this: Which will give us a correlation between User IDs and the actual Users (Name + E-mail):Since we have an ever-shifting user-base, is there a way for us to get this information into/from Celonis' Back-End (Data Integration) automatically? Thank you in advance!!

in the example below, Action Section has been updated occurs multiple time, I want to calculate the time spent between each of the "Action Section has been updated"xyz Action Section has been updated 2-Apr-22def xyz Action Section has been updated 2-Apr-22abc def abc Action Section has been updated

Are there any limit to the amount of data to be processed by a Jupiter notebook running in the Machine Learning module?  I mean... can I for example load a pandas data frame with 2 billion rows ...or any crazy volume? Is there going to be a cost associated with execution of a Jupiter notebook? or to the data volume processed or the cpu used? TIA!

I will have periodic extractions from the transactional systems once a day into a bunch of text files (.csv) How can I set up extraction jobs to do that? Is it a specific connector? Because it seems the "File uploads" is only for manually upload files. But I need to upload them from a shared folder, and do it periodically and automatically. TIA 

i want to create a dual axis chart in view but 1st will be bar chart and 2nd will be the line chart , and i want the bar chart value constant it should not get changed according to line chart filter , how can i do that . Thankyou

I wish to appear for the Solution Professional Exam. Can somebody guide me on a> How I can enrol for the exam? b> where i can find the relevant track(s)/ module ? c> Prerequistes

Hi, I would like to run an Celonis Studio Action Flow that calls the API https://magpie.springernature.app/api/users. This API only allows access from certain IP addresses, I therefore have to use the HTTP (On Prem)-module for this. Which connects to a Celonis Agent on our company's server. There seems to be something wrong with the application.yml file of this Celonis Agent, as running the Action Flow produces the runtimeerror: "url - URL format is incorrect or domain is not whitelisted, please check application.yml".  Does anybody know what I'm doing wrong? Thank you very much! The application.yml file looks like this:---agent: name: Celonis-On-Prem-Action-Flow concurrent_executions: null id: 44962ead-5b9c-4b94-8e58-d93427c7186fcelonis: authentication:  appKey: <I think I better not tell you this>  teamDomain: springer-nature-productive  env: eu-3 internal-proxy-config-path: null proxy-config-path: nullvault: enabled: false file: nullconnectors: http:  enabled

There is a problem while connecting ebis and oracle ?

Hi all, I have been trying to use file upload method to upload the source data, however, i often find that the original event log has a lot of duplicated activities (same timestamp or near same-time timestamp) which created a lot of "noises" in the analysis, for example: Create Purchase Order 2021-01-01 01:00:00Cerate Purchase Order 2021-01-01 01:00:01 This kind of "duplicated" activities are less likely to be performed by human, would you please advise if there is a way to de-duplicate records that happened within a very short timeframe (say 1 s) with all other fields having the same value? Also, as I have been trying using different file and thus this occupy much of my data consumption, may I know is it possible to remove the file uploaded and release some capacity for other analysis? thanks in advance!  

Where I can get the transformations jobs for APC Data Consumption Monitor? In EMS Store I can only see APP not the connector.

I want to know the status of our Partnership & Partnership certificate with Rsystems Inc.

Hi, I am currently using the Machine Learning Platform on Celonis to read a csv file using pd.read_csv which has been working perfectly until I had to update it with a new csv file.  There's a weird problem where, when I read_csv the file in the Jupyter environment all the data is thrown into one column. It's even more odd because if I view the csv file directly on Excel or by opening it on another tab in Celonis Machine Learning, all the data seems to be formatted correctly into a table.  So, I'm not sure why it's suddenly reading everything into one column. Thanks,Terence

Hello,I would like to create a benchmark exactly as it is done in the Accounts Payable analysis (found in both the training and the Sandbox), but instead of comparing the Companies (or other attributes) I would like to define two different time intervals. Ideally, I would like to insert two Date Pickers, one for the left part of the sheet and one for the right part, and therefore be able to define two different periods. Thanks to anyone who will give me some advice or best practices for my question

I am using the C4C+ for a sales pitch. While working with the conformance checker, came the question that Is it possible to set some business rules for process model. For example, when attribute x > 100 follow an approval path 1, else path 2 ? And See if both paths are conforming to their respective business rules?  

Hi all, I am trying to use the e-mail module in Action Flow and I need to add a connection using my SMTP server. These are the configurations that I should fill but when I fill these configurations, it gives me an error like that :Is there anything that I should do before filling these configurations or in general how can I use my SMTP server in my Action Flows? Thank you,Ugurcan