General Product Q&A

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

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

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

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

Hi all,​I would like to create heatmap (or data to create it) by Celonis. Does anybody know how to do that? my image is in below link and its X-axis is 00:00:00 to 23:59:59(and if I can change it to monthly or yearly is more better) and Y-axis is activity to know when is the activity occurred. ​image sample https://reelyactive.github.io/diy/kibana-heatmap-space-time/ Thank,

Hi Team, A year back i completed certifications on solutonal and implimentational professional.Now my certifications got expired and now i want renew them. But could not find the same. I also wnated to do other certifications based data engineer and business analyst. Could any one help me in getting new link for doing celonis certifications

Lets imagine I have a line graph. My KPI is order count. My dimension is the months of the year whose data comes from Table A's column B. So my dimension is ROUND_MONTH("A"."B") Which filter I need to add to see only the last month?

Dear all, is there a way to include the selected filter criteria when exporting data to xlsx or CSV? Thank you and kind regards, Michaela