General Product Q&A

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!

Hello All, can anyone share how to best respond to customer concern on subjecting their tables to cloud environment and is there any on premise option in Celonis? Thanks you

Hi, How can I "hide" a published package inside a space? Just like i can hide (Visibility On/Off) the assets inside a package, i was looking for a solution for hiding the whole package. thanks

I would like to do a dropdown but I keep getting a message that "The aggregation function SUM cannot be used toether with dimension function input. I tried making saved formulas for my code, but also I've got error. Have you got idea how to do it?

Is it possible to calculate troughputtime between and activity and an attribute (also a timestamp, but modeled as an attribute because it is not a process step)? Thanks for the help!

Hy Guys! I would like to count how many activities started from the year 2023 ? You know?

@Ezgi Türksoy​ @bugra cabuk​ @emre.karad​ @Vildan Aslan​ you can follow up.

Hi Community! How can I use the View Variable into a Filter expression?

I need access for PQL Queries Certification which I almost near to pass the exam and already used Couple of time.

Hi, I need to create a list of all table names and columns in each table that we have in Celonis.  I've tried pycelonis, but while I can get the tables the columns list showed as empty when using get_tables(): DataPoolTable(name='LFA1', data_source_id='xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx', columns=[] ,...) I've also tried using sql query: select table_schema, table_name from v_catalog.columnsbut got error: "Not allowed to access schema v_catalog" Is there a way to quickly download such list? Thanks,Karol

We are seeking to access detailed data from the accounts receivable demo, but we are unsure of the process to export this data. Could anyone kindly provide guidance on how we can achieve this?

Hi all, can you advise the SAP table number that is used for Plant Maintenance. Is there an example log file for Plant Maintenance or table scheme? Thank you.

Hi Community, can anyone tell me if there is a maximum number of eventlogs (activity tables) that can be used in a data model? Thanks Himanshu

 I defined variables for the dates in order to operate different KPI's. In my case Base Dates effect KPI 1, Current dates effect KPI2. my dates are variables (Date_1,2,3,4)as you know datepicker effect the whole analysis.Note: CAUFV.GLTRP is a date table column KPI_1 Component FiltersFILTERROUND_DAY("CAUFV"."GLTRP")>= to_date( <%= Date_1 %>,FORMAT('%Y-%m-%d’))ANDROUND_DAY("CAUFV"."GLTRP")< to_date( <%= Date_2 %>, FORMAT('%Y-%m-%d’)) ; KPI_2 Component FiltersFILTERROUND_DAY("CAUFV"."GLTRP")>= to_date( <%= Date_3 %>,FORMAT('%Y-%m-%d’))ANDROUND_DAY("CAUFV"."GLTRP")< to_date( <%= Date_4 %>, FORMAT('%Y-%m-%d’)) ; @bugra cabuk @Ezgi Türksoy​ 

It appears regardless of the given arguments or complexity. Celonis version: 4.6 Thank you for your help! 

Please improve this code,  FILTER MATCH_ACTIVITIES ( "finalResult_0_005"."ACTIVITY" , NODE ['<%=display_code_1%>'] ) = 1; so that when nothing is assigned to the display_code_1 value, it displays all the data. I tried  FILTER CASE WHEN '<%=displayCode_1%>' IS NULL THEN 1 ELSE MATCH_ACTIVITIES("Correlation_0_0075_remove_1st"."ACTIVITY", NODE['<%=displayCode_1%>']) END = 1  this code but it did not worked. It returns MATCH_ACTIVITIES: Could not find activity []. this message.  Thank you 

I am trying to understand how can I use a Signal Link Explorer (SLE) component in a view.  I found in Celonis documentation orientation about Network Explorer (NE), even it is mentioned that exists SLE, but I didn't find further information about it.  I would like to access an explanation about the YAML components of it.  I found it applied at Inventory Management app and I would like to use it, but I didn't understand how to get there.  I hope someone is able to help me on it. 

I would like to concatenate a date and time coming from a specific table into a single column, but I get the following message:Operator requirements are not met. Operator 'CONCAT' is not compatible with inputs of type DATE. Is there some workaround to concatenate DATE type?