Product Q&A

Hello there,I am trying to embed a view by variable value. Using the explanation on (https://docs.celonis.com/en/views-variables.html) this is the current state.  Here I have created the view-variable 'embed_variable' and two separate views with the keys 'embed-test-source' and 'embed-test-source-alternate'. If the value of 'embed_variable' is '1' I want to embed the 'embed-test-source' view just how I want to embed 'embed-test-source-alternate' when the value of the variabe is '2'. I tried to follow the example from Celonis metioned above, so I'm not too sure about what the errors mean. Has anyone experience using this method and can tell me where I went wrong? I would be very grateful. 

I'd suspect a lot of activities happens outside of Celonis, initially to 'prepare' the data quality, ensuring its reliability and integrity once in Celonis. I'm sure there's a lot of common challenges when uploading into Celonis, and have experienced some myself.

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?

Hello @1460018848​ ,  I am looking for a similar concept where i need to trigger an action flow when another one finishes. Where you able to achieve this? it would be really great if you could share some insights or guide me through some documentation that you may have looked into :)  TIA!

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

I want to extract a table "SRRELROLES" from SAP system. For this table, I have to use dynamic and private parameters on the column "UTCTIME" UTC Timestamp in Short Form (YYYYMMDDhhmmss).  I get an error for delta extraction since the data type I use is date (I have tried integer and double but neither worked)and the data type of UTCTIME is float according to SQL vertica in Celonis and UTCTIME has data type DEC in the SAP system.  My question is which datatype can I use for my dynamic and private parameters? Or how can I define a variable inside the FILTER STATMENT or DELTA FILTER STATMENT in order to get the max of the UTCTIME and use it for my delta extractions?

SELECT TO_DATE(    TO_CHAR(ADD_MONTHS(CURRENT_DATE, 1), 'YYYY') || '-' ||    LPAD(TO_CHAR(EXTRACT(MONTH FROM ADD_MONTHS(CURRENT_DATE, 1)), 'FM00'), 2, '0') || '-' ||    '01',    'YYYY-MM-DD') AS FIRST_DAY,DATE '2023-12-01' - INTERVAL '1 DAY' AS END_OF_THE_MONTHFROM "CRM_VBAK";

Here is the example