How to get Home email and business email addresses in OTBI reporting

Summary:

How to get Home email and business email addresses in OTBI reporting?

Content (required):

We are trying to get employees home email and business email addresses along with other assignment details through OTBI subject areas, but we are getting duplicate rows for each employee record. Is there a way to remove duplicate rows other than PIVOT. As pivot is erroring out when it is run for all users.

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):

Subject area query is attached