News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to link cdm_leaver...

Finance | Project Operations, Human Resources, ...

Answered

How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

(0) Share

Report

Report

Posted on by Martin Booth

30

Hi

I'm trying to create a power bi report that shows leave request details but filtered on the leave reason code, but I'm struggling to link the two tables together.

Can you please help

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Parag Chapre 12,271 Most Valuable Professional on at

Like (1)

Report

RE: How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

Hi Martin,

The link is cdm_leaverequestdetail > cdm_leavetypeid and cdm_typeid from cdm_leavetypereasoncode
Martin Booth 30 on at

Like (0)

Report

RE: How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

Hi Parag

Thanks for the diagram. I still can see how to link the two specific tables together from the diagram, have I missed something?
Suggested answer

Parag Chapre 12,271 Most Valuable Professional on at

Like (0)

Report

RE: How to link cdm_leaverequestdetail to cdm_leavetypereasoncode

Hi Martin,

Please check this link for the relationship model.

docs.microsoft.com/.../hr-developer-entities

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,431 Super User 2024 Season 2

#2

Martin Dráb 230,503 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans