Skip to main content

Ask the Community

Get answers to general questions and Academy-related topics from fellow users and experts.

1166 Topics
P
Level 4
preethi.p12Level 4
asked in General Q&A
How to calculate median for this ask. Requirement: Casetable count for a specific activity per document type?

How to calculate median for this ask. Requirement: Casetable count for a specific activity per document type?

06
P
Level 4
2 years ago
.
Level 1
.14611432Level 1
asked in General Q&A
Error Celonis-Cloud (my Team)

Hello everybody.Two weeks ago I signed up for Training-Celonis-Cloud to successfully perform the exercises. Since yesterday I have not been able to access to the system (the log error is "Email or password are incorrect.". Although the credentials are correct).I tried to re-enter the new password with the "Forgot password" function but the error persists. Do you know the reason? Thanks. 

01
T
Level 1
2 years ago
J
Level 2
jay.ogayoLevel 2
asked in General Q&A
Hi,Im new to Celonis and currently doing trainings in the academy. However most guided tours are not working. Is this normal? How do I fix it? I'm using google chrome as browser. tyia.

Hi, Im new to Celonis and currently doing trainings in the academy. However most guided tours are not working. Is this normal? How do I fix it? I'm using google chrome as browser. tyia.

01
J
Level 2
2 years ago
P
Level 4
preethi.p12Level 4
asked in General Q&A
Is there any way to cascade in button dropdown for benchmarking

I want to benchmark/compare based on vendor, country and city. Is there any way I can get that in a single bitton dropdown instead of using 3 different button dropdowns. I want to achieve this in cascade, like if I select vendor I should see the option to select country and city values. Thank you​

03
P
Level 4
2 years ago
A
Level 2
anuraag.pandeLevel 2
asked in General Q&A
Is there a use case highlighting the process of analyzing ServiceNow ticket dump?Kindly help :)

Is there a use case highlighting the process of analyzing ServiceNow ticket dump? Kindly help :)

01
B
Level 1
2 years ago
V
Level 4
vivek.mLevel 4
asked in General Q&A
Has anyone replicated the usecases of Process Simulation in your Sandbox/Test system ? Am finding issue while generating Simulation assets using KM.Any inputs or link to explore the fully functional Process Simulation cases ?

Has anyone replicated the usecases of Process Simulation in your Sandbox/Test system ? Am finding issue while generating Simulation assets using KM. Any inputs or link to explore the fully functional Process Simulation cases ?

01
B
Level 1
2 years ago
A
Level 2
alexandra.koschLevel 2
asked in General Q&A
Hello,I am trying to define a new indicator for Process Explorer: This is supposed to be a rate that simply represents the number of cases that have taken one process route or another. My problem is denominater.

For example, there are two outcomming nodes (B with 25 cases und C with75 cases) from a node A (100). So I am trying to get 25% and 75% :).  Do you have any ideas , how to calculate the denominator?

05
G
Level 8
2 years ago
P
Level 4
preethi.p12Level 4
asked in General Q&A
How can I group the count of activities in a particular hour to count as 1?

Need help woth pql code. For example, in a particular 1 hour the count of activity is 89 or 56 or 05, then that count has to be considered as 1 How can I achieve this? ​

13
G
Level 8
2 years ago
.
Level 4
.146004319Level 4
asked in General Q&A
Possibility to show a KPI from an OLAP Table 1 in another OLAP Table 2

I am revisiting this issue because my new approach did not work properly. The Case I'm trying to program is:  I have two OLAP tables where one table filters (component filter) data with:(DATE < TODAY()) and the other has the component filter:(DATE > TODAY() AND DATE < TODAY() + DAYS()).  My aim is: Column 1: Material NameColumn 2: Material NumberColumn 3: The KPI of the Material as a whole from the OLAP Table 1 which is a Detail Table of all Materials The filter is only a simplified representation of the code. In summary, I have one table that looks at dates from the past and one that looks at dates from the future (future orders/deliveries). However, I now want to connect KPIs from the table that maps from the data from the past on the table that looks into the future.  For example, if I have the sales of a material from day 1 to today (past until today), I would like to be able to display that as additional info for the future orders of that material (considered the pas

12
.
Level 4
2 years ago
.
Level 4
.146004319Level 4
asked in General Q&A
Filterin multiple input into a variable

I have a button dropdown, where I've different inputs like: EINDTSLFDTMENGENETPR  Separator : ,I'm wrapping with:start = 'end = ' My variable I'm writing into is changeFields So I did a KPI where I'm using this case when: CASE WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT)' THEN 'EINDT'WHEN <%=ChangedFields%> = 'Stat. Datum (SLFDT)' THEN 'SLFDT'WHEN <%=ChangedFields%> = 'Preisaenderung (NETPR)' THEN 'NETPR'WHEN <%=ChangedFields%> = 'Mengenaenderung (MENGE)' THEN 'MENGE'END THe problem is, when I'm using more than 1 input my CASE WHEN state the project doesn't work.  I tried it like:  WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT),Stat. Datum (SLFDT)' THEN 'EINDT,SLFDT' But this idea doesn't work. I also tried to do it with logic gates. Does anyone have an idea how I can filter multiple inputs and check it in a case when function?

01
.
Level 7
2 years ago
.
Level 3
.146102116Level 3
asked in General Q&A
PQL statement returns different value for number chart and column chart

Dear community, I am using a formula to compute some KPI (based on the shown table), which is (SUM(PU_COUNT_DISTINCT( DOMAIN_TABLE("S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."CASEKEY","S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."EVENTTIME"), "S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."AKTIVITAET","S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."AKTIVITAET" = 'Eskalation durchgeführt')))However, using this formula for a type chart and a column chart, I receive two different results.The type chart correctly counts the unique combinations of the columns casekey and eventtime for column aktivitaet with value "Eskalation durchgeführt", which is 8.Meanwhile, the column chart does not only count the distinct values, but all, and therefore returns a 10 (dimension is round month, which should not be important, as all table entrances result from the same month). Does anyone know why the column chart does not solely count

013
.
Level 3
2 years ago
P
Level 4
preethi.p12Level 4
asked in General Q&A
Do we have an option to make a KPI static in a column chart?

For eg., I want to represent the avg kpi as one of t​he kpi in a column chart and makes it static so I can basically see a straight horizontal line to the dimension to compare which dimension value has achieved the avg.

02
S
Level 3
2 years ago
A
Level 1
alan.leeLevel 1
asked in General Q&A
Is it possible to show YOY / MOM change in Celonis? Any tips on that? thanks

I would like to show the changes of figures comparing to the previous period, I think of ways like through defining multiple variables with date input, is there a more convenient date in doing that? thanks!

31
P
Level 4
2 years ago
.
Level 1
.146004395Level 1
asked in General Q&A
where do I go to enroll in a certification exam?

where do I go to enroll in a certification exam?

01
V
Level 1
2 years ago
.
Level 2
.146104154Level 2
asked in General Q&A
How would I filter out purchase orders that contain 'Record Goods Receipt'?

I currently use this load script: FILTER MATCH_ACTIVITIES( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", EXCLUDING_ALL ['Record Goods Receipt'] ) = 1 But as far as I can tell this is only item level, so POs that have any item in which "Record Goods Receipt" doesn't occur still show up. I want to exclude any purchase order that has "Record Goods Receipt" anywhere in the process of any item in the PO.

01
P
Level 4
2 years ago
R
Level 3
ricardo.ribei11Level 3
asked in General Q&A
In dynamic tables with a button dropdown, the column's title doesn't update to the changed dimension unless you type <%=YourDimension%> in the dimension's name too. However, it returns the PQL statement defined for the variable instead of

Any idea on how to counter this?

02
R
Level 3
2 years ago
V
Level 4
vivek.mLevel 4
asked in General Q&A
Any Uses Cases to explore Process Simulation ? Need few examples and fully functional. Any inputs ?

Am trying in my Studio but nothing is getting updated or showing.

02
V
Level 4
2 years ago
G
Level 3
guilherme.luz11Level 3
asked in General Q&A
Remove pairs of invoices that have both debit and credit note (S/H from "BSEG"."SHKZG").

Hi, As an analyst, I want to exclude from the analysis pairs of invoices that have resulted in a credit note / (canceled invoices) Can you help with PQL query? Thanks,Guilherme

21
.
Level 4
2 years ago
S
Level 2
savitry.bansaLevel 2
asked in General Q&A
how can i connect to db2 premise and db2 cloud. when I am trying to do giving me error

how can i connect to db2 premise and db2 cloud. when I am trying to do giving me error

02
S
Level 2
2 years ago
G
Level 2
gary.peiLevel 2
asked in General Q&A
To protect client data, can I pseudonymize some credential data outside of Celonis before loading client-approved data into Celonis Cloud?

To protect client data, can I pseudonymize some credential data outside of Celonis before loading client-approved data into Celonis Cloud?

17
janpeter.van.d
Level 8
2 years ago
S
Level 2
sharana.basava.patilLevel 2
asked in General Q&A
what is the PQL formula to find the rework time?for eg : we have the activity name as the dimension and i want the first occurrance of that activity to last occurrance of that activity (rework time) as the kpi in the OLAP tableplease help

what is the PQL formula to find the rework time? for eg : we have the activity name as the dimension and i want the first occurrance of that activity to last occurrance of that activity (rework time) as the kpi in the OLAP table please help

01
G
Level 8
2 years ago
P
Level 3
paula.garci11Level 3
asked in General Q&A
Workday calendar isn't working in Studio Analysis

Hi, I have a client calendar with their working days uploaded to my data model in a SAP TFACS format.  This TFACS table is also added to the model but not connected to any other table. I have done a complete reload properly already. When I go to my analysis and see the throughput time, it didn't change, even if I put all the working days to "0" in the TFACS table. It seems that isn't tacking into account my calendar. How can make it works in my analysis? Do I have to use functions to make the analysis use the new schedule?  Many Thanks, Paula.

16
.
Level 7
2 years ago
A
Level 2
ariadna.alvar13Level 2
asked in General Q&A
I would like to know if there is any material related with customer retention. Any demo, success story or other material.

I would like to know if there is any material related with customer retention. Any demo, success story or other material. Thanks.

02
A
Level 2
2 years ago
.
Level 3
.146004191Level 3
asked in General Q&A
How to link the history of LFM1 with invoices in BSEG table so that we can calculate the impact of changes of zterm (PayTerm) done at vendor level in P2P Process.

We are trying to create an usecase as following:Calculate payment term mismatches between PO, MD, and Invoice with respect to time log of MD.How many times MD is changed per vendorFor this we have extracted the CDHDR and CDPOS data for zterm changes in LFM1, but unable to link the changes with invoices in BSEG and PO's in EKPO/EKKO table. Can anyone help me in this.

22
.
Level 3
2 years ago
.
Level 2
.146105083Level 2
asked in General Q&A
Good day,I recently signed up to the Celonis Partner portal from SoluGrowth. I am looking to complete the Sales Professional Course but cannot seem to find it in the Academy library?

Good day, I recently signed up to the Celonis Partner portal from SoluGrowth. I am looking to complete the Sales Professional Course but cannot seem to find it in the Academy library?

14
S
Level 1
2 years ago

Badge winners

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 © 2024