General Product Q&A

Hi Everyone! Can you please help me? I am trying to build a KPI related to the time spent on average to perform an activity. Additionally, I have to only count the working hours (and for that, I already have a variable created named "Working Hours") To do so, i am using this formula: CASE WHEN ACTIVITY_LAG (....) = 'ABC'THENHOURS_BETWEEN(... , ACTIVITY_LAG ( ...... )) This formula is working, but the problem is that I need to calculate only the working hours. How can I do it? I am trying to "remap_timestamps" but it is not working.. Thanks in advance

Is it possible to send the signals of my Action Engine to certain people without access to Celonis? Do they really need to be signed up for Celonis to receive these signals?

Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Error while joining table 'AP_HOLDS_ALL' with table '_CASE_TABLE_ORACLE'. Data type of column 'INVOICE_ID' doesn't match data type of column 'INVOICE_ID'. Error while joining table '_CASE_TABLE_ORACLE' with table 'AP_PAYMENT_SCHEDULES_ALL'. Data type of column 'INVOICE_ID' doesn't match data type of column 'INVOICE_ID'. Error while joining table 'AP_SUPPLIERS' with table '_CASE_TABLE_ORACLE'. Data type of column 'VENDOR_ID' doesn't match data type of column 'VENDOR_ID'. Error while joining table '_CASE_TABLE_ORACLE' with table '_CEL_AP_ACTIVITIES_ORACLE'. Data type of column 'INVOICE_ID' doesn't match data type of column '_CASE_KEY'. Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table &

This one is so obvious I know I'm just not seeing something! But how do I copy a well formed Analysis from Process Analytics and make it available in Business Views?

Hello all, I'm enrolling Celonis Summer School and almost in the end of the analysis I noticed that I made mistake at the beggining while uploading "_APX_WDCRP_CASES.csv. Basically in "event collection" »» "File uploads" »» "Decimal Operator", I didn't change "." to "," and so the program is not recognizing the numbers as decimals.  As I'm having my first steps with Celonis, can anyone let me know if this is possible to fix without need of making the analysis from scratch?? Thank you for your kind.Guilherme Luz

Hi everyone, I have a connection to a Sybase ASE database and extracts configured that work correctly, however on certain occasions these fail with the following error: "The data source configuration is invalid Unexpected error when creating database connection: Cannot create PoolableConnectionFactory (Database 'X-X-X-X-X-X' is unavailable. It is undergoing LOAD TRANSACTION.") My client has declared that this data source is a replica of the production database, which is updated every 5 minutes, during this update that is carried out at the transactional level, the connections are blocked, but this lasts only a few microseconds. I would like your feeedback, to know alternatives that can help me, so that the configured extractions can support this scenario, since the whole process of updating and creating the Celonis data model stops. I unsuccessfully searched for some configuration that would allow me automatically failed extracts to have the ability to retry to run. I

In the Variant Explorer (Process Analytics), the Cycle Time shown on the different Variants uses Throughput time from first activity to Last activity. Currently, there is no way to enhance the KPI to filter certain activities, like Date Markers (ie Due Date Passed). Is it possible to add the ability to customize the formula used for the Cycle time on the Variant Explorer?

Can any one help me to solve this issue? 

I want to combine data from two tables on the frontend using PQL query. Not sure how to do it.

I have a global date filter which pretty much is selection between a date period (Eg: - 01/01/2021 - 01/31/2021). This filter applies to my entire analysis when selected. However, I have an OLAP table where the columns are built upon formulas which include the use of DOMAIN_TABLE

I have an OLAP table that is sorted by # of days (in screenshot named first). But I am trying to produced the same table, but in the format represented in the screenshot labelled as second.  Essentially I want the tables sorted from lowest to highest # of days and also removed the NULL (-) values associated with each client. I have rewritten the queries for each column to support PU functions and was planning to use a DOMAIN_TABLE for this purpose, but when I use the DOMAIN_TABLE within the component filter to remove nulls when ISNULL(...)=1 it still remains the same as first

Can the Celonis EMS authenticate to an On-Prem Active Directory?

Looking for connecting Celonis EMS to DuckCreek Insurance platform... Is there a API library or connector available?

Please mention the way to connect. Is there a connector available ? Can we create a custom connector?

I have 2 columns in which I am looking to find the difference for. Since some values of each column contain a null they are not reflected accurately for exampleColumn 1 Column2 Diff2 1 14 NULL NULL (should be 4)NULL 5 NULL (should be -5) I have the formulas associated with getting values in Column 1 and Column 2 within saved formulas as "KPI(.......)". My initial idea was to substitute NULL as 0, but when I surround KPI(...) with a CASE WHEN it fails saying that CASE is not supported with INT or STRING Any ideas?

I have a skill that add data table, run ML script that update some other tabls and reload the data modal but updates on other table are not persisted in data modal. My assumption is that action engine do not wait for ML script to complete rather it just start it and move to subsequent steps.  Any thoughts, suggestions on this scenerio ? 

Please see the screenshot showing sample data, we want to show waste transfer movements which go out of a source storage unit (Movement type 319) to a destination (Movement type 0) and then return. I can make the PU function work well when there is one waste movement however there are many times that the stock is moved out and back, and out and back and I can't make Celonis line up the 2nd out and back movements

Hello everyone, iam wondering if there is any way to sort the entries in a button drop down? i.e. when loading dates, displaying the most recent dates first instead of the oldes dates. Many thanks!

I have a formula stored in a variable that is giving me an accurate result of what I need to get when I check via static value based on a date filter I am putting in. However, when I pull it to my OLAP table it is showing me another value even though the same date filter is applied? Example: 83000 is stored in <%=Var_1%>. When I apply the date filter is changes to 17000 (which is correct), but when I try to store the same value as a KPI in my OLAP table it still shows 83000

Column 1 has values where the KPI is as such for a company 1 (after clicking calculate shares in percentage checkbox):SUM(Days related to certain case numbers)/COUNT(DISTINCT (No. of cases))  Column 2 has values where the KPI is as such for a certain company 2 (after clicking calculate shares in percentage checkbox):SUM(Days related to certain case numbers)/COUNT(DISTINCT (No. of cases))  Column 3 has the difference Based on what I saw the values for column 1 and 2 are read in correctly, but the difference in column three is wrong Any suggestions on this would really be appreciated

I am trying to get the percentage value of the no. of cases in a happy path by dividing by the total no. of cases for that process and display in a single KPI. Any suggestions/formulas on how I can do that?

I followed the SAP Extractor documentation. It is very helpful and detailed. However, there is one thing I noticed isn’t mentioned: While installing the SAP Extractor there is a screen: Configure the Agent UplinkIn there are two fields:App KeyAgent Name These aren’t mentioned in the Docs. Are these specific to my Celonis team or to the SAP installation?

As we know, Process Mining has the tremendous advantage of providing an objective and realistic view on the processes, as opposed to the traditional BPM analysis, which is very dependent on human judgement and prone to bias.However, building a process model from an event log is not a straightforward task. It requires an algorithm, and algorithms are based on assumptions have to somehow deal with things like noise. Conformance checking can also be done in different ways. Therefore, to better understand my results, I would be very interested in learning the algorithms used by Celonis. Thanks!

Hello everyone, the goal for my master thesis is to analyse and simulate different process variations. After identifying weak points, the process should be adapted and a simulation should take place. Is it possible to simulate different process variants in the academic version of celonis?  Thanks in advance!