Product Q&A

Hi Gurus, I am trying to create a PQL KPI for a View that will sum a field called TRX_rev_amount. Its a negative number so I'm using the ABS function. For some reason, it is working great when I have it in charts or as a KPI list at the header level (see attached screenshot), but it does not work when I have it in a table. TBH I have no idea how it is coming up with the amount of $3.14k. It should be the same as above ($524). The code I'm using for the KPI is: SUM( FILTER_TO_NULL(ABS("ar_billing_transactions"."trx_rev_amount"))) If I change the code to a PU_SUM (see below) with a domain field to aggregate it by the trx_number it will work for the table, but then does not work in the header or in charts etc. What should I be doing differently?  PU_sum (  DOMAIN_TABLE ( "ar_billing_transactions"."trx_number" ) ,  ( ABS ("ar_billing_transactions"."trx_rev_amount" ) ))

Hi all, I would like to know if there is any option to enable scroller bar within a chart in views. PFB screenshot for reference. Thank you in advance :) Best Regards,Shravya B

Hello All, One of our clients does not allow any connectivity to the Private IP address and hence wishes to route through the VPN connection to allow data access. Any recommendations as to how does the VPN connectivity can be established

Do you know whether it is possible to specify the user that will be saved in SAP with the change made through Celonis?Means you would not have a generic CELONIS_USER stored by the change in SAP but the exact reference to the Celonis user who performed the change like e.g. MAX_MUSTER. Thank you!Jan

Dear Experts, I want to use the detected deviations informed by process ai as dimensions in the olap table. ​How can I use it?  Now, I am writing by hand by looking at activities corresponding to deviations in process ai.

Hi Community. Quick question here. Do we have any success story avaliable with big numbers in Telko for: Rework activities Stock avaliablity/ succes rate on minimum stock Or something similar? Thanks

 I have two PQL statements i want to factor into a clickable link: currently have this as the Component filter: I have two PQL statements i want to factor into a clickable link: I currently have this count: count(case When "_CEL_ENG_LATEST_EVENT"."ACTIVITY_EN" = 'new change' Then 1 else null end) This is tracking cases where the latest event type matches "new change". currently have this as the Component filter:filter(WORKDAYS_BETWEEN("_CEL_ENG_LATEST_EVENT"."EVENTTIME","_CEL_ENG_LATEST_EVENT"."LAST_UPDATED",WEEKDAY_CALENDAR ( MONDAY 09:00 - 17:00 TUESDAY 09:00 - 17:00 WEDNESDAY 09:00 - 17:00 THURSDAY 09:00 - 17:00 FRIDAY 09:00 - 17:00))) > 3 This is displaying the cases that breach my SLA of 3 days I want to be able to have a clickable link that can carry those filters through.

why does it show Data model loads=0 (in Data processing) even after the data model is loaded and I can see it in the Output

I have the following table structure: activity -- incident -- user Activity - as name suggests, has activities in it (in this case, any updates of an incident over time)Incident - contains header data of a caseUser - contains info about user who is owner of the incident In EMS, I'm trying to create an OLAP table, where I would have the incident category as a dimension, and as a KPI I would like to be able to see throughput time (start to end) for any given category, but with a caveat - I need to see two different columns of this KPI, one where user (linked to an incident) is a VIP and other column where user isn't a VIP. I have tried to create the following code: MEDIAN( CASE WHEN "user"."VIP" = 1 THEN CALC_THROUGHPUT( CASE_START TO CASE_END, REMAP_TIMESTAMPS("activity"."SYS_CREATED_ON", SECONDS) ) ELSE NULL END )/60/60 And this code works, but it gives completely wrong number of 113, where in reality it should be somewhere around 4

@bugra cabuk​ @Ezgi Türksoy​ @Vildan Aslan​ 

I am looking for any reference use case or help where some work has been done using ChatGPT ( or any LLM) + Celonis. Would like to hear more on this. RegardsAyan Bandyopadhyay

Hello. I just want to ask about the BSEG table. What would be the best approach to do a delta extraction on the BSEG table to capture the changes on invoice clearing date? Currently we have 2 delta extractions, 1 is based on the CPUDT of BKPF and the other is based on AUGCP of BSEG (latest AUGCP-5days). We did the offset -5 days on AUGCP to capture the changes over the weekend since the job is only scheduled to run during weekdays only. Thank you. Regards,Marco

Hello All, Can you please share me the training course where it was defined what are the basic difference between Process Explorer and Variant Explorer.

Percentage of a selected variant I want to calculate the percentage variant 1 which is happy path.

Dear All , I am facing an error while executing skill in step of "Creating Task". Snapshot attached for configuration details . Your help is requested  If you see logs here folling error is appearing  { "message": "Failed to create task. 400 Augmentation Error: Client Error: Invalid augmentation identifier name [LFA1_LFA1_VENDOR ID]. Identifier (table or column) name contains one or more invalid characters: [ ]"}  

Attached is the error message I get

Hi, does anyone have benchmark values for Mining and Metals industry? Particularly for the Asset maintenance process

Hi everyone, i am trying to create a view, where there is a process in the background and some KPI's in the front (please see screenshot). This lets the user know the value of the KPI at different stages of a process (e.g. # cancellations during order management process of O2C and # cancellations during logistic process of O2C).But i don't see any way of overlapping with layers (as in powerpoint) OR selecting a background image for a component/section/column in Views. All ideas are welcomed 😊 thanks

This might be a very specific issue, but, at the moment, CDPOS table shows the changes as follows: As you can observe, line 2 and 3 have the same OBJECTID, CHANGENR, DATE and TIME. Therefore I would like to keep them in a single row - expected result:Does anyone have a suggestion how to achieve this? Perhaps creating a temporary table to store some values and then update it with the value from the other row. But not sure how to get there. Thank you in advance! 👋

Hi, Does anyone know how to extract augmented attribute history data in Celonis? If I create a table to pick up the augmented attribute, I only get the most recent value and not the entire history (see example below). Thanks!Teun

Hello, I am using PU_LAST to find the last activity in each case to find the user.PU_LAST ("OCH_Cases", "OCH_Activities". "User_Group_NAM") But now I always want to find the second to last activity. How could I do that? Thank you Regards,Rene 

Hello, How can I push list of activities selected within analysis dropdown into variable maintained within Knowledge Model? It works fine only for variable stored locally... Regards, Lukasz

In Action Flows, I am modifying an augmented attribute. The augmented attribute automatically created a supporting table with an attribute changed_by. this attribute is getting a uuid reference to the user. But, I can't find any documentation to convert it to a name. Does anyone know how to do this?

Hi guys, do you have any use case where in we can send in 1 email for multiple selected id's in the front end? The trigger would work 1 email per selected id's in the table. I wanted to consolidate the id's selected and send 1 email for all of it.

Hello guys,I have created a table with some invoices and i want a filter only on the invoices when the last activity is 'to verify' I have tried many solutions like PU_count_distinct, PU_last,... but i dont see any other solutions ! Thanks for your help !