Skip to main content

General Product Q&A

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

  • 2,575 Topics
  • 5,906 Replies
2574 Topics
A
Level 2
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

276
herique.sarme
Level 3
srikar.akell11
Level 2
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?

464
benjamin.strem12
Level 2
S
Level 3
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

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?

193
Dhilip Kumar Vijayan
Level 2
.
Level 2
.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

133
andré.tafur
Level 4
jan.vajse12
Level 3
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
jan.vajse12
Level 3
Mst11
Level 3
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!

765
J
Celonaut
michaela.gebha
Level 3
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 

90
michaela.gebha
Level 3
Saba
Level 4
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! 

9715
matthias.gielk11
Level 3
douglas.souza
Level 3
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  

151
jonas.hess
Level 3
Saba
Level 4
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
Julie Shih
Celonaut
J
Level 2
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?

384
Poovarasan
Level 2
jonas.hess
Level 3
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

50
jonas.hess
Level 3
omar.elmou
Level 3
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!

272
Poovarasan
Level 2
marcin.konop13
Level 3
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

468
rita.kiss12
Level 4
ritesh3719
Level 3
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.

371
janpeter.van.d
Level 8
Hafsa
Level 2
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  

380
Hafsa
Level 2
P
Level 1
puneet.duaLevel 1
posted in General Product Q&A
Can anyone confirm if we can extract the KPI data in excel format

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

133
bruno.castr
Level 2
Saba
Level 4
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!

1137
abhishek.chatu14
Level 7
sharon.josep13
Level 2
sharon.josep13Level 2
asked in General Product Q&A
Edit Extensions in Open PO Management App

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

90
sharon.josep13
Level 2
R
Level 2
ramasrikari.donta12Level 2
asked in General Product Q&A
Initially I had four attempts to complete the Rising star technical assessment. I failed in the first two attempts of the first section. Now it shows 0 attempts remaining.I have competed all other sections.Please guide me how to restore those at

Initially I had four attempts to complete the Rising star technical assessment. I failed in the first two attempts of the first section. Now it shows 0 attempts remaining.I have competed all other sections.Please guide me how to restore those attempts.

355
Saurabh Raut
Level 2
marilyn.torta
Level 2
marilyn.tortaLevel 2
asked in General Product Q&A
Requested column of table is not present in the according parquet file

HI everyone! I’m getting this error message when trying to Load my data model with a new table: “The requested column EKKO.INCO1 of table Agreements is not present in the according parquet file” .However the table “Agreements” is created in the data job with the same functions as any other table in the data model (“Create table Agreement AS ( Select CAST (EKKO.INCO1 AS VARCHAR) AS "EKKO.INCO1"...etcetc) so I don’t understand where this “parquet file” format is coming from… any idea?

232
marilyn.torta
Level 2
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
Is there any way to implement custom objects in new view

I want to create an Aging/Market custom objects so my graph can be change based on dropdown I will select. let say If you select Aging then aging should be applied on the chart.  How to implement in new views?

424
kailash.potha12
Level 5
D
Level 3
deepti.gandhLevel 3
asked in General Product Q&A
Excel file with Activity definitions and the conditions

Hi, Came across the below slide in Partner asset library but couldn't find any file in the below format. Can you please let us know where to find activity definitions for a particular process along with the conditions used. Thanks.Regards,Deepti

295
Adam Smith
Level 2
K
Level 1
kartic.rawatLevel 1
asked in General Product Q&A
Hi, I am not able to finish the Exercise - Push Flat Data via ML Workbench and Exercise - Push Nested Data via AWS CLI as in both the cases even though I am doing all the steps correctly still it is giving me S3 file upload error.

Hi, I am not able to finish the Exercise - Push Flat Data via ML Workbench and Exercise - Push Nested Data via AWS CLI as in both the cases even though I am doing all the steps correctly still it is giving me S3 file upload error.

192
chijioke.okonk
Level 2
s.a14
Level 3
s.a14Level 3
asked in General Product Q&A
Account Hierarchy

Hi, Is there a way to arrive at hierarchy of accounts as shown below using SQL (or) PQL?I need to identify the first sold to account (ZSLD) for partner 2 using Table1 and Table2Example  

30
s.a14
Level 3

Badge Winners

  • Celonis Technical Expert
    Clarahas earned the badge Celonis Technical Expert
  • Solution Creation Expert
    Clarahas earned the badge Solution Creation Expert
  • Qualified to Build Views
    Clarahas earned the badge Qualified to Build Views
  • Celonis Certified Data Engineer
    dhruv.suvar11has earned the badge Celonis Certified Data Engineer
  • Value Realization Expert
    julia.portehas earned the badge Value Realization Expert
VIEW ALL
Community Code of Conduct