Product Q&A

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!

Will the table get locked in first session and the other will wait till the former releases the lock?Will records be inserted from both sessions simultaneously? If so, how many such parallel inserting sessions can be run simultaneously?

How to find number of rework activities with PQL?

I would like to know how is the Celonis certification exam structured. Are there multiple choice question, case studies etc? Are these centered around the courses we undergo on the Celonis Academy or do they test knowledge application based on the course?

Hi Celopeers, Currently, we are facing the challenge of being able to extract metadata from excel, word, PPT files in order to mine the general activities performed in these applications and include them in an eventlog, for example the activities: open document, update document. For the moment we do not want to go to the level of detail of knowing what was done specifically in the document (which would mean a task mining use case). With this premise, I would like to ask you if you have had a similar case and what would be the best method to extract this metadata and generate the eventlog? Thanks everyone! -------------------------------------------------------------------------- Actualmente, estamos enfrentando el reto de poder extraer los metadatos de archivos excel, word, PPT para poder minar las actividades generales que se realizan en estas aplicaciones e incluirlas en un eventlog, por ejemplo las actividades: abrir documento, actualizar documento. Por el momento no queremos llegar

Hello everyone. We are trying to connect to the Microsoft Power Automate module in the Action Flows. However it is giving us the following error: "AASDTS900971: No reply address provided.".  We have followed the instruction in this link https://docs.celonis.com/en/microsoft-power-automate--action-flows-.html but I keeps giving us the same error. I have google the error a it says that the problem is the redirect URL. We are using the following URL: "https://auth.redirect.celonis.cloud/oauth/cb/microsoft-smtp-imap” and when we try to access the url it gives us the following:  Does anyone know how to solve this problem?Thank you

If we are using DOMAIN_TABLE in an analysis, the external filters applied (Load script/Sheet level/Component Level) may not work properly in all cases. I could see such cases when DOMAIN_TABLE used, external filters will not work properly. Any thoughts on this or my approach is not correct? Can someone comment on this

Is this function only for activity tables? If so, is there another function I can use to update tables in my data pool?

Hi all, Is there a Sandbox for the EMS system that can be accessed for Partners for understanding more how the system works. And if there is training as *how to use* the EMS system would also nice.  Thx

Can anyone help me with the code for creating CLI profile?

Senior Process Mining Value EngineerGrundfos Location: Zagreb (HR), Indjija (SRB), Bjerringbro (DK), Budapest (HU) (Hybrid or Remote)Description: The role of a process mining value engineer is to identify process improvement and automation opportunities by using process mining techniques, tools and technology. (Check out the full description following the link) Apply here

One of our user has been facing an issue where she can export the data using "export data" option whereas when she selects "export cases" it shows as generated and finished but download doesn't start. Any particular reason for this? Note: In this scenario, the size of the data being retrieved is very small compared to cases from an OLAP table and i have found that her system has only 2gb of storage left. The cases export is roughly 30mb of size(based on the extraction done from my end).

In the training "Add Chart Layers and Context in Views Example" they use the rule mark to add "average of sales by state". I am looking to do the same in one of my views. I would like to be able to add the Median of a KPI to a chart of mine.  What does the PQL for this KPI in the example look like? I get errors of nested aggregation when I try to take the median of my KPI. 

Hello, I have a view that has 2084 rows, but when I use it in a Data Model, load the DM and check the details, it says 5772 rows were loaded. As a result, Analysis based on this DM is showing me incorrect data that does not even exist in the DB view. Is this a bug or what is the problem???