General Product Q&A

Can we change Data model of an existing Knowledge model? As I am trying to change the data model, I am getting Data model fail notification.

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

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! 

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.

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

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 

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

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?

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 templates?

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

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

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!

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 

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! 

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  

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 !

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?

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

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!

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

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.

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  

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

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!

Hi, I want to edit the Extensions in the Open PO Management App but I am getting the following error message:Runtime variable ErrorThe variable Cannot read property 'PO_NUMBER' of null. Please make sure that this variable is defined.Which step am I missing? I tried to add PO_NUMBER as a View Variable and as a Runtime Variable.Thanks and best regards,Sharon