OTBI report per current details

Summary

Create a report that presenting only the valid data

Content

Hi,

I'm trying to create a report that will present only the valid assignment, manager, job description etc.

The problem is that if some employee were changed (e.g. during 2018 he changed his job) I'm getting duplicate rows that present the old information (previous job description) and the new information (new job description).

How can I define in the report that will only present the most recent information (the valid one)?

I'm using the subject areas 'workforce management - person real time' and 'workforce management - worker assignment real time'.