Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OTBI Analysis how to pull the latest dated row from a bunch of rows

User618255-OCJun 22 2017 — edited Jun 24 2017

Hi All,

I have an OTBI Analysis where 3 assignment rows come up for an employee in a report. Is there a filter I can use that only gives me the row with the latest start date?

I know that assignments should pull only the latest rows automatically, but the end date is set to the same date because of some conversion logic. So I need to set up a filter on the start date.

e.g. I only want the 10/20/2013 line for Pena.

pastedImage_9.png

Thanks for your help.

Regards

Abhishek
This post has been answered by Sherry George on Jun 22 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2017
Added on Jun 22 2017
#business-intelligence-applications
2 comments
4,700 views