position- business relationship and job relationship report

[viel]

Hello,

I'm currently creating an advanced reporting to validate business relationships between position and employee profile, but whenever I include the Incumbent(s) Job Relationship object, I always get duplicate records. I also tried changing the Date Options, but nothing changed. Could you please help?

Here's the sample record:

Thank you so much.

Regards,

Ronna

[Barbar]

HI Ronna, did you able to solve this issue? thanks a lot, Anna

[nlgro02343]

Now if we look at it from a reporting perspective, this may not per se be a duplicate.
I assume the person doesn't have multiple records on the 3/23/2022 (if that is the case, you may want to use the latest-effective-date flag as filter and put it to y)?

We can't see how the job info record(s) and job relationship record(s) look like, but assuming the employee has 3 job relationships and 3 possible people that could be in those job relationships, it just does 3X3 in terms of options = the 9 records we see. To get that aligned you need to either exclude some fields or you need to apply filtering on 1 of the fields that deviates in 1 / both entities (without knowing the fields to your disposal and what combo is acceptable, that is hard to assess).

[karenperez]

Dear viel,

Did you try to create a calculated columns to avoid those duplications? Here is a KBA that may help as a starting point: https://launchpad.support.sap.com/#/notes/3101609

Thank you.

Best Regards,

Karen Perez