Product Q&A

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

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?

I have an ACTIVITIES table where I am trying to calculate the time (in hours) between each OPERATION. The way it is set right now, I have CASE_KEY and for each CASE_KEY, there can be 1 to N operations. What I am trying to do is to calculate the time difference between each unique operation (for ex: for operation 0100 to 1000 the difference is 10 hours, for operation 1000 to 2000 the difference is 15 hours..etc) So I was able to utilize HOURS_BETWEEN and using SOURCE and TARGET, I was able to calculate the hours. What I have a column that indicates Operation start and Operation end. Based on that I am able to calculate the HOURS BETWEEN Operation by using End as SOURCE and Start as TARGET. The problem I run into is when there is an operation starting within an operation. So for ex: Operation 0100 starts, then right after Operation 1000 starts followed by Operation 1000 end and then after Operation 0100 end. Given how I am using Source and Target at the moment, it is definitely skewing t

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

I have cases table with _CASE_KEY and OPERATION NUMBER. Each _CASE_KEY can have N operations. For ex: _CASE_KEY: 01000200OPERATION 0001OPERATION 0100OPERATION 0500OPERATION 0700 (etc)_CASE_KEY: 03000200OPERATION 0001OPERATION 0100OPERATION 0500OPERATION 0700 (etc)The goal is to calculate the time it takes from last operation of a case to first operation of the next case. In the example above, it would be time difference between the _CASE_KEY 01000200, OPERATION 0700 to _CASE_KEY 03000200, OPERATION 0001. I am trying to use the PU_FIRST and PU_LAST to accomplish this goal but unfortunately it is NOT giving me what I am looking for. Any help would be appreciated. I do have the ACTIVITIES table where all of these operations that I've mentioned above are shown.  

can we import .xml to use it as .bpmn for Conformance checker?

Data in the CPUTM column in BKPF and UTIME column in CDHDR tables are '11/13/2018'. So the flow seems to be incorrect. Please clarify. Thanks!