General Product Q&A

How do I create a clustered chart in views?

I understand that the certification exam is closed book, however is it allowed to use the Celonis documentation during the exam?

Is it possible to generate PDF from Views and send as attachment in email? We are able to generate such from analysis , but the visualization of analysis is limited e.g. cannot produce line chart with 2 dimensions (1 dimension by x asix and 1 by color).

Bitte kontaktieren Sie mich unter meiner Firmen Email: karl-friedrich.loeschhorn@paw-systems.com Karl-Friedrich LöschhornVice President|Business DevelopmentPeople at Work Systems AGFeringastraße 10 AD-85774 Unterföhring Tel:       +49 - 89 - 540 42 45 - 0Fax:     +49 - 89 - 540 42 45 - 11Mobil:  +49 - 172 - 9408041Email:   karl-friedrich.loeschhorn@paw-systems.comWeb:   http://www.paw-systems.com -------------------------------------------------------------------------Registergericht: München, Eintragungsnummer HRB 155947Sitz der Gesellschaft: Unterföhring, MünchenVorstand: Marcus Benjamin Schmelzer (Vorstand CEO), Uwe Lutz Ritter (Vorstand CTO)Aufsichtsratsvorsitzender: Prof. Dr. Alfred Ultsch------------------------------------------------------------------------ Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten S

 Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "A": key column ("E"),key ('20860378'), rows 11 and 12. Table "B": key column ("E"), key ('2967401'), rows 1755584 and 1952229.

How can I know the number of cases that were delivered early or on-time?

Missing INEFFICIENCIES_AUGMENTED_FRAMED_VALUE table at Value Discovery App for Procurement Starter Kit Hello @christian.preit​ , @1460046478​ , @1460045699​ and other group member. Im trying to setup procurement cockpit and stuck with error "undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found." at Value Discovery App.  I have been asking support and look at help document but no clue so far. Any guidance? Thank you.

Tried applying the filter statement in one of the filters of table but it didn't support the sql query. Any guidance would be really helpful.

Hi, We are trying to connect a third party application (SaaS) called Lincros as a new connection in a O2C project. What would be the best practice to establish a connection for it?

In our use case we need to send the data into excel format we tried with csv but in some region csv files are not working and client requirement is they want data in excel file so please provide the solution on this

while developing the action flows in studio i am using the microsoft 365 excel and in that could not find the action Add/ Update a Worksheet Row (Advanced) can i use any diffenrent option to create the table headers 

How to apply delta filters with Business Central APIs?

I don't understand the difference between a knowledge model view and a dashboard. The same components exist in views and dashboards, but who uses the views and when?

Good afternoon people ! Searching DOCS.CELONIS and CELOPPERS I didn't find any example on how to configure and run delta extraction with "Trigger-based Schedules". Please, if someone used the "Trigger-based schedule" in the Delta extraction (of SAP ECC P2P), could you guide me and/or give some configuration example? Thank You!

I have an OLAP table with a flag KPI (0 or 1) calculated at its end.How can I, or can I reference that KPI in a custom object to define a style rule to highlight rows where that flag is 1?

Hi everyone!. I have a question. How is possible discriminate a process flow accordin to a specific hour?For example i would like to discriminate a process where a specific activities is done before the 9 a.am respect the other. Thanks

Hello, my name is Alexandra. I wanted to ask if it is possible to make the data model that is in the background visible. So that I can see which tables and keys are used. I am an analyst.

Hi, Everyone! I have another question regarding AF. How can I combine the POs by Sales Rep and send all of the PO’s related to that person in one table/email? I tried to create a text aggregator and applied variables, but it's not working..

Hello, I need to make a field (column) of a table clickable. How can I do that? Thanks

Here is the example

Hello everyone, could you tell me if there is a formula in PQL where I can get the top 1 activities of a document? Example, the Purchase Requisition, had several repetitive reworks, I would like to pick the top 1 rework.

Good day, I am trying to use newly created attibutes on a record in Studio to define a new KPI, but it seems that the PQL editor for the KPI does not see the new attributes. Am I missing something? Thanks!

Is anyone know, how to configure KPI Parameters in Knowledge model KPI's and YAML code.? If yes can you please let me know the syntax in PQL. Thanks in advance..!

Is it possible to calculate the time taken between an activity and today's date?