Product Q&A

Is it possible to create a multi line chart in Celonis Studio? Thanks

Hi everyone, I create an Action Flow module to trigger my Studio Skill automatically but I encountered an error ("Failed to load data!") choosing which skill should be triggered like in the screenshot.   How can I solve this problem ? Thank you, Ugurcan 

How to find the Cluster Details in the Training environment? Please Help!

does celonis has a unit4 connector?

We have an OLAP table with 2 columns i:e NAME (vendor name) and CASE COUNT". We have applied Button Dropdown as filter criteria having co. code as a variable. Now the problem statement is whenever we make a selection of 1 company code in Button Dropdown, OLAP table shows the corresponding data, however when we go for multi selection (multi selection is enabled) of company codes, it throws an error. Not sure why. We have recreated the entire sheet but all in vein. Any thoughts here would be of great help.

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!