Product Q&A

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.

Does anyone know how to send data such as a record id from a skill to an action flow? The action flow has a skill trigger but unable to set the parameter in that trigger.

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

Hello I have the following problem: We have the AVG time cycle for a set of case and we want to obtain the % of cases with TC below de average and above average. I tried to do it in this way: CASE WHEN CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start']  TO ALL_OCCURRENCE['Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" ,  days))>AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start']  TO ALL_OCCURRENCE['Cla. Closed'],REMAP_TIMESTAMPS( "AT_CLAIM_L1"."_TIMESTAMP" ,  days)))then 'TC > AVG'else 'TC <= AVG'END but I get the following message:The aggregation function AVG cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs. Which would be the correct way to have th

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

How to set auto increment field while creating table in celonis sql, since identity is not working

trying to make a connection between Oracle EBS and Celonis and I'm getting an error. Need your assistance

Hi, I have acess to celonis partner portal but I am not able to acess https://persistent-systems-sandbox.demo.celonis.cloud/ui/login . Please help me to access Sandbox. My email id is manpreet_rekhi@persistent.com, provide instructions