Finance | Project Operations, Human Resources, ...

Electronic Reporting - join two table for finding a data

Like (0) Share

Report

Posted on 17 Apr 2020 12:36:34 by Giorgio S

Hi Everybody,

I am new in using Electronic reporting.

I have a problem for retrieving some data to generate an xls file.

I have to data sources:

HcmEmployeeEntity --->tab1

HcmPersonIdentificationNumber --->tab2

From the tab2 I have to export all information related to PersonalNumber(fiscalCode), full name and e-mail, I can find this information easily with the predefined relations with people table.

From tab1 I have to extract for each row coming from tab2, the related employment start date.

There is no predefined direct relation between the 2 tables but the relation with people table can help for my purpose, now my question is:

How can I collect the information I need?

For me this is a normal lookup between 2 datasource but I can't find the right way for doing it.

Does anyone help me

Regards

Giorgio

All responses (4)

Answers (0)

Timo Tenni on 14 May 2020 at 05:54:33

Like (0)

Report

RE: Electronic Reporting - join two table for finding a data

Thank you Giorgio for the update and sharing the you resolved the issue.
Giorgio S 15 on 07 May 2020 at 12:49:45

Like (0)

Report

RE: Electronic Reporting - join two table for finding a data

Hi Everebody,

For your information I solved the problem using the relations inherited directly by the model.

Thanks

Girogio
Suggested answer

Timo Tenni on 24 Apr 2020 at 08:42:11

Like (0)

Report
RE: Electronic Reporting - join two table for finding a data

For lookup data in other table we can use:

FILTER function

JOIN datasource

Call application methods (like ::find())
Suggested answer

Svetlana Kosheleva on 20 Apr 2020 at 13:35:27

Like (1)

Report

RE: Electronic Reporting - join two table for finding a data

Hi Giorgio,

Could you please specify what are you trying to achieve by using Electronic Reporting feature for HR data?

Electronic reporting is mainly used for financial reporting purposes.

If you need to export HR data from the system you can use Data Management feature, which is design for export/import data in D365.

Here you can find more info: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/data-entities-data-packages

If you have any questions or comments, please let know. Thank you in advance!