Product Q&A

Hello community,I try to use a display content rule in a view component (table) based on a date. 💅  In the documentation /help/display/CIBC/Views+Components#ViewsComponents-DisplayRulesdisplay-rule it states e.g. the comparators:"DATE_IS" # for 'date' "DATE_IS_BEFORE" # for 'date' "DATE_IS_AFTER" # for 'date' The question I'm asking myself is about the formatting of the Value --> in which time format do I need to enter the value?My guess was "same as in Knowledge Model attribute's definition", but that didn't work for me. I would be very happy if someone could share an example configuration of a Display Content Rule with a date value. Thank you, community! 😊 ​

Is there a best practice to chose a KPI (saved Formula) over a variable in Celonis (or vice versa)? For example, I seem to recall that all KPIs are calculated upon loading the analysis? Would that make certain uses more suitable to a variable?

Hi there, this probably has some super simple solution but im kind of stuck at the moment.I basically want to count, how often a certain activity happens per case. My idea was to apply a filter so that i only have rows containing that activity. For example i now have 4 collums with case id 1. Now i just want to create a new collum that shows how often the activity was done in each case by just counting how many rows share the same case id. For example of case id 1, there should be a collum at the end, that shows "4" in every row with the case id 1. Thanks for your help once again and kind regardsAaron

I want to make a Simulation. The Simulation depends on the weekly data of - how many parts do i've to produce- how many peaple are present in this week- the expected duration of the machines (OE)(eg. 100 hours active of 120 possible hours is 83%)- number of shifts is it possible to change the data of the OE for example in an table in the front end to see the impact of this change on the output.

Hy,In analyses when we add a KPI in an OLAP, the OLAP automatically filters but in view tables I am seeing 0's with 1's, I want to exclude all the 0's and that too based on a view variable Any help ?

This is my formula:AVG(CALC_THROUGHPUT(ALL_OCCURRENCE['Process Start'] TO ALL_OCCURRENCE['Process End'], REMAP_TIMESTAMPS("_CEL_MERGED_ACTIVITIES"."TIMESTAMP", HOURS, MONDAY 06:00 - 14:30 TUESDAY 06:00 - 14:30 WEDNESDAY 06:00 - 14:30 THURSDAY 06:00 - 14:30 FRIDAY 06:00 - 14:30)))Will Celonis look at my actual timestamps or use UTC time?

Hi there,i've been doing some tasks for uni and stumbled across a task where i need to return 'AB' if activity A happened before B and 'BA' if B happened before A. We can assume that always exactly one of the cases is true, so no null solutions. I tried the following PQL formula but it doesnt seem to work:  CASE WHEN(PU_Last("case-table", "activity-table"."ACTIVITY", "activity-table"."ACTIVITY" = 'A') < PU_Last("case-table", "activity-table"."ACTIVITY", "activity-table"."ACTIVITY" = 'B'))THEN 'AB'ELSE 'BA'END For some reason the first case never happens. Anyone having any ideas?Thanks for your help and kind regardsAaron

for a given vendor we have an invoice date and I would like to find the date of the last invoice relative to this current date. So for example we have date of invoice for given vendor 2.01.2023 and I would like to find date of last invoice for same vendor, that is for example 1.01.2023.In celonis I would like to have in one column the date of the "current invoice" and in the other column the date of the previous invoice 

I would like to add a status selection functionality in the studio. I would like to have a default status of 'To checked' and for the user to be able to change to 'to be checked'. Does anyone have an idea how to do this?

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

 Execution error: Not allowed to access schema "VBAP" After I have extracted the necessary tables from SAP. I am in the transformation phase and I want to see the output of my SQL code after executing the code in Transformation Statement.However, I get the following error:  Execution error: Not allowed to access schema "VBAP"I am an admin in Celonis.

After I have extracted the necessary tables from SAP. I am in the transformation phase and I want to see the output of my SQL code after executing the code in Transformation Statement.However, I get the following error:  Execution error: Not allowed to access schema "VBAP"  I am an admin in Celonis.

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 Everyone,I have the following situation and problem: I created a variable, based on a "Store"-Table used to dynamically filter dashboards and analysis. The stores-variable is loaded from a table as a "text/replacement"-variable. I used a dropdown-menu to select certain stores. The analysis are then filtered by this selection. So, when you select "Store A" and "Store C" but leave out Store B you only get to see data from those two stores, but not Store B. Here is the problem: When I then want to reselect "Store B" the field to do so is greyed out. Furthermore if I deselct every Store the dropdown-menu is completly empty. I can no longer reselect any. It is as if the menu has forgotten these entries ever existed. So:How i build a dropdown menu to dynamically filter analysis and select/deselect and reselect any attributes?  Thanks for your help in advance!

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?

Hi. My team has been developing an Action Flow that sends a CSV attachment in an email for the customers that have due payment. The problem is that the customer wants to receive their invoices grouped by the reference number but the actual GROUP BY function that Celonis have makes the reference number divide the attachment so in this case the same customer would receive 2 or more emails instead of just one.We already implemented some tools for separating the CSV text with (,) so we want to know if exist something similar for this case. Thanks in advance :D

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!