Skip to main content

Solved

362 Topics
deeksha.r12
Level 4
deeksha.r12Level 4
asked in General Product Q&A
Hello everyone,I have created a table through the use of HTML in the textbox in order to display the Related KPIs. I wanted to know if there is a possibility to apply the displaycontentrule for the KPI values displayed through placeholders.

Hello everyone, I have created a table through the use of HTML in the textbox in order to display the Related KPIs. I wanted to know if there is a possibility to apply the displaycontentrule for the KPI values displayed through placeholders.

52
deeksha.r12
Level 4
chunlei.an
Level 2
chunlei.anLevel 2
asked in General Product Q&A
Hi guys, is it possible to display a view variable as a column in a table within the same view? The value of the view variable will be updated by a input box in the same view. Thanks in advance.

Hi guys, is it possible to display a view variable as a column in a table within the same view? The value of the view variable will be updated by a input box in the same view. Thanks in advance.

203
janpeter.van.d
Level 8
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
Hi Team, Anyone worked on Apache Kafka data connection, if so please provide relevant documentation and steps how to extract tables from it.

Hi Team, Anyone worked on Apache Kafka data connection, if so please provide relevant documentation and steps how to extract tables from it.

124
kandi.naidu
Level 4
R
Level 3
richanda.wrighLevel 3
asked in General Product Q&A
Transformation Center - I am trying to write a KPI in Transformation Center to monitor when "EBAN"."MATNR" (Material Number is Missing in Purchase Req) Can anyone provide some guidance

Transformation Center - I am trying to write a KPI in Transformation Center to monitor when "EBAN"."MATNR" (Material Number is Missing in Purchase Req) Can anyone provide some guidance

415
R
Level 3
Sverre Klein
Level 6
Sverre KleinLevel 6
asked in General Product Q&A
"Weird" Academy questions on Celopeers.

Hi everyone, I have noticed an abundance of posts of people posting academy questions like this below:It's also always the main question, but they never post the statements. I don't want to cause a stir, but is this normal? 😓

43
M
Level 1
N
Level 2
nicola.lomba11Level 2
asked in General Product Q&A
Hi there! Is it possible to show in views the last data load date? Users would like to see in app when data have been loaded in Celonis. Thank you in advance for your help!

Hi there! Is it possible to show in views the last data load date? Users would like to see in app when data have been loaded in Celonis. Thank you in advance for your help!

212
Sverre Klein
Level 6
Sverre Klein
Level 6
Sverre KleinLevel 6
asked in General Product Q&A
PQL: How to have a string value in an Average KPI column?

Hi Community I have the following PQL Query as an KPI: AVG (  CASE    WHEN      MATCH_ACTIVITIES ( NODE [ 'Proposal Submitted' ] ) = 1    THEN        CALC_THROUGHPUT (          First_OCCURRENCE [ 'Proposal Stage' ]          TO          Last_OCCURRENCE [ 'Proposal Submitted' ] ,          REMAP_TIMESTAMPS ( "ACTIVITIES_TABLE_HUBSPOT"."EVENT_TIME" , DAYS )        )           ELSE      'No Proposal was Submitted'      END) I would like to have the string value 'No Proposal was Submitted' for the business in thr ELSE statement. I know I can simply replace it with the INT value 0, but I don't want that.  Any help is appreciated 😊  The error reads: Operator requirements are not met. CASE WHEN expression is not compatible with an ELSE case of data type STRING when at least one THEN case is of data type INT Kind regards,Sverre Klein  

54
Sverre Klein
Level 6
deeksha.r12
Level 4
deeksha.r12Level 4
asked in General Product Q&A
I would like to know if it's possible to fix a view component in the top section of a dashboard, so it doesn't move vertically when scrolling.

I would like to know if it's possible to fix a view component in the top section of a dashboard, so it doesn't move vertically when scrolling.

42
deeksha.r12
Level 4
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
Hi Team, Anybody have any idea about how to use uptrend and downtrend with other kpi in Knowledge model

I am sharing an attachment for reference .   Thanks, Kandi Ajith Naidu.

32
kandi.naidu
Level 4
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in General Product Q&A
How do I activate/deactivate Dark Mode for SQL windows?

In the Windows under Data Integration where I write SQL Code for Transformations I sometimes have dark mode (white font on black background) and sometimes the other way around. It seems this changed from time to time and from environment to environment.Where can I set this? How is this being influenced? Obviously being a developer I want dark mode all the time 😁

265
manuel.wetze
Level 5
J
Level 3
jurgen.gakovLevel 3
asked in General Product Q&A
Get the time between 2 specific rows in a dynamic table (LEAD and LAG Function)

Hi there, I have the following table:  We got for every part diffrent timestamps with a specific work done there. I would like to calculate the date between the installation and removal date. The problem ist, that for one part there can be historical data with multiple removals and installtions (like you see in 'Y'). Here I would like to calculate the difference by taking the installtion data followed by the date of the next removal.  I tried the Lead Function: DATEDIFF(DD, (Lead ( ('DATE'), ORDER BY ('DATE' DESC), PARTITION BY ('PART', 'WORK'),1)),  (DATE) ) The problem here is that this function calculates only the days between the removals.Do you guys have any idea how I can get the dates between the installation and removals dates? Thank you and best regards!

172
J
Level 3
N
Level 2
n.m11Level 2
asked in General Product Q&A
Not able to select the case ID.

For some reason I am not able to scroll down or select the case ID. Maybe it is a UI issue?

04
janpeter.van.d
Level 8
mario.aires
Level 2
mario.airesLevel 2
asked in General Product Q&A
Is it possible for admins to delete bookmarks created by other users?

Hello everyone, Is there a way for admins to delete bookmarks created by other users? We have a lot of bookmarks created by no-longer-existing users that are polluting our dashboards. Thanks in advance!

33
N
Level 3
M
Level 3
marcos.hirak12Level 3
asked in General Product Q&A
what are the initial practical steps to take to "Create sap connection in celonis ems"?

I'm in my first EMS project and it was to accompany the DATA ENGINEER activities.Unfortunately the Data Engineer was not hired and they asked me to take over and I don't know SAP BASIS. I've done the Get Data into the EMS training, but I don't know what the initial practical steps are to do to "Create sap connection in celonis ems".Does anyone have anything written from "Practical roadmap to "Create sap connection in celonis ems" to send and/or guide me?

165
X
Level 3
karl.guent
Level 4
karl.guentLevel 4
asked in General Product Q&A
This is a PQL question: - I have three THROUGHPUT calculations working (I think) - I now want to have a COUNT column next to each. But:I am counting ACTIVITIES not CASES.How can I count cases, not activities/tasks?

This is a PQL question: - I have three THROUGHPUT calculations working (I think) - I now want to have a COUNT column next to each. But: I am counting ACTIVITIES not CASES. How can I count cases, not activities/tasks?

1815
Sverre Klein
Level 6
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Product Q&A
Adding a timestamp to data rows in a CSV file that is sent out via an Action Flow

Hello everyone!I want to send an Action Flow weekly that displays the material numbers that qualify for an automatic ordering process (this process can be triggered by editing the material master data). Since employees might choose not to edit the master data due to various reasons, the one material number for example will show up every week in the CSV that is sent via the AF. It could be possible that this repetitive sending of material numbers that should not be automatically ordered might negatively affect the acceptance of the AF. Here's my idea: does somebody have an idea how to add a timestamp of the initial sendout of the data rows in the CSV file? So, for example, if one material number was already sent out via the AF on the 1st of January, in the next runs of the Action Flow the 1st of January will be visible in an extra column, so employees could filter it easily to the current date.  Thank you so much! BRJulia Bauer

113
julia.bauer
Level 5
A
Level 2
alice.sansoLevel 2
asked in Data Ingestion & Infrastructure
I'm working with views and I'd like to show a chart only when a runtime varible has specific value. How can I do that?

I'm working with views and I'd like to show a chart only when a runtime varible has specific value. How can I do that?

64
A
Level 2
J
Level 2
juan.gomez12Level 2
asked in General Product Q&A
Error in formula using variable

Hi there!I've a problem using a variable in a formula of OLAP_TABLE.I've two variables (Interv_1, prueba_var1) text/replacement Type, with values:Interv_1=OTHERPrueba_var1=3 If i want to use it in a text component, with variable "prueba_var1" is OK, but if i use the Variable "Interv_1" i have a formula error. I don't understand why..... Thanks in advance    

163
janpeter.van.d
Level 8
J
Level 2
jenea.mdLevel 2
asked in Data Ingestion & Infrastructure
How to get Distinct Case Key with values different than 0?

Hi everyone, I am trying to build an OLAP Table where I need to have "Case Key" Column. The problem I have is that I need to highlight just the CASE KEY Values (distinct) for which in column "Parameter" the values are different then Null. Here is the input table: Here is how the Output Table should look like:  Any idea on what should I do to get that OLAP Table? I tried with CASE WHEN + ISNULL Functions but so far without any succes. Thank you in advance for any tips!

64
J
Level 2
L
Level 3
louis.forst12Level 3
asked in General Product Q&A
Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

Can i create a Conformance Ratio KPI (like on the Conformance Overview) using the conformance query

157
janpeter.van.d
Level 8
itay.tarab
Level 3
itay.tarabLevel 3
asked in General Product Q&A
We have connected one of our SAP system to Celonis with the O2C extractor provided by Celonis.We managed to execute the extractions in full load but when we are trying to execute the transformations in full load we are running into the next failure:

Error while executing transformation Create Table: O2C_VBAP_STAGING, with id 9cad7fcb-8759-4fc6-81d0-67d45242ee78: ERROR: Relation "MAKT" does not exist

134
itay.tarab
Level 3
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in General Product Q&A
PQL function to get maximum of two values (similar to Excels MAX function) to make a upper limit.

I have a quite complex query to calculate a KPI and want to limits its result to a maximum value.  This max value is stored in a variable with an absolute value of e.g. 2.If the actual result of the KPI is higher than 2 the PQL should return 2. I set this up as an CASE WHEN but this is repetitive code which is badfor readability and maintainabilty.  Are there more consise approached possible with PQL? e.g. using a Max(KPIcode, Limit) Excels Max function works something like this. But PQL Max works only on a column. just for reference my PQL looks something like this:CASE WHEN (... 5 lines of code to calculate KPI) > <%= Limit %> THEN <%= Limit %> ELSE (... 5 lines of code to calculate KPI) END    

123
manuel.wetze
Level 5
A
Level 1
akihiro.nishi13Level 1
asked in General Product Q&A
Confirm the PQL syntax for the KPI "Actual DSO" in the KPI.

My customer installed the following Apps from Marketplace and check the KPI.・SAP S/4HANA - Accounts Receivable - Working CapitalShe would like to confirm the following PQL syntax for the KPI "Actual DSO" in the KPI.Here are the three points she would like to confirm.(1) What is the formula for KPI_AR_DSO calculated for?(2) What do {p1} and {p2} represent in the formula?(3) If I understand (1) and (2), I may know what Actual DSO is calculating.It would be helpful if you could also tell me what the Actual DSO is KPI to produce.―――――◆AppsSAP S/4HANA - Accounts Receivable - Working Capital◆KPI nameActual DSO◆KPI PQLKPI("KPI_AR_DSO", <%= VAR_US_CURR_TIMEFRAME_START %>, <%= VAR_US_CURR_TIMEFRAME_END %>)KPI_AR_DSO:SUM(  CASE    -- When the date is right    WHEN PU_FIRST("<%=VAR_GS_CASE_ITEM_TABLE%>", "_CEL_AR_ACTIVITIES"."EVENTTIME", "_CEL_AR_ACTIVITIES"."ACTIVITY_EN" = '<%=VAR_ACTNAME_ENTER_IN_SAP%

82
A
Level 1
U
Level 3
ugandhar.konapLevel 3
asked in Data Ingestion & Infrastructure
Want PQL query like get total number of ID's which having only Pass. If having both pass and fail in it those ID's shouldn't consider. Only consider the ID's which having Pass in all rows of a particular Id.Answer should be 2

22
bunyod.sap
Level 4
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Product Q&A
Change material master data with SAP Action Flow Module

Hello everyone, can anyone share experiences with the SAP Action Flow module? As of right now, this seems quite risky as while testing the AF direct changes in SAP are made (when only having a productive environment EMS). In our case, I want to change material master data if several conditions are met. Thanks so much! BRJulia Bauer

224
julia.bauer
Level 5

Badge Winners

  • Value Assessment Expert
    jiangwei.wanghas earned the badge Value Assessment Expert
  • Qualified to Identify and Drive Opportunities
    jiangwei.wanghas earned the badge Qualified to Identify and Drive Opportunities
  • Qualified to Prove Celonis Value
    jiangwei.wanghas earned the badge Qualified to Prove Celonis Value
  • Qualified to Get Data Into Celonis
    l.colzanihas earned the badge Qualified to Get Data Into Celonis
  • Qualified to Build Views
    Pablo MChas earned the badge Qualified to Build Views
VIEW ALL
Community Code of Conduct