Product Q&A

Trying to find a transformation tasks where a particular table is used, right now going through each and every task its very time consuming effort.

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.

Can we send the screenshot of the dashboard sheet in email through the action flow?

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

Data Integration service cannot be reached error coming on UI while service is up and running on UAT. Please suggest any way how to fix this.

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

Hi Experts,Is there any way to fetch user login history to data pool?Try to build visualisation on user/app performance and I need this data in app/ studio.I have checked custom data pipeline and monitoring but it's not there.

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

Do we have a any document how to integrate blueprism with celonis?

Do any of you know how to count the number of different currencies on a given supplier ? I want to create a condition that determines if the currency on a new incoming document is different from the least occurring currency on previous documents of the same supplier with the same company code.

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?