Skip to main content

Unanswered Questions

35
louis.forst11
Level 3
louis.forst11Level 3
 Process Analysis
Stacked Bar Chart

Hi, i have a Bar chart with the time axis on the x-axis and on the y axis how much the money was. Is there a way to break down the y axis graph into the specific vendor_names, there are around ten. How could i do it in a view.  Thanks in advance

61
N
Celonaut
michael.kaemp
Level 3
michael.kaempLevel 3
 Process Analysis
assign date value from an augmented attribute to a variable and use it

Hi together, I'm working with legacy views and can't manage to pass the value of an augmented attribute of type date to a variable to use it as parameter for KPIs. The record containing the augmented attribute  - id: CM_MONTHS    identifier:      id: id      displayName: Id      pql: '"CM_MONTHS"."MONTH"'    attributes: []    newAttributes: []    augmentedAttributes:      - id: late_creation_deadline_date        displayName: "Late Creation: deadline date"        possibleValues: []        columnType: DATE        format: "%Y-%m-%d"        housekeeping: false        type: AUGMENTED_ATTRIBUTE    flags: []    priorities: []    triggers: []    businessRules: []    type: RECORD    origin: PACKAGE The component to update the augmented attribute  type: table  settings:    data:      columns:        - id: 3486adcd-a996-49a5-97e0-af17da07e9af          field: CM_MONTHS.MONTH          order: 100        - id: 10c08937-649f-48a0-88fe-929d3107e824          field: CM_MONTHS.AUGMENTED_late_creation_dead

351
michael.kaemp
Level 3
michael.kaemp
Level 3
michael.kaempLevel 3
 Process Analysis
Concat references

Hi together, there's spaghetti in my head. I have the feeling like it should be possible, but can't figure out how to.I've a table like this A B 0 NULL 1 0 2 1 3 1 4 1 5 1 Column A contains the case key, B can contain a case key as a reference. E.g. case 1 refers to case 0. And the cases 2, 3, 4, and 5 refer to case 1. Now I want to "turn around" the reference so that there is a new column that shows e.g. for case 1 that it's referenced by 2, 3, 4, and 5. The result should look like this: A B C 0 NULL 1 1 0 2, 2, 3, 4 2 1 NULL 3 1 NULL 4 1 NULL 5 1 NULL Any ideas? 

10
michael.kaemp
Level 3
Saravanavel
Level 2
SaravanavelLevel 2
 Celonis Academy Group
Celonis Certificate Exam, not able to complete the exam, start button is not visible "The website encountered an unexpected error. Try again later"

Celonis Certificate Exam, not able to complete the exam, start button is not visible "The website encountered an unexpected error. Try again later". Please help to fix this issue and proceed for exam.

403
Nicole Wendler
Celonaut
natnapin.ketch
Level 2
natnapin.ketchLevel 2
 General Product Q&A
How to sort the filter in Platform Adoption View

In the Platform Adoption View downloaded from the Marketplace, there is a filter bar, and the list of dropdown values in each filter is sorted alphabetically. However, I noticed that there are numbers displayed next to each value, indicating the number of views.I would like to know if it's possible to sort the list by the number of views (e.g., from highest to lowest) instead of alphabetically by name. Alternatively, is there a way to hide the number of views displayed next to each value? Example of dropdown filter: 

110
natnapin.ketch
Level 2
A Rab
Level 2
A RabLevel 2
 General Product Q&A
Executing Data Model Schedule from Action Flow

Hi,Do you know if there is a way to execute an already exist Schedule in the Data Model from the Action flow. I have an Action Flow that updates some fields in the source system, and I want the data jobs (extraction, transformations, and data model load) to be executed as the last step of the Action Flow, so the updates will be available in the dashboard as well. Thanks.

60
A Rab
Level 2
Chethan Shetty
Level 2
Chethan ShettyLevel 2
 Process Improvement
Form Design in Celonis

Hey, I’m beginner in Celonis and started my learning. I wanted to know Can we build a user form which helps me to collect the data from user and store it designated table. I also have set of rules for forms like show this field if user in particular role or make the field editable only if certain condition matches with current logged in user otherwise just keep it as read only and so on. Can this be achievable in celonis. Looking forward for response. Note: Pease share screenshot how it will look if you have anything sharable in this forum. Thanks & RegardsChethan Shetty

184
Chethan Shetty
Level 2
emily.helve
Level 2
emily.helveLevel 2
 Process Analysis
Combine ERDAT and ERZET fields into single timestamp

Using PQL in the VBFA table, I need to combine the date and time into a single timestamp.Both the ERDAT (date) and  ERZET (time) fields are formatted as complete timestamps in our data model.I succeeded by converting both fields to strings, combining them, then converting the combined string back to a date.TO_DATE(TO_STRING ("VBFA"."ERDAT" , FORMAT ( '%Y-%m-%d' ) )||' '||TO_STRING("VBFA"."ERZET", format ('%H:%M:%S')), FORMAT ( '%Y-%m-%d %H:%M:%S' ) )Is there a more direct approach I could use to obtain the same result? The conversion to string seems  unnecessary.Thank you.

70
emily.helve
Level 2
emilia.stepi
Level 2
emilia.stepiLevel 2
 Data Ingestion & Infrastructure
Restricting access to specific data model column

Hello everyone,I want to restrict access to a specific column in a data model so that non-admins cannot see the values in that column or the column itself. Is there a way to achieve this using data permissions? Thank you!Best,Emilia

252
benjamin.delay
Level 2
jagjeet.singh12
Level 2
jagjeet.singh12Level 2
 General Product Q&A
Duplicate Vendor/ Invoice Identifier

I would like to understand how we can leverage Celonis functionalities to identify duplicate invoices or vendors. What are the different approaches available in Celonis to achieve this

80
jagjeet.singh12
Level 2
shane.proct
Level 3
shane.proctLevel 3
 Process Analysis
Filtering for last activity of each day.

In an OLAP table, I am looking at sales documents "VBAK"."VBELN".  I only want to see the last change of each day.  How do I filter for the last "_CEL_O2C_ACTIVITIES"."EVENTTIME" of each day?  I’ve experimented with PU_MAX, but I keep getting errors.

212
julia.bauer
Level 5
julia.bauer
Level 5
julia.bauerLevel 5
 Process Analysis
Input Button Dropdown in JAB Views

Hello everyone, I’m currently migrating an old view to a JAB view. In the old view I had an input dropdown (made with a custom object “Time Dimension” with the content columns: Year, Year-Month, Quarter, Week, Day). In the new JAB view I now want to implement this as well (filtering charts according to Quarter, Week and so forth). I’m already aware of the Celonis documentation: Configuring user inputs (input box, input dropdown, button), but this is really too intransparent for me.  Can someone give me a step by step guide on how to implement this?I already created a variable as object like this: {"Year": "String","Year-Month": "String","Quarter": "String","Week": "String","Day": "String"} However, within the input dropdown component, I don’t know how to proceed as the dimensions Year, Year-Month, Quarter, Week, Day are not stored in a single attribute/dimension. They are all calculated with the EVENTTIME separately. Thanks in advance! Best regardsJulia Bauer 

10
julia.bauer
Level 5
julia.bauer
Level 5
julia.bauerLevel 5
 Process Improvement
Add Powerpoint Attachment to Mail Sent by AF

Hello everyone, this is my current AF setup: The setup works fine, however, I have received the requirement to add a powerpoint attachment to the mail sent via the AF. This powerpoint is static and is only a training document for the recipient. Is it possible to add attachment from your computer to be sent out by the AF itself? I cannot add this via the data and title fields since it’s already ready and static. Thanks! BRJulia Bauer

192
julia.bauer
Level 5
Saba
Level 4
SabaLevel 4
 AI
Annotation

Hi everyone,I want to use the Annotation Builder, but I don’t have a unique ID.For example, the same material number exists in two different business units as you see in the picture.What’s the best way to handle this? Thanks for your help!  

524
Saba
Level 4
Yannick Noubissi
Level 2
Yannick NoubissiLevel 2
 Process Analysis
How to filter table rows based on aggregated column values in Celonis?

Hi everyone, I’m working on an analysis in Celonis and I have a question regarding filtering table rows.In my case, one of the columns in my table displays a sum of values retrieved from the backend (e.g., SUM("SomeColumn")). I would like to exclude all rows where this sum equals zero, so they don’t appear in the final table.How can I apply such a filter directly in the table configuration or via a filter condition?Thanks in advance for your help!

121
N
Celonaut
Kamil Deren
Level 2
Kamil DerenLevel 2
 General Product Q&A
Active Action Flow list

Hi, I am trying to create a list of Action Flows using PyCelonis and I want to also add status if the Action Flow is currently active or not. I was trying to do it .get_action_flow(id).dict()/json()/json_dict() but there is no parameter there that would indicate if the Action Flow is activated or not.Thanks in advance for any replies :)

141
N
Celonaut
phil.cook
Level 3
phil.cookLevel 3
 Process Analysis
Identifying the First Instance of an Activity as well as Its Follow-up Activity

HelloIn a scenario where there are multiple instances of “WIP CB IP” activity, I am trying to identify the first instance along with the next activity taken by a user.  I am easily able to identify the first WIP activity (highlighted in blue) using PU_FIRST.  However, when I attempt to identify the next activity following the first WIP, I end up retrieving the activity for the 2nd WIP line (highlighted in yellow and red).   I would like to report on the activity highlighted in green.I have tried wrapping the PU_FIRST within the ACTIVITY_LEAD but the syntax failed indicating that “/IRM/IPCBITM” is not within the Activity table.  I have also attempted to use a CASE WHEN statement but that just generated two WIP lines.  I am only interested in the first instance of WIP.Thanks in advance,Phil  

180
phil.cook
Level 3
harshini.gampa12
Level 2
harshini.gampa12Level 2
 Process Management
Report Generation -- Standards and Standards Chapter matrix , Process performance analysis

Hi Team,We would like to generate the Reports in Process designer i.e Standards and Standards Chapter matrix , Process performance analysis .Can you guide us how to create the above mentioned highlighted contents in report.

40
harshini.gampa12
Level 2
gayathri
Level 3
gayathriLevel 3
 Community Connect
Request to Swap First and Last Name on Profile – Urgent & No Response from Support

Hello Celonis Community Team,I’m reaching out regarding an important update I need on my Celonis profile. I would like to swap my first and last name – currently, they are displayed in reverse order.Despite emailing support three times over the past few weeks, I haven’t received any response. This update is crucial for my certifications and professional visibility. I kindly request your assistance in getting this corrected at the earliest.Please let me know if any additional information is required from my end. I appreciate your help and look forward to a quick resolution.Thank you,[Gayathri Vanam ][vanamgayathri13@gmail.com]

494
cristina.gómez11
Celonaut
carmen.kaluz
Level 3
carmen.kaluzLevel 3
 Data Ingestion & Infrastructure
Use App Key for content-cli in ML workbench

Hi all,I would like to export datapools as json using content-cli in the ML workbench in order to backup them in Git. I have created an API key in my profile and used it in a python script with content-cli pull data-pool --id data-pool-id, which successfully generated a json of the datapool.However, I don't want to do this with a user-based API key but with an Application key (created under admin&settings).When I run the same command using the Application key, I get the error "error: The provided team or api key is wrong."With get_celonis(api_token=“applicationkey”, key_type="APP_KEY") however, I can see the Application key and all its permissions.Is content-cli possible with an Application key and if so, how can I use it?

293
carmen.kaluz
Level 3
christine.gentr
Level 2
christine.gentrLevel 2
 Process Analysis
Need Help Fixing PQL script to look for a variable direct after a wildcard search using the LIKE function

Hi,I need help fixing my PQL scriptCASE  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 1%' THEN 'Criteria 1'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 3%' THEN 'Criteria 3'  WHEN "SHOPPING_DETAILS_DESC" LIKE '%CRIT% 5%' THEN 'Criteria 5'  ELSE NULLEND I am trying task search in a text field (Shopping_Details_Desc) for cases where ‘%CRIT%’ is identified. I would then like the code to assign a Criteria when the number ‘1’, ‘3’ or ‘5’ follow directly after the we wildcard search. I am pulling errors because there are other numbers in the text description and the code is incorrectly assigning them because it is find any any ‘1’ (as an example) that comes after ‘CRIT’ and then calling it a ‘Criteria 1’, even when it is a Criteria 3.  My issue is that sometimes our operators are miss writing the text so we are trying to capture either CRIT or CRITERIA, or anything in between - which is why I want a wild card.  I was able to write a statement in DAX to be able to look for a number assigned direc

224
christine.gentr
Level 2
julia.betzl
Level 3
julia.betzlLevel 3
 Process Analysis
Error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account.

Hi all,  I created an attribute (“MARC”.”cond_mbew_compl_vprsv”) as a boolean with the following formular:CASE WHEN(  ( "MARC"."BESKZ" = 'E' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'S' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."STPRS")) = 0 ))    OR  ("MARC"."BESKZ" = 'F' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'V' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VERPR")) = 0)))THEN 1 ELSE 0 END Now I want filter like followed: FILTER "MARC"."cond_mbew_compl_vprsv" = 1 This does not work and I got the following error message: Calculated attribute ["MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account. Can you help me what I should change? Thank you. Regards

202
julia.betzl
Level 3
Saba
Level 4
SabaLevel 4
 General Product Q&A
Attributes in Records

Hello everyone,I’m trying to create a new Record and Attribute in the Knowledge Model, but it seems that after creating them, I can’t use them.Record: "o_celonis_Material"Attribute:pu_last( "o_celonis_Material", bind("o_celonis_StockHistory", "o_celonis_MaterialMasterPlant"."id"), left("o_celonis_MaterialMasterPlant"."id", 3) = 'p18' ) Does anyone have any idea? 

222
Saba
Level 4
Sverre Klein
Level 6
Sverre KleinLevel 6
 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!

603
janpeter.van.d
Level 8
Kusum Bhadoria
Level 2
Kusum BhadoriaLevel 2
 Celonis Academy Group
Academic Process Mining Fundamentals

I have completed my course track “Process Mining Fundamentals” but the course badge is not received yet. I have attached the image that I completed proof of that track. What can i do for solving this issue?I have already registered my issue on "Contact Academy Support Team" but there is no solution yet

171
cristina.gómez11
Celonaut

Badge Winners

  • Celonis Certified Data Analyst
    misri.hetalkumar.parikhas earned the badge Celonis Certified Data Analyst
  • Qualified to Create and Deliver Demos
    darko.duric11has earned the badge Qualified to Create and Deliver Demos
  • Celonis Technical Expert
    Pranavnhas earned the badge Celonis Technical Expert
  • Qualified to Get Data Into Celonis
    Pranavnhas earned the badge Qualified to Get Data Into Celonis
  • Celonis Technical Expert
    Gero Busatishas earned the badge Celonis Technical Expert
VIEW ALL
Community Code of Conduct