Product Q&A

Please share Human Resources Case Used Case & Value Tree details

411

4 years ago

jaikishan.pandy11Level 3

Data Ingestion & Infrastructure

Data Connection Error : Telnet connection to the host MSSQLSERVER2019:1433 failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions.

Hi, I am trying to create a new connection to the on-prem MS SQL Server Database on my personal system for training purposes with database type as Microsoft SQL Server(native) but getting an errorTelnet connection to the host MSSQLSERVER2019:1433 failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions.Please see the screenshot below.Port Number: 1433 Please help to resolve the issue.

622

4 years ago

.1460088470Level 3

Process Improvement

My action flow does not run after I set the automatic scheduling

806

4 years ago

muskan.singh15Level 4

General Product Q&A

How to uplaod password protected excel sheet in file uploads

423

4 years ago

claudio.salvaLevel 1

General Product Q&A

Hello, are the certification classes in Spanish?

284

4 years ago

tomoki.tsuneLevel 4

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%>")))

101

4 years ago

.146003860Level 4

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

662

4 years ago

praveen.ojha12Level 6

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.

171

4 years ago

jaikishan.pandy11Level 3

General Product Q&A

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

362

4 years ago

mel.schic12Level 1

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.

121

4 years ago

ankur.sahanLevel 1

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

151

4 years ago

.14601241Level 3

General Product Q&A

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

432

4 years ago

guturi.rajdeLevel 3

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?

231

4 years ago

yuanyuan.zhangLevel 1

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?

172

4 years ago

ryotaro.manabLevel 3

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?

321

4 years ago

ömer.petekLevel 7

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".

691

4 years ago

prasanth.s12Level 1

General Product Q&A

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

493

4 years ago

.146001156Level 3

General Product Q&A

How to remove unused Microsoft Connection in Action Flows?

482

4 years ago

swathi.swath14Level 1

Data Ingestion & Infrastructure

Premise 4.6 - User analysis stats and usage

We are trying to do a user analysis to understand the usage of Celonis applications and were able to process the audit logs. Is there a way to understand how many Users were created along with user groups and Date of creation of User id etc. Swathi

593

4 years ago

alex.timm11Level 3

Data Ingestion & Infrastructure

Applying filter to KPI calculation

Hello everyone,here is my case: I am using SAP table CRMD_ORDERADM_H as case table. I am using PU_SUM to have an OLAP table column with the sum of CRMD_ORDERADM_I.NET_VALUE grouped by CRMD_ORDERADM_I.HEADER (case id). I am using a dropdown to filter for CRMD_ORDERADM_I.ORDERED_PROD. It works in so far that the table only shows cases, where at least one item has the selected PROD, but the sum stays the same.I would like the filter to be applied to the sum.In case you are not familiar with SAP tables - I added a mock up of what I am trying to do.Have you got any ideas how I could accomplish that?Thanks in advance!

1143

4 years ago

anamitra.senguLevel 0

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?

251

4 years ago

.14600109512Level 1

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

423

4 years ago

reenu.josep12Level 6

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?

261

4 years ago

.146001215Level 0

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

251

4 years ago