Max Effective Date Record on a Combined Subject Area Report
I need to be able to report on most recent employee addresses (HOME and MAIL) based on their maximum effective date from the Person Real Time Subject Area in an OTBI analysis that is also a combined subject area report.
I've used the following filter to bring back the latest HOME/MAIL address alongwith other employee information.
"Person Address"."Address Effective Start Date" = MAX("Person Address"."Address Effective Start Date" by "Workforce Management - Worker Assignment Real Time"."Worker"."Person Number", "Person Address"."Address Type Code")
My query times out when I run the report for a specific country, works fine when I'm running it for a specific person number.