Skip to main content

Unanswered Questions

29
julia.bauer
Level 5
julia.bauerLevel 5
 Process Improvement
Augmented Attribute Behavior

Hello everyone, I’m using an augmented attribute  “Sendout y/n” which is based on this record identifier: EORD → Material || Plant || Supplier. This attribute is used within a dashboard and can be manually set for the default value “no” to “yes”.  In the case a user changes this combination: Material: 123456, Plant: XY, Supplier: SupplierA → 123456XYSupplierA → Sendout (Augmented Attribute): Yes, I can then use this attribute for a connected AF. Let’s say the SAP EORD table data changes → orderbook changes the record identifier would now be: Material: 123456, Plant: XY, Supplier: SupplierB → what would now happen? Would the combination 123456XYSupplierB be on Sendout: Yes? Or would the augmented attribute as it is based on the MATNR, WERKS, LIFNR know that the identifier itself changed and be by default No again? When changes occur I would need the combination 123456XYSupplierB to have the augmented attribute with: No by default. I’m assuming that this will be the case, however, I’m no

162
julia.bauer
Level 5
frederick.coutr12
Level 3
frederick.coutr12Level 3
 Celonis Academy Group
Cannot create support ticket in Academy

Hi,Sorry to post this here but I cannot create a support ticket for Academy. I get an error message saying “Controlling picklist doesn’t seem right”. I tried from MacOs, Safari, Chrome and even Edge in Win11, all with the same problem.  

261
nora.stüle11
Celonaut
Robin Böhler
Level 2
Robin BöhlerLevel 2
 Process Analysis
Capturing User Filters in Action Flow for Excel Export

We are currently looking for a way to capture the filters applied by a user and include them, along with data from tables, in an Excel export triggered by an Action Flow.However, we are currently unable to access or retrieve the filter information within the flow.Has anyone developed an approach or working solution for this scenario? Any help or guidance would be greatly appreciated.

40
Robin Böhler
Level 2
manuel.wetze
Level 5
manuel.wetzeLevel 5
 General Product Q&A
How to analyze User behaviour within Views for UX improvement?

Dear all,I was wondering if there are any approaches on how to measure how endusers are actually using the dashboards. With the purpose of improving usability.Does anyone have any approach on how to do this within the platform or by any workarounds on logs or even third party tools? Do you have any other appraoch to determine what the user really needs? Example key question would be:Which views get accessed how often?Which tabs get viewed how often?Which filters get used?Context: Naturally when developing custom dashboards you are implementing a lot of small requirements and end up always adding more functionally and therefore complexity. To have an aggregated analysis on how the users navigate a series of linked dashboards would help to remove less frequent used parts. 

152
S
Celonaut
bhargav.bhima
Level 2
bhargav.bhimaLevel 2
 General Product Q&A
Need help with PQL filtering

Hi,What I’m trying to do is essentially pick the last but one non-automated user from the event log and pull it to object level. The previous non-automated user needs to be different from the last non-automated user.In the sample data shown below the desired output would be JANE.I’ve tried looping one PU_LAST and using it as filter for another PU_LAST but doesn't seem to be working.PU_LAST( OBJECT ,  EVENT_LOG , EVENT_LOG NOT IN (PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN (‘AUTOMATED’) ))  ,  ’AUTOMATED’).EVENT LOG ID USER 1 JACK 2 JANE 3 JOHN 4 AUTOMATED 5 JOHN  Any insights would be much appreciated.

203
S
Celonaut
TheoM
Level 2
TheoMLevel 2
 Celonis Free Plan
How do I access the Celonis Free Plan platform ?

Hello, I’ve registered today to access the Celonis Free Plan demo platform (with demo data, etc), but I can’t seem to find the link needed to get to it. I’ve tried using https://id.celonis.cloud/ but it only gets me to a User Management screen. Thank you

10
TheoM
Level 2
J
Level 2
jacob.visse14Level 2
 General Product Q&A
I am using the " target=_"blank" statement in a text button to open a new tab with a link to Celonis documentation. But it opens in the same tab as my analyses. How to solve this?

Below an example of the code I am usingFor detailed information go to Celonis info page:<a href="https://docs.celonis.com/en/process-ai.html"target=_"blank"> Process AI</a>

145
milan.eric
Level 3
andres.naran12
Level 4
andres.naran12Level 4
 Data Ingestion & Infrastructure
How to get KPIs values through PyCelonis?

Hi everyone, some months ago, I faced a challenge related to getting variables from a view using PyCelonis. Today I have another challenge where I need to get the result from multiple KPIs and send it back to the data pool.At the beginning, I used the module “Get Rows” from action flows, and I was able to get the values from each KPI. However, in some KPIs, the values that I’m getting inside actions flows, are completely different from the ones that exist in an OLAP’s table where those KPIs are being used. I don’t understand the reason for this, so I was thinking of a workaround solution with PyCelonis, where I would get the values from each KPI and create a dataframe that can be sent to the datapool.I can see in the documentation that we can get the values from records, but only of those records that exist in a data model. But I cannot see in the documentation how to deal with KPIs.Does anyone know if is there a way to get the value of multiple KPIs with PyCelonis, pls?

100
andres.naran12
Level 4
fabian.altendorfer
Level 3
fabian.altendorferLevel 3
 Process Analysis
Is it possible to open link to view with filter in link parameter?

Hi, I would like to link from a dashboard to a View with Process Explorer. In the dashboard, an object is selected and I would like to give the object identifier with the link to celonis, so that I can filter in the process explorer based on that (so that I only see this individual object and it’s event log).Is this possible to achieve with a Celonis View?Many Thanks,

51
julia.bauer
Level 5
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.

141
julia.bauer
Level 5
miguel.ferna11
Level 3
miguel.ferna11Level 3
 AI
How to download a zip file from ML Workbench directory?

I have generated a zip file with the content-cli module and now I need to download it locally, but every time I press the “Download” button it creates an HTML file. That HTML redirects me to a “Secure download” which re-downloads the same HTML. How can I avoid the HTML and just retrieve the zip file?

573
michael.hamme13
Level 2
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? 

152
michael.kaemp
Level 3
andres.naran12
Level 4
andres.naran12Level 4
 General Product Q&A
Send messages through Google chat

Hi everyone, I have an issue that I would like to share in case anyone knows how to solve it.I’m currently looking for a way to send messages to multiple end users by Google Chat. I don’t want to send messages to a group, but instead to end users. I noticed that Celonis provides a module called "Inject Message Into Room", but I need the webhook URL from each user. Additionally, I cannot send messages bigger than 4096 characters.Does anyone know if there is another module where I can use just the email address from users to send a message through Google Chat to each one of them, and change the length of the message body limitation, since there are some messages that might exceed the 4096 characters.Thanks! 

60
andres.naran12
Level 4
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.

101
S
Celonaut
bhargav.bhima
Level 2
bhargav.bhimaLevel 2
 General Product Q&A
having issues using PU within another PU as filter

Hi ,I am trying to use a PU function and use the result as a filter within another PU function.When i try below PQL it works fine.PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN ( PU_LAST(OBJECT,EVENT_LOG)))But when i try to add another argument for the ‘not in ‘ it returns nulls . In this example the ‘ABC’ is the additional argument for the ‘not in’ PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN ( PU_LAST(OBJECT,EVENT_LOG),’ABC’)) .have also tried splitting the filter using AND but still same issue persists.Any insights would be much appreciated.

183
bhargav.bhima
Level 2
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

91
N
Celonaut
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.

433
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: 

130
natnapin.ketch
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

204
Chethan Shetty
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

272
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.

232
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 

20
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

Badge Winners

  • Qualified to Get Data Into Celonis
    Ilse van Loonhas earned the badge Qualified to Get Data Into Celonis
  • Qualified to Identify and Drive Opportunities
    Balakrishnahas earned the badge Qualified to Identify and Drive Opportunities
  • Solution Creation Expert
    madhuwant.bedekhas earned the badge Solution Creation Expert
  • Celonis Certified Data Analyst
    asif.khalehas earned the badge Celonis Certified Data Analyst
  • Celonis Certified Data Analyst
    anna.lottn13has earned the badge Celonis Certified Data Analyst
VIEW ALL
Community Code of Conduct