Skip to main content

Product Q&A

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

4370 Topics
S
Level 2
siemen.deseyLevel 2
asked in General Product Q&A
Is it possible to calculate troughputtime between and activity and an attribute (also a timestamp, but modeled as an attribute because it is not a process step)?Thanks for the help!

Is it possible to calculate troughputtime between and activity and an attribute (also a timestamp, but modeled as an attribute because it is not a process step)? Thanks for the help!

02
kailash.potha12
Level 5
A
Level 2
akhil.tomLevel 2
asked in Data Ingestion & Infrastructure
I have tried to upload some csv and xlsx files , i am not getting any import icon in celonis tool

i have got some excel and csv files to work upon im not able to add this data into celonis ems platform and do further operations

00
R
Level 4
ariane.reis
Level 3
ariane.reisLevel 3
asked in General Product Q&A
Hy Guys!I would like to count how many activities started from the year 2023 ?You know?

Hy Guys! I would like to count how many activities started from the year 2023 ? You know?

02
kailash.potha12
Level 5
Z
Level 4
zeliha.otgözLevel 4
asked in General Product Q&A
Hi Celopeers,Do you know how to calculate Conformance Ratio?

@Ezgi Türksoy​ @bugra cabuk​ @emre.karad​ @Vildan Aslan​ you can follow up.

00
Z
Level 4
C
Level 3
claudio.tatiy12Level 3
asked in General Product Q&A
Hi Community! How can I use the View Variable into a Filter expression?

Hi Community! How can I use the View Variable into a Filter expression?

7615
kailash.potha12
Level 5
R
Level 4
rahul.bhat13Level 4
asked in Process Analysis
How to group together a set of Dimensions ?

Hi Team,I want to group together another set of dimension on top of already "Case when" KPI which gives an output of 1 or 0 on top of which i need to set a group by where it is showing a,b,c etc groups where 0 and 1 is of group "a" and 0 and 1 should be of group b etc. I have the current available kpis.   

40
R
Level 4
R
Level 2
rafikahamed.moham12Level 2
asked in General Product Q&A
I need access for PQL Queries Certification which I almost near to pass the exam and already used Couple of time.

I need access for PQL Queries Certification which I almost near to pass the exam and already used Couple of time.

01
K
Level 1
karol.trzci12
Level 3
karol.trzci12Level 3
asked in General Product Q&A
Is there a way to download all tables names and columns details that we have in Celonis?

Hi, I need to create a list of all table names and columns in each table that we have in Celonis.  I've tried pycelonis, but while I can get the tables the columns list showed as empty when using get_tables(): DataPoolTable(name='LFA1', data_source_id='xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx', columns=[] ,...) I've also tried using sql query: select table_schema, table_name from v_catalog.columnsbut got error: "Not allowed to access schema v_catalog" Is there a way to quickly download such list? Thanks,Karol

500
matt.witty13
Level 5
Z
Level 2
zhiang.chenLevel 2
asked in General 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?

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?

12
Z
Level 2
irfan.suria12
Level 4
irfan.suria12Level 4
asked in Process Analysis
Is it possible to define a display rule based on a value of another column?

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

190
irfan.suria12
Level 4
O
Level 2
oded.tzukLevel 2
asked in General Product Q&A
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 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.

02
O
Level 2
H
Level 3
himanshu.sharm16Level 3
asked in General Product Q&A
Hi Community,can anyone tell me if there is a maximum number of eventlogs (activity tables) that can be used in a data model? ThanksHimanshu

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

04
H
Level 3
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​ 

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

30
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 

30
N
Level 2
M
Level 2
marcia.cristina.silvaLevel 2
asked in General Product Q&A
I would like to know more about Signal Link Explorer

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. 

83
andré.tafur
Level 4
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?

110
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   

100
R
Celonaut
S
Level 2
siemen.deseyLevel 2
asked in General Product Q&A
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?

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?

22
gabriel.okaba11
Celonaut
mohsin.miraj
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" ) ))

130
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

100
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

Badge Winners

  • Qualified to Deliver Business Value with Celonis
    julia.portehas earned the badge Qualified to Deliver Business Value with Celonis
  • Qualified to Build Views
    ihtishaam.khanhas earned the badge Qualified to Build Views
  • First Post
    anusreehas earned the badge First Post
  • Celonis Technical Expert
    yuri.fujimhas earned the badge Celonis Technical Expert
  • Qualified to Build Action Flows
    yuri.fujimhas earned the badge Qualified to Build Action Flows
VIEW ALL
Community Code of Conduct