Product Q&A

We are seeking to access detailed data from the accounts receivable demo, but we are unsure of the process to export this data. Could anyone kindly provide guidance on how we can achieve this?

With display rules, I can customize visual styling for the content based on the cell value. However, I would like to use the comparator against another value. In my specific example, I want to add priority symbols next to each PO number based on another attribute, for example the delivery date or net order value. For the latter, I want to define buckets and then map them into priorities that should be the value to compare against in the display rule. You can think of the feature custom conditional formatting in Excel. Is this possible? CheersIrfan

Hi all, can you advise the SAP table number that is used for Plant Maintenance. Is there an example log file for Plant Maintenance or table scheme? Thank you.

Hi Community, can anyone tell me if there is a maximum number of eventlogs (activity tables) that can be used in a data model? Thanks Himanshu

 I defined variables for the dates in order to operate different KPI's. In my case Base Dates effect KPI 1, Current dates effect KPI2. my dates are variables (Date_1,2,3,4)as you know datepicker effect the whole analysis.Note: CAUFV.GLTRP is a date table column KPI_1 Component FiltersFILTERROUND_DAY("CAUFV"."GLTRP")>= to_date( <%= Date_1 %>,FORMAT('%Y-%m-%d’))ANDROUND_DAY("CAUFV"."GLTRP")< to_date( <%= Date_2 %>, FORMAT('%Y-%m-%d’)) ; KPI_2 Component FiltersFILTERROUND_DAY("CAUFV"."GLTRP")>= to_date( <%= Date_3 %>,FORMAT('%Y-%m-%d’))ANDROUND_DAY("CAUFV"."GLTRP")< to_date( <%= Date_4 %>, FORMAT('%Y-%m-%d’)) ; @bugra cabuk @

It appears regardless of the given arguments or complexity. Celonis version: 4.6 Thank you for your help! 

Please improve this code,  FILTER MATCH_ACTIVITIES ( "finalResult_0_005"."ACTIVITY" , NODE ['<%=display_code_1%>'] ) = 1; so that when nothing is assigned to the display_code_1 value, it displays all the data. I tried  FILTER CASE WHEN '<%=displayCode_1%>' IS NULL THEN 1 ELSE MATCH_ACTIVITIES("Correlation_0_0075_remove_1st"."ACTIVITY", NODE['<%=displayCode_1%>']) END = 1  this code but it did not worked. It returns MATCH_ACTIVITIES: Could not find activity []. this message.  Thank you 

I am trying to understand how can I use a Signal Link Explorer (SLE) component in a view.  I found in Celonis documentation orientation about Network Explorer (NE), even it is mentioned that exists SLE, but I didn't find further information about it.  I would like to access an explanation about the YAML components of it.  I found it applied at Inventory Management app and I would like to use it, but I didn't understand how to get there.  I hope someone is able to help me on it. 

I would like to concatenate a date and time coming from a specific table into a single column, but I get the following message:Operator requirements are not met. Operator 'CONCAT' is not compatible with inputs of type DATE. Is there some workaround to concatenate DATE type?

Hi Folks  I have a Knowledge Model with some KPIs and a View displaying it. I want to allow the user to see the value of the KPIs for different periods. To achieve this I´m trying to create a Filter and a Variable.  The Filter helps me to filter for some specific conditions to calculate my KPI (see filter statement below) FILTER TO_STRING(ROUND_MONTH(PU_FIRST("JIRA_ISSUES", "_CEL_JIRA_ACTIVITIES"."EVENTTIME", "_CEL_JIRA_ACTIVITIES"."ACTIVITY_DE" = 'Fehlende Ware')), FORMAT('%Y-%m')) = ${monitor_timefilter} The Variable ${monitor_timefiler} is the one that I want to update based on user selection (month of their interest) - > the KPIs should be updated based on user selection.  So far I can do this but I need to update the Variable ${monitor_timefilter} manually. Any hints on how to achieve this would be highly appreciated.  Thanks i

Hello All. For our Clients process, we need activities that are happening in the process, but should not be shown as a process step, because it's a violation. How can we implement that?

i want to set up an automation in Celonis EMS that will send reports via Microsoft O365

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_transaction

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 t

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

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