Product Q&A

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

Hallo, as pycelonis states: Using this package you can programmatically interact with Analyses, Workspaces, Data Models, Data Pools and other Celonis objects. The package also allows pushing and pulling data to and from Data Pools and Data Models. I would like to programmmatically interact with celonis analysis (mainly) and extract the data for other purposes and to other sources. That means, the statement suggests to me the possibility to extract the data from Celonis into an external database like say MySQL. I dont find a supporting material on this in the documentation. Can someone shed a bit more light into the darkness here?

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..!