Product Q&A

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?

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

Hi all, I received an error where the aggent is already connected, but I don't get to create a connection between Extractor and RFC module.The error on EMS is that the connection between sap and extractor could not be established and that we need to open port 33xx. But on Agent log the error is below. We don't know how to solve this 2023-02-10 18:16:05.698 [main] INFO c.celonis.saprfc.system.JCoLoader - Creating JCo destination provider 2023-02-10 18:16:05.995 [main] INFO c.celonis.saprfc.system.JCoLoader - JCo successfully loaded 2023-02-10 18:16:06.401 [main] WARN c.c.a.c.h.c.HttpProxyConfigurationBase - Proxy is not enabled, requests will not go through the proxy. 2023-02-10 18:16:06.401 [main] INFO c.c.a.c.h.s.ProxyHttpRequestFactoryBase - Proxy not configured, requests will not go through the proxy. 2023-02-10 18:16:07.760 [main] INFO c.c.a.a.AutomationAgentApplication - Started AutomationAgentApplication in 7.297 seconds (JVM running for 8.891) 2023-02-10 18:16:07.760 [ma