Product Q&A

Please share Human Resources Case Used Case & Value Tree details

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. 

How to uplaod password protected excel sheet in file uploads

Hello, are the certification classes in Spanish?

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

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

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.

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

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.

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

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

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?

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?

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

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

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

How to remove unused Microsoft Connection in Action Flows?

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

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!

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?

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

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? 

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

Hi Team,I need R2R Process Connector for Oracle EBS. Can any one provide it?or Can anyone guide me on that?