General Product Q&A

I am trying to create a custom KPI using Visual editor but somehow the visual editor is empty (can't access/see the visual editor option)?Any idea why this is happening?

what is celonis?

uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

Hi,  I am using Augmented Attributes in a Knowledge Model to build a View App. The A. Attribute is defined to have 4 possible values (dtype string) and it is meant to be updated manually by the end-user in the app to any of those 4 values. It has a Default Value as well for all those cases where the end user did not manually updated the attribute (which happens frequently). The problem comes when I want to use the "VALUE" field stored in the augmented table from the attribute in the Knowledge Model. I want to filter a chart based on the Attribute´s values (again stored in the VALUE field) and also define a KPI with a CASE WHEN logic based again in the value of the attribute. When I do so, it just returns the rows or datapoints where the Attribute was manually updated, filtering out all the rows for which the default value should appear.  I have not found a way to include the default value in the PQL queries outputs that I desire, so that I do not get most rows filtered out wh

HiWe are currently exploring process mining capabilities on SAP Kofax/ Readsoft data regarding potential opportunity with one of our Clients. We already identified process connector, however the specification in Marketplace is not available. Therefore looking for detailed list of activities which come with pre-defined model, specifically the action in performed Readsoft.We would like also to check there are any analytic apps matching data model from this connector. Thank you in advance for your helpregardsMichał

I want to calculate the week average daily number of employees doing one action. For that I need to calculate the number of different usersID's (thus a count_distinct) each day And then calculate the average of of those values in the same week. That will tell me, during that week, what's the average daily employee attendance to that action. How to do it? It should be fairly standard by I can't get it! I have a case table with timestamp of the action, and the user that did the action. And I want a OLAP with Week number - average of daily users I have used this struct: AVG(PU_COUNT_DISTINCT(DOMAIN_TABLE(ROUND_DAY(CASE.TIMESTAMP)),CASE.USER)) but the results are incorrect Can anybody tell me what I am doing wrong? TIA

The date format that appears in the CSV output file from Celonis action flow CSV module is not showing correct date (showing wrong time stamp) for example in my data initial date is 8/12/2021 1:52:00 AM but in csv 8/12/2021 2:52:00 AM. Can anyone help?

Hi, During initial implementation there was a decision to pseudonymize column USNAM in multiple tables. Currently it was agreed that we need to have actual (not pseudonymized) users data in Celonis just like it is in SAP.Usually unticking the Pseudonymize box in extraction setup would do the trick and I will do it for some smaller tables for which we have full loads. However we have couple tables for which we are doing only delta loads, as they are way to big for full loads (over 40 GB). Doing full load for them would take ages and I'm not entirely sure how Celonis would manage with such a huge load done at once. The idea is to create one time mapping by downloading second iteration of that big table (BKPF is original one, the second one lets call it BKPF_RAW), that would only contain the 4 key columns and USNAM that is not pseudonymized. Next step would be to add new column (lets call it USNAM_RAW) to original BKPF, then update it with data from BKPF_RAW.USNAM by matching the two

What can be reasons for Open Invoices. Any Available views for Open Invoices in Accountz Payable.

Hi,I would like to to apply this function to mesure the cycle time of Change Activities. The activities table looks like this: Case ID2 columns "Change From" and "Change To" along with timestamp columnTime starts counting for each case when Change To = A for the first time and ends when Change from = A for the last time.   The logic Im trying to work around is (just disregard the function syntax- Im just trying to explain the logic.CALC_THROUGHPUT( First_Occurance ('Change to' = 'A') to Last_Occurance ('Change from' =' A '), Remap_Timestamps("Table"."event time", days) What is the right way to implement this logic?Should I filter the table to be "Change to" = 'A' or "Change from" = A and then merge this two columns to form a single column to use calc_throughput? But then how to merge different columns in the same table? Thank you for any suggestion!  

Dear all,I'm looking for a way for the Viewer User to save his allowlist in the conformance checker. Is this really only possible for the Analyst? Thanks in advance! Best,Jonas

I have am OLAP table containing cases with event time of activity X and Y and a date picker based on the activity X. When I select a time range from my date picker (i.e. 01-01-2023 to 10-01-2023 or 01-02-2023 to 28-02-2023) I would like to see only these cases for which event time of Y is within the chosen selection with result 'in scope' and 'out of scope'. I don't want to have a second date picker and have to choose the same date range manually.

Business Analyst - Customer Value Analytics (m/w/d)E.ON Energie Deutschland GmbH Loction: Essen (NRW), München (BY)Description: Du unterstützt uns bei der Bewertung des Bestandskundenportfolios anhand verschiedener analytischer Use Cases mit den Schwerpunkten Lifecycle Analysen, Preisanpassung, Portfolio - Analytics und KohortenanalyseDazu screenst du Daten und baust Datenmodelle zur Abbildung der Business Logik aufDu erstellst Analysen und Reportings in PowerBI und Process Mining (Celonis) und entwickelst diese weiterOptional erstellst du auch Analysen und analytische Modelle u.a. mit PythonDu visualisierst Daten aussagekräftig und kannst Wirkzusammenhänge erkennen und erklärenDu erstellst managementtaugliche Präsentationsunterlagen im notwendigen Abstraktionsgrad, um die komplexen Zusammenhänge im Bestandskundenportfolio zu transportierenDu unterstützt im Rahmen der Projekt-/Squad-ArbeitZur Bewerbung: https://jobs.eon.com/de/job/Business-Analyst-Schwerpunkt-Customer-Value-Analytics-m

Is there a best practice to chose a KPI (saved Formula) over a variable in Celonis (or vice versa)? For example, I seem to recall that all KPIs are calculated upon loading the analysis? Would that make certain uses more suitable to a variable?

I want to make a Simulation. The Simulation depends on the weekly data of - how many parts do i've to produce- how many peaple are present in this week- the expected duration of the machines (OE)(eg. 100 hours active of 120 possible hours is 83%)- number of shifts is it possible to change the data of the OE for example in an table in the front end to see the impact of this change on the output.

I would like to add a status selection functionality in the studio. I would like to have a default status of 'To checked' and for the user to be able to change to 'to be checked'. Does anyone have an idea how to do this?

Hello, my KPI with Parameter does not work in View Tables. I get an error message: Wrong syntax for KPI parameter id. I used the code snippet which worked in the kpi list for the same parameter.

How do I use a View Variable in my KPI? I want to use a View component to dynamically update a KPI in my KPI list

I would require some help on predictive analytics use cases for p2p process. Any help on this would be appreciated

We are trying to connect O2C connector with SAP S4 HANA and need to know if RFC extractor module can be be installed in BW to leverage BW as a source system.

I think communication is key when developing something new. However, when we are dealing with people all over the world, we need to think it in a smart way. I am looking for something opened and clear, also friendly and not full of formality. Hopefully you are able to share some good practices :) Looking forward!

Hello,  I need to schedule publishing of data pool draft. There is the function publish() for packages in PyCelonis but I haven't found something similar for data pool in API documentation or in PyCelonis.  Is there any way I could run saving of data pool draft or adding a new version for unpublished drafts? Is sync of data pool an option for this? Thank you very much!

Hi all, we report the Automation Rate with Eventtime as time dimension. We were expecting, that the Automation Rate therefore should be stable e. g. for the past year 2022 regardless whether we extract the data in March or in June. Unfortunately we have changes even though we did not change the measurement.We have deviations in the number of activities as well as the number of cases.  Formula:AVG(CASE WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_<%= language %>" IN (<%= whitelist %>) THEN NULL WHEN ISNULL( "_CEL_O2C_ACTIVITIES"."USER_TYPE") = 1 THEN NULL WHEN "_CEL_O2C_ACTIVITIES"."USER_TYPE" IN (<%= auto_user_type %>) THEN 1.0 ELSE 0.0 END) Remark: We have not changed the whitelisted activities nor the user types included in the variable auto_user_type.Any ideas? Thanks in advance 

I'm looking for a study group at NY/NJ/PA or virtual for Celonis Data Analyst Certification. Can you please advise? Thanks!