General Product Q&A

While extracting data using an API, we got stuck at a point that in the extraction filter field no strings with a single quote can be inserted, such as: filter = 'content_description eq '*purchase order*' ' It will return an error, see screenshot below. Is there an way to insert string values here with a single quote in it? Things we tried:Escaping the single quote characters using two single quotes (as in Vertica) or with a backslash, without success.Wrapping this value in a variable. It looks as accepted in the first way, but will return in parsing error during te extraction (see screenshot below). Thanks in advance!Jan-peter  Screenshot 1: Filter Statement Field Screenshot 2: Error when text string is wrapped during the extraction: 

Can we create Dynamic Analysis in view ? if yes than How . thankyou

Cant edit my analysis! Does anybody know why Korbinian Zieler is in edit mode? It looks like it is a default, as I get the same message on every new analysis.

I was looking for a way to take 'pictures' to track a few KPI's through time. I used to do that with Transformation Center using the Logbook feature, but I'm a little bit lost about how to do it on Studio.

I want to keep a rolling 2 years of data in Celonis. So each month I would ideally like to delete the 1st month in Celonis and add the new month. I do not want to reload the data each month - full load (as that would take too long for two years of data) and of course a delta load only adds change to the existing data.

How to run a data job OR transformation from Machine Learning Workbench?

Now I'm setting up SAML SSO with Celonis EMS. It seems that the SAML Request from SP to IdP is being forwarded by HTTP POST Binding. Is it possible to change to HTTP Redirect Binding on the SP side?

I am trying to connect the Celonis with Client On-Premise Microsoft SQL Server, and filled in all the required details.Please help to get resolve this issue

I've built an AF that triggers a skill that write data into a table. The problem is that the skill is triggered as many times as the number of rows in the table. That's fine because the table is really small, but I can't execute an ML script as next step in the same skill, since the ML script is triggered as many times as the number of rows. As a solution, I though that I can build a small AF that is triggered only when the first AF finishes running (so the whole rows will be written to the table). This second AF will itself trigger a skill with the execution of the ML script in it. This way the ML script will be executed only once. I can't find a module that allows me to trigger an AF when another one finishes running.

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