OTBI Analysis with EIT fields

Apr 8, 2021 4:39PM

Summary

Need to display current Parent Position Code for the record but EIT causing duplication

HI all,

I need some help with an Analysis - I have paired the analysis down to the very basic fields

I am using the Workforce Management - Worker Assignment Real Time subject Area

I have selected Person Number, Position Code, Parent Position Code and an EIT field

When I include the EIT field, ALL parent position records are pulled into the analysis (I only want the latest one)

I have tried using all sorts of date fields with no luck (the date appears to be the same in the subject area)