Support
Academy
Documentation
Marketplace

Success Hub
Product Updates
Groups
Events

Home
Community
Product Q&A
General Product Q&A

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

2,559 Topics
5,879 Replies

When you subscribe we will email you when there is a new topic in this category

2558 Topics

Most replies

Most views

Newest first

ewa.aniśkLevel 3

asked in General Product Q&A

How can we apply colours to charts/process explorer/tables in Views?

155

12 hours ago

loretta.nelso12Level 1

asked in General Product Q&A

Where can I find JDE reference customers?

We are working with a prospect who uses JDE and he requested us this information.

17 hours ago

SabaLevel 4

asked in General Product Q&A

Filter

Hello everyone,I have a list of Material Numbers, and some of them belong to the P18 Business Unit, some to the P20 Business Unit, and some belong to both P18 and P20 at the same time.I created a Quick Filter to show only the materials that belong to P18, and it works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')I did the same for materials that belong to P20, which also works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')However, when I try to filter for materials that belong to both P18 and P20 at the same time, the following filter does not work correctly — it also shows materials that belong only to P18 or only to P20:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')AND "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')Do you have any idea how to fix this?Thanks!

2 days ago

sayan.chakr12Level 3

asked in General Product Q&A

How Can i connect the purchase side and sales side in a process explorer which will display the P2P-AP process in one side and O2C-AR process in one side AND the explorer should also display the connection between the 2 process flow??

I am working on an intercompany transaction where one subsidiary of the parent in buying material from a vendor which is a subsidiary of the same parent. Hence O2C-AR of the buyer should be synced with the P2P-AP of the vendor.

105

9 days ago

varvara.bachuLevel 2

asked in General Product Q&A

Wrong result when adding percentages

Dear Community,I want to calculate an average error rate for each year under certain conditions. Even though it may seem quite simple, I receive an incorrect result. 🤔This is my formula:COUNT (DISTINCT (“Table”.”Column”))/COUNT (DISTINCT (“Table”.”Column”)). The KPI “2023” has the following conditions as filters: Do you have any idea what is wrong with my formulas? Many thanks and kind regards,Varvara

110

9 days ago

thomas.keimLevel 4

asked in General Product Q&A

Create Table with field of various 1:N and N:1 Relations

Hello Community,I hope you can help me to find the best approach of my issue. My challenge is to build a table with the complete SAP Process Flow: Order, Delivery, ShipmentFor this I have created a data model with the following linked tablesVBAK (1) - (N) VBAP (1) - (N) LIPS (N) - (1) LIKP (1) - (N) VTTP (N) - (1) VTTK When I try to add fields from all tables into one studio table I get the following error:I have understand the problem but missing the best approach to solve it.What do you think? Is the a studio table with different PQL formulas the solution? If yes, how can I do it?Or is it better, when I create a table (e.g. TAB_PROCESS_FLOW) within the transformations that includes all the key columns and connect the other tables (VTTK, VBAK...) within the data model. So the table TAB_PROCESS_FLOW is like a case/common table.Best, Thomas

110

12 days ago

akash.suhag12Level 2

asked in General Product Q&A

i have activity table which have same timestamp(T) for multiple activities in a single case.for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C.but flow is A->B->C

i have activity table which have same timestamp(T) for multiple activities in a single case. for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C. but flow is A->B->C

216

16 days ago

srikar.akell11Level 2

asked in General Product Q&A

Is there a way to get the export of the data permissions

Hi, I want to know if there is a way to export the following listData model name ------ Data permissions ( Enabled/Disabled )if enabled then Group / User name ------ condition ( if any ) ----- unlimited (yes/no)i want to download this list as an excel, is it possible?

414

26 days ago

sayan.chakr12Level 3

asked in General Product Q&A

I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task te

193

26 days ago

.1460096356Level 2

asked in General Product Q&A

Change the name to an event

Hi! I would like to personalize the event names for a client demo. How can we do it? Regards

27 days ago

Sverre KleinLevel 6

asked in General Product Q&A

Asset Library not responsive

Hi all, I have a problem with loading the asset library, it shows the following error.Cannot read properties of undefined (reading 'children') Anyone has the same issue? Thanks!

200

1 month ago

jan.vajse12Level 3

asked in General Product Q&A

Shared link opens last user's selection

Hello,our users face regulary the issue that if someone sends them link with a certain selection, what opens is their last selection of the view and not the selection that was shared with them. Is there any known way how to overcome this setup? If you send somebody a selection, this selection should alway show up if the person clicks on the link. Thank you for any advice.Jan

214

1 month ago

Mst11Level 3

asked in General Product Q&A

Font size

Hello everyone,Does anybody knows what is happening with the font size of numbers in KPI Cards. Some of them are extremely big and some seem to be normal sized. Thanks a lot!

665

1 month ago

michaela.gebhaLevel 3

asked in General Product Q&A

Order Mgmt Execution App - Filtering on a range of postal codes

Dear Community,Is there a possibility to create a filter component in the Order Mgmt Execution App giving the users the possibility to filter on a range of postal codes from/to (similar like a date filter)?Thanks for your help!Kind regards,Michaela

1 month ago

SabaLevel 4

asked in General Product Q&A

Classiffy

Hi everyone,I have a column with many numbers, and I have uploaded a screenshot as an example. I want to classify them into groups. FYI: I know the maximum, minimum, and median, and I also know the total number of numbers.How can I do that?Thanks in advance!

9515

1 month ago

douglas.souzaLevel 3

asked in General Product Q&A

Variable Clear

Good afternoon/Good morning Celonautas, could any of you tell me if there is any way I can clear the variable? For example, the variable is disabled. I would like it to clear the variable from my dropdown when it is selected.Here is how it looks when I disable it.And how I would like it to look

131

1 month ago

SabaLevel 4

asked in General Product Q&A

Classification

Hello everyone,I have a coloumn with a lot of numbers and as an example i have uploaded a screenshot of it.I wanted to classify them into groups so i wrote a case when like this :CASE WHEN KPI("max_potential_saving") BETWEEN 7000 AND 70000 THEN 1 WHEN KPI("max_potential_saving") BETWEEN 1000 AND 7000 THEN 2 WHEN KPI("max_potential_saving") BETWEEN 800 AND 1000 THEN 3 WHEN KPI("max_potential_saving") BETWEEN 600 AND 800 THEN 4 WHEN KPI("max_potential_saving") BETWEEN 400 AND 600 THEN 5 WHEN KPI("max_potential_saving") BETWEEN 200 AND 400 THEN 6 WHEN KPI("max_potential_saving") BETWEEN 0 AND 200 THEN 7 ELSE 8 ENDbut when i sort it based on the classification it does not show the Max Potential Saving in order from highest to lowest. Does anyone have an idea ? Thanks in advance !

573

1 month ago

josh.bozziLevel 2

asked in General Product Q&A

Cropping the Process Explorer using a component filter

The Process Explorer can have its activities cropped via use of the Crop Selection page filter, however when using the formulas CALC_CROP and CALC_CROP_TO_NULL in its component filter, the Process Explorer fails to crop Can the Process Explorer be cropped via component filter? If yes, what is the correct formula / way to do this?

244

1 month ago

jonas.hessLevel 3

asked in General Product Q&A

See no Records in smart Sensor

RecordsHello, unfortunatly i could not see any Records in my smart sensor, anyone familiar with this Problem? ThxHeSee no Records over here

1 month ago

omar.elmouLevel 3

asked in General Product Q&A

Dear Celomates,I would like to add the rework rate as a KPI without using PQL.

I have added an OLAP table with three columns where the Count of activities is compared to the Distinctcount activity for each case key. Please find attached the OLAP table. Besides the OLAP table i would like to show the rework rate as one number by referring to the formula and outcomes of the OLAP table. How can i add a number (without using PQL) where the ration of cases with a YES", as displayed in the OLAP table, is returned as one percentage. Many thanks!

242

1 month ago

marcin.konop13Level 3

asked in General Product Q&A

Custom Attribute not available for KPIs

Hi all I have created a simple attribute that calculates a metric I will be averaging out. And in the table it looks fine. However whenever I try to call it I get an error Please assist. I presumed as documentation states that those calculated attributes are treated the same as values in a column. KindestMarcin

338

2 months ago

ritesh3719Level 3

asked in General Product Q&A

How to Apply Role-Based Access Filters in Celonis for Users?

In our team, we have different roles assigned to users, such as Junior Buyer and Tactical Buyer. I want to ensure that when they access Celonis, they only see records relevant to their role.We have a mapping between user and their assigned documents (Purchase Requisitions, Purchase Orders, etc.) in a table. Based on their role, users should see only the documents assigned to them.

311

2 months ago

HafsaLevel 2

asked in General Product Q&A

celonis Vs camunda

Hello,I want to know why using Celonis and not Camunda for process improvement? I made some research and I found that with Camunda optimize I can get visualisations ..., logs from Camunda execution. So I need to know the ++ of Celonis compared to Camunda in term of improvement results and process optimization and not the approach.Thank you

230

2 months ago

puneet.duaLevel 1

posted in General Product Q&A

Can anyone confirm if we can extract the KPI data in excel format

133

2 months ago

SabaLevel 4

asked in General Product Q&A

Merge or Combine

Hello Everyone,In my View, some numbers appear twice — one row contains lead time and price for version A, and the other row contains lead time and price for version B.So for a specific number, you either see data for version A or version B, but I want to combine them into a single row for that number.Here’s an example of how my data looks now:Number Lead Time A Lead Time B Price A Price B 12345 28 - 10.88 - 12345 - 7 - 6.94 And this is what I want to get:Number Lead Time A Lead Time B Price A Price B 12345 28 7 10.88 6.94 Is there a way to do this?Thanks a lot!

1087

2 months ago

Page 1 / 103

Badge Winners

Graham Holmeshas earned the badge Qualified to Deliver Business Value with Celonis
Graham Holmeshas earned the badge Qualified to Create and Deliver Demos
ismael.jimenhas earned the badge Value Realization Expert
ismael.jimenhas earned the badge Qualified to Deliver Business Value with Celonis
yuri.fujimhas earned the badge Qualified to Get Data Into Celonis