Product Q&A

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!

i have got some excel and csv files to work upon im not able to add this data into celonis ems platform and do further operations

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?

Hi Team,I want to group together another set of dimension on top of already "Case when" KPI which gives an output of 1 or 0 on top of which i need to set a group by where it is showing a,b,c etc groups where 0 and 1 is of group "a" and 0 and 1 should be of group b etc. I have the current available kpis.   

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?

With display rules, I can customize visual styling for the content based on the cell value. However, I would like to use the comparator against another value. In my specific example, I want to add priority symbols next to each PO number based on another attribute, for example the delivery date or net order value. For the latter, I want to define buckets and then map them into priorities that should be the value to compare against in the display rule. You can think of the feature custom conditional formatting in Excel. Is this possible? CheersIrfan

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.