General Product Q&A

I have Created one Action Flow Get the all data by using celonis Query Data Module after that Data differentiate by using Router Module and create 4 Excel files ,These Excels Files send throught one email Attachement,How possible please guide me.Please find my Action Flow Diagram.

The load failed: Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "BSEG": key columns ("GJAHR", "BELNR", "BUKRS", "MANDT"), key ('2021', '0100408024', '7000', '100'), rows 1028848 and 1028849. Table "BKPF": key columns ("GJAHR", "BELNR", "BUKRS", "MANDT"), key ('2021', '5102905179', '4001', '100'), rows 1404891 and 1404892.

I’m trying to understand if we can clear the selected value from the dropdown. For example, I’ve configured a dropdown component and assigned a variable and using it in chart/tableThe chart/table will display according to the selection. After the analysis I want to clear or reset the filters like how we do it globally…

Can I apply a filter in individual components in views?

Can we apply filters only to olap table so the other components in Views remain unchanged.I tried of creating a button which will route to new view which only has olap table configured in it. looking for any other approach possible for this.Thanks in advance!

When i am giving a very small-time filter (1-2 days) for the same table it works fine. Anyone faced this before? [Simba][BigQueryJDBCDriver](100034)

I am writing into a package runtime variable from input-box in a View. I want to wrap the contents of the variable with single quotes. Tried below YAML, but the single quotes disappear after I save and reopen. id: input-box-e779d853-ce7f-46ed-b5f5-ddc3d277d9d0type: input-boxsettings: placeholderText: ${ABCD} name: ABCD type: string onChange:  update:   variables:    - name: ABCD    - name: 'package_ABCD' infoText:  title: Mandatory field  content: Please enter X to create XXXXXXXX with xxxxx xxxxx. 

The status of the upload stays on "uploading files" forever. I know of the 1GB upload limit and have tried it with several different .xes files and none work.

In which module i can get data back to Celonis in a Table in Actiojn Flows?

Some of our databases used Windows authentication instead of the self-Instance/user name & password on each database. The process is, I need to login to Jump box (Server) and login to the database (MSSQL) with different Windows authentication (not just my user name)Your help & guidance is highly appreciated. Thank You!​

And Can I send data back to Celonis after creating table in Action Flows? Thank you in advance.

How to add Data labels under each bar in a view's configuration?

We want to migrate a table from a data model where the table column names have dollar signs ($) in the name. When we try to migrate the table we get a column not found error on those columns that have a dollar sign in the name. Is there a way to encode or otherwise provide the column names to the pql.DataFrame function such that it can use columns with $ signs?

Hi expert, I'm not quite good at SQL and I have a question about SQL. In my case, I would like to filter activity table with event time with its only time(hh:mm:ss). Does anybody let me know how to do that in Celonis data integration task?

Hi Guys, Just wondering if celonis provide any connection to the software Tasy from Philips? Thanks

In generell the dropdown filter would start at 0:00 and end at 23:00 depending on a table with timestamps. In this case the occurances of events for different hours (e.g. 05:35, 05:12 ..) from timestamp table have to be agglomerated and each hours should be distinct (e.g. 05:35, 05:12 --> 05:00). Thank you for your help!

I'm trying to configure my machine learning workbench, but it seems I still don't have the proper permission to do it. Any clues on how I'd be able to get the updated ML license?

Hello Team,While creating Action flow, by using Get rows Celonis module. After selecting appropriate Knowledge model only few KPI's are shown, recently created KPI are not shown. How can I access newly created KPI?Thank you in advance.

Here the amount is still in ascending order even after sorting it as descending.

Who knows it?Sometimes I get DPO like this: 466,243,595,672,831,872 daysFor example: one vendor, two invoices, sum of these two invoice is 0 €. I think it is a problem with the sum of 0 €. But how can I resolve it in the PQL formula?

Can any provide a sample Table-ABAP-Configuration.xlsx file

Hello,  Anyone knows how to reference array without keys (1. Value A2. Value B)or just a string ("Value A, Value B) in a outlook recipients module? I've tried several approaches but nothing seems to be working properly. I do not want to send multiple emails to single recipient (1 mail = 1 recipient). I want to send 1 email to multiple people in both "TO" and "CC" fields. It's improtant as we've got dynamic recipients list. Usually I end up with one of two errors: or  Best Regard,Mateusz Dudek 

I have started creating more of my use cases as "Views" and realized I am unable to use the "Generate PDF Report" action flow with them... Seems like Views are what will be the preferred destination for use cases premade and custom. I would like to be able to use them the same in action flows

Helo everyone,  I struggle with a topic that has came up twice now in different data models:. Following scenario with the folowing data model:[MSEG] N --- 1 [MARC]1 --- N [MARC] I have a frontend table with different MARA and MARD information. It showcases each Material, their storage location inside a plant and several other information. Now I want to add a certain field from MSEG: The last time a material was moved inside a storage location (inside plant). Now I have to use a PU-function since MSEG and MARD are not connected, only through the MARC-Table. The issue is, that MARC aggregates all data on the plant level, but I want to have the date on storage location level. Example: Material A is stored in storage locations 10 and 20 in plant X. (Info in the MARD and MSEG table) Material A in storage location 10 and plant X was last moved on the 01.01.2023. (Info in MSEG table)Material A in storage location 20 and plant X was last moved on the 03.01.2023. (Info in MSEG table) A simple f

Hi everyone, i got following activity table structure:Item ID (case ID), Activity (activity), Timestamp (timestamp), Item position ID One Item ID can have multiple Item Position IDs; so 1:n relationship. Some activities tend to repeat themselves for each distinct Item Position ID, example: Item 1, Activity A, 08.08.2023 10:00, -Item 1, Activity B, 08.08.2023 10:01, ItemPosition 11Item 1, Activity C, 08.08.2023 10:02, ItemPosition 11Item 1, Activity B, 08.08.2023 10:03, ItemPosition 12Item 1, Activity C, 08.08.2023 10:06, ItemPosition 12Item 1, Activity D, 08.08.2023 10:07, - I want following throughput time calculation to be considered for each Item Position ID, which i am not able to generate.   CALC_THROUGHPUT (  FIRST_OCCURRENCE [ 'Activity B' ]  TO  FIRST_OCCURRENCE [ 'Activity C' ] ,   REMAP_TIMESTAMPS ( "Activity_Sheet"."TIMESTAMP" , MINUTES ))  Output expected:ItemPosition 11, 1 min.ItemPosition 12, 3 min. Generally i would create 2 activity l