Product Q&A

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.

Hello guys,I have 3 KPIs (AR open, AP open, Difference between AR and AP). I have created a bar graph with only the KPI 'difference between AR/AP' but when i'll want those kind of graph When i hover my mouse on the bar i would like to see the 3 KPIs with only one bar showing the main KPI. Do you have some ideas ?

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

Do we refer to the end to end relationship between the Table B (1) and Table A2 (Case Table - N), by ignoring the intermediate tables (Table A)?

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?

Hallo Team, I have been using the P2P dataset provided by the academy.  Had used the following statement to calculate the PU_median according to each case - PU_Median("LFA1", "_CEL_P2P_ACTIVITIES_EN"."EVENTTIME").  I have diffculties understanding the outcome (in pic attached) - Why do I get the PU_Median time calculated in seconds format?How can I convert the O/P format in seconds to DD-MM-YYYY ? - Had tried using {t } function, but it was an failureEven though there are different time stamps for each case wrt to activity - why do I get the same median time (1245079800000) for all the cases?  Can any I detail it . Thanks in advance.

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

Hello guys,I'm trying to find a solution to modify the maximum execution timesout in one of my Action Flow, it stops before all data are transfer in one of my google sheet file. Do you have an idea ? Thanks !

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

We have built an Action Flow to capture daily stats from an analysis and store it in a SharePoint. When we try to execute this Action flow manually, it does not give an error and works properly but when scheduled, it gives the below error. "Function 'getResponseBody' finished with error! Script execution timed out after 10000ms." How to mitigate this?

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

Hi All,Im trying to find the count of throughput time in buckets in views. The histogram are the way to go but in views they only accomodate integer and floats but not dates. Im trying to come up with it in Chart but unable to.Please let me know if someone has any idea.

Hi, Does anyone know how to make an input for an automation skill optional?The option is greyed out for me. I would like to be able to trigger a skill using an action without having to fill fields if they are empty. Thanks!Teun

The documentation feature in Process-Analytics (https://docs.celonis.com/en/export-technical-documentation.html) is a great one to keep track of the logic developed and is of great use for developers and business users. Is there something similar in Studio fpr knowledge models?