Skip to main content

General Q&A

Can't find what you're looking for? Ask it here!

  • 1,198 Topics
  • 2,563 Replies
1198 Topics
A
Level 2
ayan.banyoLevel 2
asked in General Q&A
I am looking forward to some use cases where we can use ChatGPT + Celonis.

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

20
gabriel.okaba11
Celonaut
J
Level 1
john.marco.albanLevel 1
asked in General Q&A
I just want to ask what would be the best approach to do a delta extraction on the BSEG table? 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)

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

90
gabriel.okaba11
Celonaut
S
Level 2
sagarika.jain11Level 2
asked in General Q&A
Hi, does anyone have benchmark values for Mining and Metals industry? Particularly for the Asset maintenance process

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

00
S
Level 2
rene.szere
Level 3
rene.szereLevel 3
asked in General Q&A
Find the second to last activity

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 

40
F
Level 3
lukasz.luty
Level 3
lukasz.lutyLevel 3
asked in General Q&A
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

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

00
lukasz.luty
Level 3
C
Level 2
christian.emmanuel.lunesLevel 2
asked in General Q&A
Send in 1 email with multiple id's selected in front end

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.

40
G
Level 8
ariane.reis
Level 3
ariane.reisLevel 3
asked in General Q&A
I need some help again :(I need to calculate % (the outstanding payments divided by the payments made) i.e. the formula would be:

(COUNT(CASE WHEN KPI("VALUE_PAY") <'0' THEN 1 ELSE 0 END))/(COUNT(CASE WHEN KPI("VALUE_PAY") >'0' THEN 1 ELSE 0 END))

10
G
Level 8
C
Level 1
clara.laureLevel 1
asked in General Q&A
Hi, I registered as a Customer with my company account by mistake instead of Partner. How can I switch? I am now not able to create a Partner account with my company email address. Thank you for your help

Hi, I registered as a Customer with my company account by mistake instead of Partner. How can I switch? I am now not able to create a Partner account with my company email address. Thank you for your help

00
M
Level 1
mrinalini.mehta
Level 1
mrinalini.mehtaLevel 1
asked in General Q&A
Exclude some VBAP.POSNR based on a criteria AND THEN find the first/min VBAP.POSNR

I am calculating freight cost (which is on header level) for orders and would like to show all orders along with order items in an OLAP table.Now there are certain order items which I would like to identify and be ignored for which I created a KPI called "identifier":Now when Identifier is 1, I want POSNR of such order items to be considered and take the first available "POSNR" and put the Freight cost against it.  The result however is coming on the first POSNR which should have been overlooked based on my identifier:

00
R
Celonaut
S
Level 3
sayan.chakr12Level 3
asked in General Q&A
I want to import a manually transformed table from datapool to ML workbench to do some operations. Is it possible to do that without loading the data model? Can i import the transformed table directly?

I want to import a manually transformed table from datapool to ML workbench to do some operations. Is it possible to do that without loading the data model? Can i import the transformed table directly?

60
G
Level 8
ariane.reis
Level 3
ariane.reisLevel 3
asked in General Q&A
How to calculate the average interval of days between payment activities?The calculation is represented below:

160
ariane.reis
Level 3
E
Level 4
e.nLevel 4
asked in General Q&A
About the default settings of KPI

The following PQL formula is the default for PQL KPI's. Am I correct in understanding that the following only calculates processes that start with a specific activity and cannot be calculated if the flow of a specific activity is included in the middle of a process? KPI("Ratio", PROCESS EQUALS START '' TO ANY TO '' END ) 

10
T
Level 1
S
Level 2
subhankar.ghosh12Level 2
asked in General Q&A
How to identify open invoices from BSEG table in SAP ?

How to identify open invoices from BSEG table in SAP ?

20
A
Level 3
O
Level 3
ole.buhlLevel 3
asked in General Q&A
Using Dinstinct in a View

Dear everyone, I want to transfer an analysis into a view. In the analysis I use the formula DIstrinct "MD04"."MATNR" to get all distinct Material Numbers as they can show up multiple times in the table columns. I now wanted to do the same in the view, but get the follwing error:Does anyone know how to solve this? Thank you very much for your time and help! Best Ole

00
O
Level 3
E
Level 4
e.nLevel 4
asked in General Q&A
Question on PyChart

I want to create a pie chart on the Celonis dashboard that counts the number of values in the columns I have added to the OLAPTable. how do I set the DEMENTION and KPI respectively?

00
I
Level 1
R
Level 3
rodrigo.vianaLevel 3
asked in General Q&A
How to filter an olap table to only show positive results os a difference between columns(explanation bellow)

Hello all, im trying to compare the sales between last week and the weekly average of the last 6 weeks in several materials. For this I wrote the following code for the kpi:(material is set as dimension)(there is a component filter that limits the data to the last 6 weeks as well)round ( ( ( 7 * SUM ( "VBAP"."NTGEW" ) / 43 ) / 1000 ) - ( ( SUM ( Case When "VBAP"."ERDAT" > ADD_DAYS ( TODAY ( ) , - 9 ) THEN "VBAP"."NTGEW" else 0 end ) ) / 1000 ) , 2) However, in the OLAP I only want to see the materials where this difference is positive so I tried to do a filter where:FILTER "Material" IN (CASE WHEN "DIfference code above" > 0 THEN MATERIAL ELSE NULL END) But I get an error message saying that I cannot use the SUM aggregator in Filter. Does anyone know how to solve this ?

70
G
Level 8
dany.moual11
Level 3
dany.moual11Level 3
asked in General Q&A
Self join a table to get a 1:N relationship and compare a KPI value within a dimension

Hello , I would like to implement a KPI showing the relationship within the element of a dimension (B) for each fixed element of a first dimension A and display it as shown below: A | B | B (again) | KPI X | 2001|  2002 | 5 X | 2001| 2003 | 2 X | 2002| 2001 | 100 X | 2002| 2003 | 2..... Y | 2001| 2002 | 50 Y | 2001| 2003 | 25 Y | 2002| 2002 | 20 Y | 2002|  2003 | 25 ...The aim is to be able to determine for each dimension in A, and a given fixed dimension in B, which other dimension within B is very different in terms of KPI value. Any idea about how to inplement something like this using PQL? Thanks for your help 

30
dany.moual11
Level 3
A
Level 2
andras.perjeLevel 2
asked in General Q&A
Hello Celopeers, I'd like to group activities by user name, event time, and activity name before counting them.

I'd like to better understand the actual manual work involved by executing a certain activity. In my company, there are activities that are executed as "batch jobs". This means that we can execute the same activity across several line items. In this case, even though it only required one manual execution, it's counted as one across several line items adding up to several "manual" activities. To find a better estimate of the actual manual effort for each activity, I'd like to group them by user name, event time, and activity name.  Can anyone help me crack this nut? Thank you in advance for your help!

10
A
Level 2
D
Level 1
dimitrios.hatziLevel 1
asked in General Q&A
How do integrate Celonis and ServiceNow?

Hello everyone. I am looking for anyone who might have achieved integration between Celonis and ServiceNow. The documentation provided - in my view - is not clear. What I have achieved so far:Created a user - basic authenticationCreated a custom roleAdded the rest_service, soap_query, custom role to the userCreated the ACL for the sys_db_object and incident table (filtering on the assignment group) and attached the custom role.Successfully connected between celonis and ServiceNow However, I receive the following error message when a full load is executed:  Any insights or help as to what is missing? FYI - i am no Celonis administrator - anything Celonis related tasks, I have someone within my team that is executing those Celonis tasks. Thank you.

100
V
Level 1
D
Level 4
douglas.henriLevel 4
asked in General Q&A
KPI-CARD

 Hey guys, I would like to transform the access user in Celonis (user.celonis@outlook.com) into just the name. Example: User Celonis I looked in the PQL documentation but I couldn't find it.I looked in the PQL documentation but I couldn't find it.

00
D
Level 4
S
Level 1
sapna.goyalLevel 1
asked in General Q&A
How can we get access to Training Analytics Tab in Celonis?

How can we get access to Training Analytics Tab in Celonis?

00
L
Level 1
E
Level 4
e.nLevel 4
asked in General Q&A
Training Environment

In the Celonis Academy training environment, there is no configuration screen for scheduling event triggers. Is it possible to check in the training environment?

10
D
Level 1
C
Level 3
chakradhar.pokalLevel 3
asked in General Q&A
Process AI in analysis need link for deep understanding

Hello Celopeers, I have built KPI dashboards and doing some analysis on process explorer. Manually going through analysis. Heard Process AI will automatically detects deviations and find root causes.  Need to deep drive. if any one knows the link from learning portal pls suggest.   

10
E
Level 2
jiri.linha
Level 1
jiri.linhaLevel 1
asked in General Q&A
I have multiple values (20 of them) for example orders which I need to insert into filter, but after entering and confirming it, the filter is not applied. I tried to even change format in excel to number before, but still not working.

I have multiple values (20 of them) for example orders which I need to insert into filter, but after entering and confirming it, the filter is not applied. I tried to even change format in excel to number before, but still not working.

00
S
Level 1
rene.szere
Level 3
rene.szereLevel 3
posted in General Q&A
Hello,

Hello, I have an activity "OCH_Activities". "Source_Queue_TXT" and "OCH_Activities". "Target_Queue_TXT".I want if source and target are the same, that I get the value 1 for example.I have already tried COUNT( CASE WHEN "OCH_Activities". "Source_Queue_TXT" = "OCH_Activities". "Target_Queue_TXT" THEN 1 ELSE 0 END)but this does not compare the two activities. What would be the correct approach here.Thanks

22
rene.szere
Level 3

Badge winners

  • Celonis Certified Data Analyst
    peter.wagne12has earned the badge Celonis Certified Data Analyst
  • Value Realization Expert
    marius.englehas earned the badge Value Realization Expert
  • Qualified to Create and Deliver Demos
    marius.englehas earned the badge Qualified to Create and Deliver Demos
  • Qualified to Manage Change and Scale Adoption
    marius.englehas earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Deliver Business Value with Celonis
    marius.englehas earned the badge Qualified to Deliver Business Value with Celonis
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