General Product Q&A

Hi everyone,I am pretty new to Action Flows and currently I am trying to trigger an Action Flow by clicking a button in one of my analyses. Is this technically even possible? I couldn't find any fitting trigger modules in my Action FLow instance. Thanks in advanceFynn

Data-> Data integration ->New Data Pool -> Create from Scratch ->Name and Save -> Connect to Data-> Upload Files -> Select files (my csv) -> Run Succed. I can see the files but still dont have any Data connections.. what i miss???

I try to calculate overall Business impact for all KPIs and Show it in one sheet. KPIs are validated with different SAP time areas. KPI 1 is validated with AUFK.ERDAT; KPI 2 is validated with AFRU.BUDAT and my goal is to calculate 2022 impact.

I looking for above connector but didn't find. Could someone tell me how can i build that.

I'm wondering if this is a glitch or if I'm missing something very obvious. I've edited the record attribute in my Data Model to be in the date format %y-%m-%d, but for some reason it is displaying with hours, minutes and seconds. Please seen the screenshot. What am I missing? I have refreshed my browser, and exited edit mode several times.

Hi, DPO is the average number of days a company takes to pay its suppliers.Here is the logic I found in the process cockpit. Why do we need to multiply the "BSEG"."WRBTR field here as we need only the days of difference ? SUM(   CASE       WHEN ISNULL("BSEG"."AUGDT")=1           THEN 0.0       ELSE DATEDIFF(dd, ROUND_DAY("BKPF"."BUDAT"), ROUND_DAY("BSEG"."AUGDT")) * "BSEG"."WRBTR"   END)/SUM(   CASE       WHEN ISNULL("BSEG"."AUGDT")=1           THEN 0.0       ELSE "BSEG"."WRBTR"   END)

hello, I'm trying to analyze the changes on the delivery headers (LIKP) but I wanna filter a specific plant. When I try to creat an OLAP table with the changes and the plant (LIKP.VSTEL) I get the following error message:"No common table could be found. The tables ["_CEL_O2C_ACTIVITIES"] and ["LIKP"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [_CEL_O2C_ACTIVITIES]N <-- 1![VBAP]!1 --> N[VBFA]N <-- 1[LIPS]N <-- 1[LIKP]. For more information on the join path, search for "Join functionality" in PQL documentation.", Does anyone know how to join these two tables ?Thank you!

I have the problem when deleting a data pool that only the content is deleted. I.e. all connections, extractions, data jobs, etc. are deleted. However, the "shell" of the data pool cannot be deleted.

Hi, The logic for OTD is given as below in Process cockpit WHEN PU_COUNT ( "EKPO" , "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" , "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Record Goods Receipt' ) > 0 AND DAYS_BETWEEN ( PU_MAX ( "EKPO" , "EKET"."EINDT" ) , PU_MAX ( "EKPO" , "EKBE"."CPUDT" , "EKBE"."VGABE" = '1' AND "EKBE"."SHKZG" = 'S' ) ) <= 10 AND DAYS_BETWEEN ( PU_MAX ( "EKPO" , "EKET"."EINDT" ) , PU_MAX ( "EKPO" , "EKBE"."CPUDT" , "EKBE"."VGABE" = '1' AND "EKBE"."SHKZG" = 'S' ) ) >= ( -1.0 * 10 )  two questions I have 1. why do we need days_between and PU_MAX when we can use DATEDIFF(DD, <DATE>, <DATE> ) field? -- Is it because only then it will calculate for all the cases?I don't und

Hello, In the analysis view, I would like to multiply a set of values with a random operator similar to RAND() in excel however I cannot find anything like this in the documentation. Does anyone know if there is such an operator ?Thank you

How to calculate automation rate in PQL?

Hello all, is it possible to visualize the data job logs in an analysis or view in the studio? My customer would like to have an overview that shows how often the job failed or was canceled. Can I get this information from the Data Job Logs into the Knowledge Model? Best regards,Sarina

I found this in Celonis documentation for the first part of the issue, but this only works for dollar-signs, whereas I'm using pounds.

Is there an celonis certification exam specific to the Execution Management Consultant Role.?

These parameters can be found in the imported data (is attached). I would like to know, if is this "filtering" on cases, based on on-time delivery and conforming to the order quantity, is possible. Many thanks for the support. P.S. i am a newbie without experience with PQL

I am new on celonis and i want to ask if i can add mine csv file to play with on ems.

Hello, I'm trying to know how many different Materials I have inside a shipment. This shipment can have multiple DNs, when I try to create an OLAP table with Shipment Nº/Delivery No./ Material I get the following error: "No common table could be found. The tables ["VTTP"] and ["LIPS"] are connected but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [VTTP]N <-- 1![LIKP]!1 --> N[LIPS]. For more information on the join path, search for "Join functionality" in PQL documentation.". How can I solve this issue? Thank you

Can I create view using two or more knowledge models?

Hi, I have the fields which I'd like to visualize. These fields are: Source country (e.g. Spain)Destination country (e.g. Italy)Number of cases (e.g. 5) Ideally, I'd like to use an alluvian or sankey diagram. A map showing all flows would work as well. Is ther any way to have these when working with analysis?  Thanks in advance

Hi, I'd like to set the background of my dashboard coloured in black. How can I do this? Thanks in advance

I tried trimming the particular column upto 20 character but failed again with same issue. Can some help on this.

Is there a better way to select multiple columns in Replication Cockpit rather selecting it manually?

Need help troubleshooting what I'm missing, and guidance on the next steps ASAP. TIA