Product Q&A

I want to create a table which will auto increment the id. Identity is not working, do we have any other solution?CREATE TABLE production_categories (    category_id INT IDENTITY (1, 1) PRIMARY KEY,    category_name VARCHAR (255) NOT NULL);

Hi there I started the training track and within training "configure standard processs KPIs in the visual editor" the visual editor does not correspond to the training video (I am using the example PO data and successfull implremented examples so far)   What do I have to do to get to the visual editor?  Best regardsDieter

Hello Team,  I get an error like the screenshot when creating a PDF report from Studio Skill. Can you tell me a solution to the problem? Thank you in advance! Best Regards,

Hi,Imagine a table of sales data with each row containing the sales date and the amount sold. My goal is to calculate the standard deviation of monthly sales (and use this value in other formulas). Getting the monthly sales is easy:DIM: ROUND_MONTH(SALES.DATE), KPI: SUM(SALES.AMOUNT) In order to STDEV over those monthly values, I thought about doing the monthly sum within a PU function like so: PU_SUM(DOMAIN_TABLE(ROUND_MONTH(SALES.DATE)), SALES.AMOUNT)) In my understanding of PU functions, I would've thought that this results in the same values as DIM: ROUND_MONTH(SALES.DATE), KPI: SUM(SALES.AMOUNT).  But it does not, the values are roughly 10 times as high, each "month" is higher than the sum of all amounts together.  In the end I want to be able to use a formula to get the STDEV and use this to calculate other KPIs Thanks in advance

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: 

I have some KPIs that are calculated based on the unfiltered population and some that are filtered by selections, but now I want the population to be flexible and since I have multiple filters that are applicable I need those KPIs to be flexible too. It does not work if I set the variables to not static because then some KPIs are calculated incorrectly with the sheet filters and selections even if i calculate them with the GLOBAL function. You can think of it as two populations. The first population is the basis for the main KPIs which is filtered by more generic filters but not with selections. The second population is the filtered first population which is the basis for more KPIs and visuals which can then be selected.  If anyone could think of a better way to do this I am all ears too because if I can assign multiple values to a static variable then I will have to implemented x Case When statements to check for which filters are active.

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.

Hello, I want to understand how can i leverage multiple source systems into one data model or data pool and perform process mining? If the data sources are two different systems eg- SAP and Salesforce. What are the possibilities for this?

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")

Hello Team,While moving Celonis studio packages from one team to another team in ML Workbench.I am getting following error I urgently need help on the below error.   

How to migrate from On Premise to EMS?

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?

Hi all, I have some issues finding null values. The column EISBE in the Marc table returns a numeric value. All values greater than 0 are classified as MTS. Values that are 0 are classified as MTO. However, this column has many null entries (around 70-80%) that I would like to consider as MTO as well. My code: CASE WHEN MARC.EISBE > 0 THEN MTS Material > 0 WHEN MARC.EISBE = 0 THEN MTO Material because 0 WHEN ISNULL(MARC.EISBE) = 1 THEN MTO Material because null WHEN MARC.EISBE IS NULL THEN IS NULL END In the end, the result consists of these values: MTS Material > 0, MTO Material because 0 and -. How can i catch these dashes? Thanks in advance

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!') 

Hi, I want to apply a component filter to an OLAP table. The table initially contains only the case key and the event time. The filter should ensure that only the cases from the last month are displayed. I find the date of the last case with MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"). Then I subtract one month with ADD_MONTHS(MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"), -1). Up to this point everything works. If I then set FILTER "_CEL_O2C_ACTIVITIES". "EVENTTIME" > ADD_MONTHS(MAX("_CEL_O2C_ACTIVITIES". "EVENTTIME"), -1) as the component filter, it tells me of course that you can't apply a MAX function in the filter.  Is there a way to solve the problem anyway? Thanks a lot! Many greetingsLukas

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