Product Q&A

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?

Is there any way to reference a calculate column in a filter inside a component like olap table ? My problem is that when i want for example filter a olap table with activity and %automation than %automation rate was less than 100% i can no filter like  FILTER KPI("Ratio", "_CEL_AP_ACTIVITIES"."USER_TYPE" = 'Automated') > 0  Cause it raise an error saying that a filter can no use aggregate funcion like SUM.  If i can reference a filtre for a calculate colums %Automate = KPI("Ratio", "_CEL_AP_ACTIVITIES"."USER_TYPE" = 'Automated'), and in the filter i can filter by column like   FILTER '%Automate' > 0  Then,¿is is posible to filter data by column ? ¿ How can i do it ?   Thanks in advance 

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 ? 

Dear Team,  Please give me an advice about how I can get the timestamp which represents when was the last execution of a specific data job Thanks in advence!Regards, Roman

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