Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3138 Topics
Z
Level 4
zeliha.otgözLevel 4
asked in General Product Q&A
Hi Celopeers,Can I put 2 datepickers that will effect 2 different KPI's seperately in the same analysis page? These 2 datepickers should be belong to the same date table column.

 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 @Ezgi Türksoy​ 

10
Z
Level 4
lucian.oana11
Level 2
lucian.oana11Level 2
asked in General Product Q&A
Hi! Has anyone had this error while using the MATCH_PROCESS_REGEX formula?"Internal engine exception. Not able to handle the query request."Any fix or resources to find more about it?

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

00
lucian.oana11
Level 2
K
Level 2
keonhyuk.songLevel 2
asked in General Product Q&A
Match_activities function question - displaying all data when the variable is null

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 

20
N
Level 2
salma.zeped
Level 4
salma.zepedLevel 4
asked in General Product Q&A
What to use for concatenating date and time using PQL?

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?

80
salma.zeped
Level 4
L
Level 1
luis.perez14Level 1
asked in General Product Q&A
How I can update a Variable to show KPIs in a View based on user selection?

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 in advance   

90
R
Celonaut
M
Level 1
mohsin.mirajLevel 1
asked in General Product Q&A
i want to set up an automation in Celonis EMS that will send reports via Microsoft O365

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

30
abhishek.chatu14
Level 7
T
Level 2
timothy.brown12Level 2
asked in Data Ingestion & Infrastructure
SUM vs PU Sum confusion

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

80
T
Level 2
S
Level 4
shravya.b11Level 4
asked in General Product Q&A
Scroller bar for charts in Views

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

20
S
Level 4
S
Level 1
shailesh.agrawLevel 1
asked in General Product Q&A
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

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

10
S
Level 1
jan.vajse12
Level 3
jan.vajse12Level 3
asked in General Product Q&A
Hello Celopeers,My question is related to the Celonis option of changing data in SAP: https://docs.celonis.com/en/change-data-in-sap.html

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

40
jan.vajse12
Level 3
S
Level 3
sanghyeok.kwakLevel 3
asked in Data Ingestion & Infrastructure
Can detected deviations in process ai be used as pql?

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.

00
S
Level 3
D
Level 2
daniel.burroLevel 2
asked in Data Ingestion & Infrastructure
How can add a filtered view into a 'button' / 'link' ?

 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.

60
R
Celonaut
A
Level 1
aishwarya.rajLevel 1
asked in Data Ingestion & Infrastructure
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

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

00
M
Level 1
J
Level 2
jan.pilarLevel 2
asked in General Product Q&A
How to calculate case throughput time filtering on a value from an edge table?

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

00
R
Celonaut
Z
Level 4
zeliha.otgözLevel 4
asked in General Product Q&A
I want to change the colouring tresholds in the number component however; I could not edit. I just want to show green if bigger than 0 and red in the reverse.What I can do?

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

20
Z
Level 4
P
Level 2
pritam.roy19Level 2
asked in General Product Q&A
What are the basic difference between Process Explorer and Variant Explorer

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.

170
Z
Level 4
Z
Level 4
zeliha.otgözLevel 4
asked in General Product Q&A
Percentage of a selected variantI want to calculate the percentage variant 1 which is happy path.

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

00
Z
Level 4
.
Level 4
.146192833Level 4
asked in Process Improvement
Getting error while executing Skill and creating task . (Snapshot for your reference )

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: [ ]"}  

00
abhishek.chatu14
Level 7
A
Level 1
ashwin.santh12Level 1
asked in General Product Q&A
I cannot seem to register as a partner and have no access to the partner portal. I've gone through the kick starter training and nothing in there suggested a process to get access. What am I missing?Thanks,Ash

Attached is the error message I get

10
S
Level 1
H
Level 3
himanshu.sharm16Level 3
asked in General Product Q&A
layer (background) in Views

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

20
H
Level 3
salma.zeped
Level 4
salma.zepedLevel 4
asked in General Product Q&A
👋 How to merge info coming from VALUE_OLD and VALUE_NEW from CDPOS table?

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! 👋

20
salma.zeped
Level 4
T
Level 3
teun.gilis11Level 3
posted in Process Analysis
Hi,

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

00
T
Level 3
M
Level 3
matt.slocu12Level 3
asked in General Product Q&A
augmented attribute changed_by attribute is only giving me a UUID, not a name.

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?

60
T
Level 3
A
Level 3
antoine.leducLevel 3
asked in Data Ingestion & Infrastructure
How to filter only when the last activity is 'XXXX'

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 !

40
G
Level 8
neil.patrick.casca12
Level 1
neil.patrick.casca12Level 1
asked in General Product Q&A
Power BI Action Flow Architecture Setup

Hi, Can someone please provide any architecture details or any docs related on how to setup PowerBI connection for Celonis action flow? I already checked the celonis docs but it looks like its not enough or there's no specific instruction on how to setup PowerBI connection actionflow to Celonis. We are planning to use this Celonis PowerBI Action flow modules but we are not able to setup the connection between celonis and powerbi as the 1st step. Thanks!Neil Cascante 

20
R
Celonaut

Badge winners

  • Qualified to Build Action Flows
    manali.malpahas earned the badge Qualified to Build Action Flows
  • Qualified to Write PQL Queries
    elena.mariahas earned the badge Qualified to Write PQL Queries
  • Value Realization Expert
    Graham Holmeshas earned the badge Value Realization Expert
  • Qualified to Manage Implementation Projects
    Graham Holmeshas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Manage Change and Scale Adoption
    Graham Holmeshas earned the badge Qualified to Manage Change and Scale Adoption
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025