Product Q&A

I get the following error when setting up DegitalTwin in Simulation.What kind of time format should I use so that Celonis can read it correctly?​Error Message​Timestamps are rounded at the Eventday. This could cause problems to the Digital Twin Extraction, please check your Data Model and include the hours and minutes in the Timestamp columns of the data model.

I am also trying the Root cause analysis described in the Pycelonis tutorial from the top. https://celonis.github.io/pycelonis/1.6.0/tutorials/root_cause_analysis/01_Root_Cause_Analysis_Tutorial/ At the data model connection, I get a NameError when I specify a data model.I'm copying and pasting the data model ID, so I don't think it's wrong, but am I missing some operation?   The data model attempts to use this

How is that possible?With best regards,Elizaveta

How to send Vendor specific information emails dynamically to only that vendors according to their email setup using Action flows and skills ?

Dear Celopeers, May I ask you to dispell a potential misunderstanding on my part regarding the Calc_throughput function. I have three consecutive activities : A, B and C I would expect that: CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO LAST_OCCURRENCE['B']) + CALC_THROUGHPUT(FIRST_OCCURRENCE['B'] TO LAST_OCCURRENCE['C']) = CALC_THROUGHPUT(FIRST_OCCURRENCE['A'] TO LAST_OCCURRENCE['C'])   Unfortunately, this is not what I'm observing at the moment when doing this on aggregates (say... all Purchase orders processed in the last 6 months). Calc_throughput A->C reports a much shorter throughput time than i would expect from the above calculation. What could be the reason for this?  Best Regards,

Hi AllAm very new to celonis data connection and events including PQLI have a data set for Requisition PR (EBAN), Procurement PO (EKKO and EKPO)I also have the finance data invoices BSEG.BSCHL = 31Is there a column or a query l can use to directly link the invoices (BSEG) to POs(EKPO) without the table EKBEEventually, l have to compare PR, PO and Invoice value?Thanks

In sandbox, I am trying to build the analysis from demo data model of production. There are 2 data model, production planning and production. I am using the production one. Please help so that i can understand the data and build the analysis

i have a column that contains date and time , i only want to have time from that column , how can i get that using pql , Thankyou

do we have any Record to report case studies 

Does anyone use the function of simulation?・What process did you analyze?・What results have you seen?・For which KPIs were you effective? I would like to know what the benefits of using the simulation feature are and if it is actually useful.​

When creating the simulation, the following question came up with me.Could you please answer the questions?​1：When setting up Degital Twin, should I enter actual business hours for the From and To fields of Incoming Cases? Or, should I set the time when the process is running as configured in Degital Twin?​2：When setting up Degital Twin, what does the Incoming Cases case per day value mean?​3：When creating a Simulation scenario, is it sufficient to enter actual business hours in the From and To fields of Incoming Cases? Or should I set the time when the process is actually running?​4：​When creating a Simulation scenario, what does the value of Case per day in Incoming Cases mean?​

What are the different types of Extractor in Celonis?

As you can see below we have Ticket On Hold as always the starting point (with diff event time) and need to calculate the time diff. with the next following activities that can ONLY be - Ticket in Progress / Ticket - Waiting for Issue / Ticket Resolved (first one to occur after starting activity) As you can see from the example below we have to calculate 4 time differences:1) From Start 1 Ticket On Hold to End 1 - Ticket in Process2) From Start 2 Ticket On Hold to End 2 - Waiting for issue3) From Start 3 Ticket On Hold to End 3 - Ticket in Process4) From Start 4 Ticket On Hold to End 4 - Ticket Resolved 

Is there any document available for On Premise to EMS Migration?

Hi,How can I apply a conditional format color scale, based on the minimum and maximum values of an OLAP table that has aggregations like COUNT and SUM to calculate its values (similar to what is done by Excel)?  I've tried the background color mapping, but the options are specific values and not the minimum/maximum depending on the calculation of the table Thanks

Is it possible to perform predictive process monitoring the way tools like Apromore has integrated plugins to perform prediction of delivery time etc ?

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.