Product Q&A

How do I calculate the working days between two activities with a work calendar from a non SAP system? Hello community, I am having difficulties calculating the number of working days between two activities. As I do not have SAP connected to Celonis, I want to connect a work calendar using another table. I have added an additional table with the following structure. It is linked to the time stamp of the cases. Now I want to sum up the flags of all days between the two activities. However, I only get the timestamps of the activities from the added table (This means I always get two as a result).  I have assumed that this could be due to the link via the timestamps of the two tables. Does anyone have an idea how I could solve this problem or how I can do the calculation in PQL? Basically, I would be interested to know if it is at all possible to integrate a work calendar with a non SAP system? Unfortunately Celonis only suggests a TFACS table? Which table structure would be advisable? Ma

Update: Snap has evolved. Enter the Celonis Free Plan.   The TL;DRNow you can try out advanced EMS capabilities — including the world’s #1 process mining technology and Action Flows — for free. Yup, you heard that right. A no-cost version of the Celonis Execution Management System is more than just “on the horizon.” It has arrived. Snap teams will be updated automatically and all of the Snap data will be automatically uploaded to the new platform, so no sweat there. The Celonis Free Plan — at its core — is just a new and improved version of Snap with more EMS features. And the best part? We’ll keep adding more and more of these features as we develop the customer experience. Questions? Send an email to m.giraud@celonis.com Keep reading to go a little deeper into the new components at the heart of the Celonis Free Plan.  -- StudioWith the Celonis Free Plan, users can experience the power of the Celonis Studio without breaking out a credit card. Launching Quickstarts gives organizations

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

Feature request - shading lines in tables, similar to tables in Excel maybe we have overlooked this - would there be a chance to get the option to shade lines in tables alternating between shaded and white so that you can easily see in which line you are (having a frozen left column)

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?

What all options do we have in celonis to export our analyzed process ? (ex - csv, excel, bpm)

Hi all, I'm currently enrolling Celonis Summer School and I have no experience on PQL neither SQL languages, so I please ask your help. I am trying to write something like a "SUM IF" expression. Basically, when column "_APX_WDCRP_CASES_csv"."ORDER_DATE_MET" = 0, I want to sum "_APX_WDCRP_CASES_csv"."ORDERED_QUANTITY" values.  I already tried to mix CASE WHEN function with SUM but I was not succeeded. I also searched for other functions related with aggregation but could not find one that applied. Many thanks!Guilherme Luz

Hi together, We are facing an issue with the data load since 9th April. We cannot load data from SAP HANA databases anymore. Everything worked till 8.4. We have these issues in different teams (all on eu-1) and for different SAP HANA databases from different hosters. Therefore, it seems that something changed with the driver within Celonis EMS. Error: Unexpected error when creating database connection: Cannot load JDBC driver class 'com.sap.db.jdbc.Driver'(see attachment) Any ideas? Thanks in advance,Clemens

I established the connection with service now.When i tried to install the service request management but i got error sys_audit table is not present.so I check in Extraction part to extract the sys_audit table but i dont have the table.

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.

Dear Celopeers, on September 16th 2021, we are hosting our first Webinar on how to automate with Action Flows!This will be the first part of a new series of Webinars. The first session will coverWhat you can do with Celonis Action Flows (presentation)How to set up your first Action Flow (live training)Where to find further material & trainings (link to resources)Q&A (live) You can directly register here!

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

Hi All,I am looking for filter condition which can filter out records from activity table once specific activity is first time occurred.Tried with REGEX, PU_FIRST but some how this doesn't work.Is there any one applied same kind of filter condition? Below is what I am expecting:Anything after first event 'Approved' is what I wanted to exclude. 🙂

 How is it posible to use WORKDAY_CALENDAR and WORKDAY_CALENDAR without problems.? I want to use both calendars at the same time. I have use INTERSECT, and i have join both calendars adding the id_calendar to the tables, but i get always the same error. Error in formulaTo use the calendar ID column [constant SP-MAD], it must have a join relationship to the table containing the timestamp column ["IssuesFunes"]. The formula is the following.  REMAP_TIMESTAMPS (   "IssuesFunes"."created" ,    HOURS ,    INTERSECT ( WORKDAY_CALENDAR ("WDCalendar") , WORKDAY_CALENDAR( "WORKDAY_CAL_TFACS" ) ) ,  'SP-MAD')

Quick Tip!  For faster run times, move filters from the where clause into the appropriate inner join. The top example is an optimized version of the bottom code. Let me know if you have any other tips or questions!  

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?