Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 2,559 Topics
  • 5,879 Replies
2558 Topics
C
Level 2
claudio.salvaLevel 2
asked in General Product Q&A
Hello, are the certification classes in Spanish?

Hello, are the certification classes in Spanish?

04
C
Level 2
T
Level 3
tomoki.tsuneLevel 3
asked in General Product Q&A
What does "dispute case" mean in Production context?

I've introduced the Production Planning template of SAP, encountering a Saved Formula named Automation Rate Case.It has description as "automation rate based on the dispute case." What does it mean in PP context?The formula is as follows. 100.0*(SUM(PU_COUNT("AFPO", "_CEL_PP_ACTIVITIES"."ACTIVITY_<%=language%>", ISNULL( "_CEL_PP_ACTIVITIES"."USER_TYPE")=0 AND "_CEL_PP_ACTIVITIES"."ACTIVITY_<%=language%>" IN (<%= ActivitiesUsedInAutomationRate %>)AND "_CEL_PP_ACTIVITIES"."USER_TYPE" IN (<%=AutoTypes%>))*1.0)/SUM(PU_COUNT("AFPO", "_CEL_PP_ACTIVITIES"."ACTIVITY_<%=language%>")))

00
T
Level 1
.
Level 3
.146003860Level 3
asked in General Product Q&A
How do I filter on a column chart?

Hi, How do I filter on a column chart?  I want to only see data on 'Fallouts' and exclude anything that has the name 'NULL'.Thanks,Terence

82
.
Level 4
praveen.ojha12
Level 3
praveen.ojha12Level 3
asked in General Product Q&A
Can we apply filters to specific Knowledge Model KPI?

Is there a way to create a filter specific to certain KPI in knowledge model or Can we have filter whose scope is limited to certain KPI.

00
.
Level 7
J
Level 3
jaikishan.pandy11Level 3
asked in General Product Q&A
How to calculate the lost and possible cash discounts. Please share the relevant fields and logic?

How to calculate the lost and possible cash discounts. Please share the relevant fields and logic?

42
.
Level 4
M
Level 2
mel.schic12Level 2
asked in General Product Q&A
Finding alternative Contract for same Vendor with a later Contract End Date

I would like to find whether a follow up contract exists for a certain contract based on the vendor in the contract. All data about the contracts is stored in Contract_Info Contract Number: "CONTRACT_INFO"."CONTRACT_EBELN" Contract Vendor: "CONTRACT_INFO"."LIFNR"Contract Start: "CONTRACT_INFO"."TS_KDATB"Contract End: "CONTRACT_INFO"."TS_KDATE" What I would like to see is:For “Contract Number A” give me “Contract Number B” matched on “Contract Vendor” when “Contract END A” < “Contract END B” I have tried quite some PQL / PU function, however I am not able to get near to the data I want to see.

10
.
Level 4
ankur.sahan
Level 1
ankur.sahanLevel 1
asked in General Product Q&A
1. Can't we make a copy of entire analysis with its data model. Every time when we tried to copy an analysis, it asks for the data model.2. How to identify which data model is used for an existing analysis

1. Can't we make a copy of entire analysis with its data model. Every time when we tried to copy an analysis, it asks for the data model. 2. How to identify which data model is used for an existing analysis

11
P
Level 4
.
Level 3
.14601241Level 3
asked in General Product Q&A
How can i build an action flow that does something if Data in Celonis changes?

How can i build an action flow that does something if Data in Celonis changes?

150
.
Level 3
G
Level 3
guturi.rajdeLevel 3
asked in General Product Q&A
Iam not able to see some BELNR's in BKPF which are available in BSEG and iam applying the same filter GJAHR> 2021 in both tables. What is the solution for this?

Iam not able to see some BELNR's in BKPF which are available in BSEG and iam applying the same filter GJAHR> 2021 in both tables. What is the solution for this?

01
T
Level 3
Y
Level 2
yuanyuan.zhangLevel 2
asked in General Product Q&A
Could you please advise the time i circled in the attached picture mean？

It would be great if you can advise what's this "20 hours" mean in process explorer and advise which process it's throuhg from?

02
.
Level 4
R
Level 3
ryotaro.manabLevel 3
asked in General Product Q&A
How to change the byte limit of Data Push API?

When uploading a table with the Data Push API, there is a limit of 80 bytes. How can I increase this limit?

40
P
Level 4
Ö
Level 4
ömer.petekLevel 4
asked in General Product Q&A
Hello,What do "select analyze_statistics ('bkpf');" statement and "Explain" stament do in the data jobs ?it always returns "0".

Hello, What do "select analyze_statistics ('bkpf');" statement and "Explain" stament do in the data jobs ? it always returns "0".

50
P
Level 4
prasanth.s12
Level 2
prasanth.s12Level 2
asked in General Product Q&A
How to pass an existing variable from button dropdown to OLAP table dimension in Celonis?

How to pass an existing variable from button dropdown to OLAP table dimension in Celonis?

63
G
Level 8
.
Level 3
.146001156Level 3
asked in General Product Q&A
How to remove unused Microsoft Connection in Action Flows?

How to remove unused Microsoft Connection in Action Flows?

60
.
Level 3
A
Level 1
anamitra.senguLevel 1
asked in General Product Q&A
C4C+ Reallocation of Storage Space from an existing project

Hi, how do I achieve the following?My colleague as agreed to free up 50GB from an already running project of 80GB on C4C+ for my usageHow can I reduce the storage consumption of my colleague's project and allocate the now available 50GB to a project environment I will create?

10
D
Level 1
.
Level 2
.14600109512Level 2
asked in General Product Q&A
Data Integration Error: Uploading CSV file

Hi all,  when trying to upload my CSV file with my event log data I can upload it and see the actual data, however when trying to go to the next step i receive following error message (see below). Any idea on how to proceed here?  Thanks

20
B
Level 1
R
Level 4
reenu.josep12Level 4
asked in General Product Q&A
I would like to create the date picker where the dates are going to be taken based on Calendar in general and not on the Creation date / Event date etc from the Data Model Tables.

Can we set up the component which will take into consideration the calendar days and all components are going to be filtered accordingly as it is not going to be based on any of the columns? 

20
attila.cserv11
Level 3
.
Level 1
.146001215Level 1
asked in General Product Q&A
I would like to create KPI: pay on time exclude receive after due date and pay in 10 days from receive date.

OVING_MAX(COUNT( DISTINCT CASE  WHEN  DAYS_BETWEEN ( "BSEG"."AUGDT", ${INVOICE_DUE_AT}) >= - ${BUFFER_LATE} AND ${VARIABLE_RELEVANT_INVOICES_FOR_OTP} THEN ${VARIABLE_INVOICE_IDENTIFIER}  END) / COUNT(DISTINCT CASE WHEN ${VARIABLE_RELEVANT_INVOICES_FOR_OTP} THEN ${VARIABLE_INVOICE_IDENTIFIER} END  ),0,0)  I would like to create second part of this KPI- below only standard pay on time PQL formula

01
W
Level 1
G
Level 2
gaurav.bade14Level 2
asked in General Product Q&A
Can we Install Celonis Extractor in same machine as of Data source ?

We have installed Celonis extractor in a virtual machine where Oracle database is already placed. We are experiencing a error in connection now. I would like to know whether if we can place extractor in same machine as that of Data source and have jdbc connection.

60
G
Level 2
A
Level 2
alex.giorgLevel 2
asked in General Product Q&A
Is it possible to set Activity color in Process / Variant Explorer by formula? ...or by activity table field?It will be usefull in multilog scenario.Thanks,Alex.

Is it possible to set Activity color in Process / Variant Explorer by formula? ...or by activity table field? It will be usefull in multilog scenario. Thanks, Alex.

32
R
Celonaut
F
Level 3
florian.hoerl12Level 3
asked in General Product Q&A
Possibility to define multiple empty variable try catches in FILTER statement?

Hi all, I have implemented the following sheet filter statement, which only applies a filter if at least one value is in a variable (selected through a dropdown): <% if(customer_selection != "") { %>  FILTER whatever; <% } %>  ---------------- However, when I try to add another statement like the above for a second variable within the same sheet load script, then NONE of the two conditional filter statements work.  Can someone provide me with the correct syntax to define multiple of the above conditional filter statements in one sheet load script?   -------------------------  A second question is whether it is possible and if yes what the correct syntax is to define a conditional filter statement like the following: <% if(search_pattern_selection LIKE "XYZ") { %> FILTER whatever;<% } %> Thus, not testing for emptiness but testing with a LIKE comparer if certain values are in a variable.    @david.beche12​ any input on the two questions?  Than

30
M
Level 1
S
Level 1
sel.kumLevel 1
asked in General Product Q&A
Hi, In the Celonis 'Solution Professional ' certification track, I can't click 'Proof Methodologies' course. When I tried to search and find, this course is NOT showing up. Can you pls help me on what I am missing here? Thanks!

Hi, In the Celonis 'Solution Professional ' certification track, I can't click 'Proof Methodologies' course. When I tried to search and find, this course is NOT showing up. Can you pls help me on what I am missing here? Thanks!

01
.
Level 5
A
Level 2
aya.sasakLevel 2
asked in General Product Q&A
I think the root cause analysis in GUI (Conformance) only performs the first level of root cause, but is it possible to perform a multi-dimensional root cause analysis (second and third level) using Pycelonis? If so, please let me know how to do it.

I am also trying the Root cause analysis described in the Pycelonis tutorial from the top. https://celonis.github.io/pycelonis/1.6.0/tutorials/root_cause_analysis/01_Root_Cause_Analysis_Tutorial/ At the data model connection, I get a NameError when I specify a data model.I'm copying and pasting the data model ID, so I don't think it's wrong, but am I missing some operation?   The data model attempts to use this

30
A
Level 2
E
Level 2
elizaveta.bugaeLevel 2
asked in General Product Q&A
hello, I choosed case frequency. One of activity is particular interesting for us. it has two predecessor activities (there is more but lets focus on these two). from them to our activity goes 11372 cases. but the activity shows only 11116 cases

How is that possible?With best regards,Elizaveta

04
E
Level 2
K
Level 2
kiran.kanja14Level 2
asked in General Product Q&A
Hi, How to send Vendor specific information emails dynamically to only that vendors according to their email setup using Action flows and skills ?

How to send Vendor specific information emails dynamically to only that vendors according to their email setup using Action flows and skills ?

01
B
Level 1

Badge Winners

  • Celonis Certified Data Engineer
    vijay.v14has earned the badge Celonis Certified Data Engineer
  • Qualified to Get Data Into Celonis
    vijay.v14has earned the badge Qualified to Get Data Into Celonis
  • Celonis Certified Data Analyst
    colton.linem12has earned the badge Celonis Certified Data Analyst
  • Celonis Certified Data Engineer
    sebastian.lopez11has earned the badge Celonis Certified Data Engineer
  • First Post
    Aide_Yunuenhas earned the badge First Post
VIEW ALL
Community Code of Conduct