General Product Q&A

If a transformation has many Insert statement in the table. How can we know which insert query is running in the execution log if the transformation is running as a job.

I am building an analysis.I have a period Filter :( YYYY-MM ) format.While I choose a Period I get to see KPIs specific to that period , but the requirement is , even if I select a specific period, same KPI should show me 2 different values , 1. For the specific period choses 2. KPI value since beginning till date , it should ignore the Period filter value chosen. These two Same KPIs to be placed side by side on the same screen. Can we do this ? If yes, then How ?RegardsAyan

Can you restore my account to its original higher privileged and more useful/accessible account that used this Activation Key:6f1332ff-5b9a-471c-ac24-08b36d6dce21And this username: Reynoldsj@sysmex.com This inadvertent Training Membership Key:76f439aa-e45d-4288-89b7-dd7fe69de838seems to have overwritten my original account and now I'm a generic user, which is NOT what was intended nor what is useful to me. Thx! James Reynolds

Hello,We have an AR project and I have installed Data jobs from the EMS store. It got some errors. I looked up logs and found out it is about KNB5. AR_KNB5 view was not even being created because it says no relation of KNB5. I looked at ECC and saw that KNB5 table is empty. Does empty tables are not being extracted ?

Hi all, Just to frame the use case: I have implemented the ML Workbench duplicate customer master data checker. Each customer can be flagged by none, one, or multiple duplicate search patterns.  Suppose I have 2 different search patterns A and B.  Further, suppose I have 5 customers: 1, 2, 3, 4, and 5. First, I have created a OLAP that has three columns (as can be seen in the attached screenshot):Column 1: The customer numberColumn 2: A simple case when flag, showing if the search pattern A identified the customers as a potential duplicate (1 = YES; 0 = NO)Column 3: Same as column 2 but for search pattern B  Now, I want to define a button dropdown / dropdown that lets me select none, one, or multiple search patterns and behaves in a certain way if are MULTIPLE entries are selected from the dropdown. If none is selected, all 5 custom

I have to create a date filter (which should be a dropdown), that only filter the components in that particular sheet. I think this can be done using a sheet filter by setting a variable using a button dropdown. The problem is that the date is in DateTime format, and it writes to the variable like this : "Sun Jan 03 2016 05:30:00 GMT+0530 (India Standard Time)", I am new to pql and I don't know how to convert it into a proper format so that it can be used with FILTER statement in load script. Please help me out.

Hi Team, I need your help.I have a table (T1) which has 5000 records. Wanted to extract all the records in CSV from the Transformation Job by the query (SELECT * FROM T1).Problem : In transformation job, I can only view 100 records.Also the table is not in the data model, so I will bot be able to create an OLAP table in the analysis and download the data. Please advice. Regards,JB  

Hello everyone, wanted to know how to create a pie chart in views with help of YAML code?

... we set up a custom process to analyse ourSoftware and evaluate its performance. Therefore we would like to "simply" multiply two KPIs. (Calculation a.) * b.)) However the calculation does not work. a.) (SUM (CASE WHEN PU_COUNT ( "BITMPT_OCRHIST_BATCH", "BITMPT_OCRHIST_SOURCE"."SOURCE" ) = 0 THEN 1 ELSE 0 END) ) / COUNT("BITMPT_OCRHIST_BATCH"."MANDT") (( b.) ((SUM(CASE WHEN PU_COUNT("Case_Invoice_Processing", "View ABBYY_Invoice"."AutomationState","View ABBYY_Invoice"."AutomationState" LIKE 'manual' ) > 0  THEN 1   ELSE 0END) /((SUM(CASE WHEN PU_COUNT("Case_Invoice_Processing", "View ABBYY_Invoice"."AutomationState","View ABBYY_Invoice"."AutomationState" LIKE 'manual' ) > 0  THEN 1

We are trying to add same KPIs but with different filters on same column chart (side by side), but not able to do.For e.g. we want to show number of emergency breakdowns for two plants, this will require to calculate same KPI but using a filter. Another example is to calculate downtime for two different type of work orders ( Emergency and Preventive maintenance). We want to show comparison in same chart with two columns.

Hello Is it possible to create a KPI with a filter on it ? For exemple : A KPI who's showing the % of invoice paid late and when we click on it, it creates a filter on all dashboards

I need to create database/model and then insert data into the tables. I tried to under below options , but it is getting stuck ( attached screenshot) Data --> Data Pools --> Process Data Models

Therfor i tried to divide the KPI "all cases starting with A" by the KPI "all cases passing A". Unfortunally it is not possible to divide two KPI's (or I am using the wrong syntax). Does anyone have an idea how I can solve this problem? 

I'd like to restore an analysis I have done in the past using Celonis. I have exported json file, but I don't know how to import the file into Celonis. Could you please give me instructions?

I'm taking BVA training. Working in Sandbox, created sandbox sheet. I added a component that I now want to delete. How can I delete that component from my sheet?

Situation: Currently, changes are made to cockpits in the test system (QA). The cockpit is then transported to the productive workspace (PROD) using "move to". With each transport, the user's bookmarks are deleted. A similar issue was already raised in 2019 (title: Hyperlink Issue), but Celonis 4.5 was used. Overview:-We currently use the cockpits in the "Process Analytics" tab and not in the Studio.-Celonis in the Cloud (no Celonis 4.x)-3 workspaces (Sandbox, Test & Productive) Further Questions: Am I overlooking another transport option here, or can bookmarks, for example, be saved from the productive environment before the transport and imported again after the "move to"? 

Hello,We have a O2C process and it is using a celonis data extractor agent to reach on-premise source system. Here is the question; We now going to implement a second process and it will also use an extractor. Can we use the same host to set up new extractor ? Or do we have to build a new one ?

Can somebody point me to the PSQL reference document?

I have recently started working in Celonis and exploring the Machine Learning module. When I created an app and now trying to open it, it shows "403 Forbidden (nginx)" error. Snapshot attached. What can be the possible reason? 

Could you please tell me how to create bar chart in celonis studio?

I have a problem with the course "Configure Action Flows". When I try to get access to the documentation to download the Agent installer,it always leads me to a page where a white page pops up and it is just written "Forbidden"

We are trying to add same KPIs but with different filters on same column chart (side by side), but not able to do.For e.g. we want to show number of emergency breakdowns for two plants, this will require to calculate same KPI but using a filter.Another example is to calculate downtime for two different type of work orders ( Emergency and Preventive maintenance). We want to show comparison in same chart with two columns.

The students are a mixture of engineering and logistics majors and this is their first experience with process mining and Celonis.

Hi, Celonis doesn't seem to like the escape character ("\\") when filtering graphs for product texts so tried to just replace it with the following formular: REPLACE("VBAP"."MATNR_TEXT",'\\', '-') However, I get the attached error message.  Best regardsAram