Product Q&A

Hi, we’re planning to use task mining for one of our customers.Would it be possible to install a desktop application on employees’ laptops without them noticing?Also, once the application has been installed, can it be run silently so that employees are not aware that they are being monitored?

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

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.

Every ‘Get Row’ module suddenly stopped working, all at the same time… Has anyone ever seem this error message before? What does it mean? How can I prevent it from happening again? Error: Cannot initialize the scenario because of the reason 'Failed to compile IML function 'functionToDeleteSecond'. Unexpected identifier 'is''  

12月23日（金）に11月9日と10日にドイツで開催されたCelosphereの内容について、ダイジェスト版として日本後のRecap Webinarを実施します。日本語でCelosphereの内容をご案内させていただきますので、ぜひ、奮ってご参加ください。また、このWebinarはパートナー様だけでなく、お客さまもご参加いただけるWebinarです。​​https://www.celonis.com/jp/webinar/the-best-of-celosphere-japan/

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. 

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>

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?

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.

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?

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? 

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.

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.

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

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

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: 

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

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.

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 

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

Hi Team, I’m working on input dropdown where my timestamp should be convert into daily,weekly,monthly and if it is daily I need 8 hrs , for weekly 40 hrs and monthly 173 hrs in one single dropdown. How I can achieve it. Regards,Ajith Naidu.

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!  

Hi team, I want to know more change the default display of columns within the Case Explorer component of Studio Views, after having added two more attributes.Best regards, Leonardo

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!

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