Ask questions and get answers about Celonis products from experts and peers.
Recently active
Hi, a customer of mine is looking for working instructions for CoE team members. Has anybody any experience with that or even some examples?Thanks
How does my organization approach Celonis for Partnership?
Hello, Is it possible to hide/unhide a komponent (button) based on selections done on bookmark level? Thanks in advance!
Error message:Error during extraction. Exception message: Unexpected character ('?' (code 63)): expected a valid value (JSON String, Number, Array, Object or token 'null', 'true' or 'false')at [Source: (String)"???<html class="gr__stbeehive_oracle_com"><head><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><metaname="description" content="____This_pod_is_enabled_currently____"><title>Unplanned Outage</title><style>html, body, div, span, applet, object, iframe,h1, h2, h3, h4, h5, h6, p, blockquote, pre,a, abbr, acronym, address, big, cite, code,del, dfn, em, img, ins, kbd, q, s, samp,small, strike, strong, sub, sup, tt, var,b, u, i, center,dl, dt, dd, ol, ul, li,fiel"[truncated 3308 chars]; line: 1, column: 2], body: ???<html class="gr__stbeehive_oracle_com"><head><meta http-equiv="Content-Type"
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 customers should be displayed (i.e. all customers). (works fine)If one is selected, then only those customers should be shown for which the search pattern identif
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 ELSE 1END))))))
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 the information we need? Thanks!
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"? Or do all changes have to be copied manually from the test workspace to the productive workspace (components, saved formulas, variables)?
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?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.