General Product Q&A

With kpiParams I should be able to give it's parameters (in this case a view variable) but I just get that errorSame sintax with a kpi list works fineSame table inside an analysis works fine too

I saw there is not a option for that, so I am trying make one. I want a chart with the most common variant but i don't know how transform the list of variants in a list with the most common variant.  I was trying to filter the variants making this KPI that permit "filter" with a second KPI .CASE WHEN COUNT(VARIANT ("BD_ACTIVITIES"."QUEUE"))> 186 THEN 1 ELSE 0 ENDThe secon KPI:Case WHEN KPI("variant_most_common") = 1 THEN KPI("PROCESS_VARIANTS__BD_ACTIVITIES__QUEUE") ELSE 'OTHER' ENDBut it gives me this error : The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.Right now i don't have more ideas to can continue. I dont know if someone could help me.  

Is there any workaround to assign a default value for package runtime variables?

I want to check if the delivery date is less or equal to today's date + 42 days - WHEN TO_DATE("EKES"."EINDT", FORMAT ('%d-%m-%Y))

Hi Community, I want to visualize the amount of handover moments within a case and also calculate an average for all cases. We have multiple tables but the most relevant are of course the case table (incl. Case_Key, Case_ID) and the activity table (activities, Case_Key, Case_ID, USER_ID). The USER_ID contains the relevant info I want to use for defining the handovers but I can't seem to pull it off. Any tips?

In an action flow, is there a way to merge PDF's created with the "Create PDF Report" app? I need to create PDF's from different Analyses and send an email as a combined file.

Please clarify why column ERDAT is not included in standard ABAP script but it is selected in standard transport script.  1)     Add Activity: Record Goods Issue-- ERROR: Column VBFA_GI.ERDAT does not exist.  CAST("VBFA_GI"."ERDAT" AS DATE) + CAST("VBFA_GI"."ERZET" AS TIME) AS "EVENTTIME"                                  INSERT INTO "_CEL_AR_VBFA_ACTIVITIES FROM VBAK, VBFA, LIPS, LIKP, VBFA, VBFA, VBRP, VBRK, AR_BKPF_BSEG, USR02, MATDOC Table Name(VBFA): Sales Document FlowERDAT: Date on Which Record Was Created              ERZET: Entry time

in Case Explorer the details for column "Created By" is displaying username, but I want to display it as this case is an automated but not by user. How should I change the way it display? Appreciate any guidance.

Hi expert, I have a question regarding Delta loads. I've been using a data connection from AWS RedShift to Celonis. Before performing both the full loads and delta loads, I copy the target table, rename, and re-tied to perform Full loads and Delta loads. The full load consistently succeeds, but the delta load encounters issues. Here's the error message for the a_size_result table:Datatype of the column size_l changed from FLOAT to STRING.Table won't be delta loaded. Please perform a full load instead.When I reviewed the delta load log, I noticed that there was a change in the metadata for the 'ds_if_scm$_CELONIS_a_size_result' table.After full loads the data, I checked the data type in RedShift (String) and the Celonis Data Pool (Varchar). Could an expert please explain why this error occurs during delta loads? Thanks,

Can anyone suggest the best way to use the full capabilities of the Machine Learning workbench

Hi, I want build a POC of any process in Celonis EMS..But for that I will require dummy data. Anybody knows how should proceed ? or Can you please help me to get the dummy data.Thank you

I'm looking to understand how a customer DB contains the information required for Process Mining (case, activity, related tables) from a completely unknown system. We have access to a DBA who can provide information such as GraphML files but we do not have direct access to the DB to do reverse engineering. Is there a tool on the market that will allow us to recreate a data model from data extracted from the customer DB. We've tried spark and other tools but we really need one that can map tables and relationships (including foreign keys).Thank you

I’ve configured waterfall chart. Right now I can see the kpi values only when I hover over the bars. Is there a way I can show the KPI value on each bar? 

Can we compare dates in action flow? If yes, how?

I have to show top 3 vendors with pending balance in an email using Action flows. what PQL function can we use to sort top 3 vendors based on Amount column to apply same logic in Action flows? Basically, these values are same as if we create OLAP table and sort by Amount, but these has to build in a single KPI component as 3 KPIs.

I'm trying to add a filter to a table so I can do something similar to the search function for numeric dimensions (where I can select to filter greater than x). I haven't been able to code the filter. I want to be able to filter by Total or/and Total Canceladas >= x -NOM_SOLI: "CL_Auto_Autorizaciones"."NOM_SOLI" -Total: COUNT_TABLE("CL_Auto_Autorizaciones") -Total Canceladas: COUNT(DISTINCTCASE WHEN PROCESS EQUALS 'Cancelada' THEN "CL_Auto_Autorizaciones"."_CASE_KEY"ELSE NULLEND) -Porcentaje Canceladas: COUNT(DISTINCTCASE WHEN PROCESS EQUALS 'Cancelada' THEN "CL_Auto_Autorizaciones"."_CASE_KEY"ELSE NULLEND)/ COUNT_TABLE("CL_Auto_Autorizaciones") "CL_Auto_Autorizaciones" is the case table

Hi all, I would to show my 2 bar graph with the same time span, like next 12 month visible without moving scroll bar, even it doesn't have any data of a month. Where can I find the setting? or Can't I in celonis?

Where can I find all the reading material (ppts, pdfs) and templates provided by Celonis ?

Recently we decided to activate the SCIM functionality in Celonis so that user and groupsare provisioned automatically by the identity provider. Unfortunately it is not working and no connection to the Active Directory can be established and the functionality is not working. Are there any specific settings that need to be set in the Active Directory so that SCIM API can work as intendet?

How to schedule an action flow to trigger on a particular day? we are not using knowledge model.

This is how is set in the documentation:  and this is how I set the module: 

Team, I am using Content CLI to Pull and Push assets between different EMS. Is there a way to overwrite only one asset when pushing to a different EMS? I can see there is an option to overwrite packages with "--overwrite", but we want to push only one asset multiple times. Best regards!

Hi, i want to create in Open Order View (Open Order Processing) a Dropdown List where i can select a ORDER_ITEM Record which sets the X-Axis on a Graph. My problem is that it doesnt accept the variable as an axis, but if i use the record itself it works

Dear Celopeers, We have an SAP On-Prem extractor which make RFC calls with multiple SAP systems within our organization. We want to now add a new connection/SAP System but the connection has to be SNC. We already have the instructions for setting up SNC, but the question is Is it possible to use the same extractor and configure so that only one system needs an SNC and others work without those server certificates? Or If we want to add a new connection/system with SNC setupeither we must have the server certificates imported for all the existing systems or we we should have a separate extractor with SNC?  How does this work? To clarify, only system 3 in the picture needs an SNC.