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

User618255-OC

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.

Thanks for your help.

Regards

Abhishek

Sherry George

In OBIEE analysis you can do this by adding a  new column with a formula like below, which ranks date by login id and then you can filter the rank column =1.

RANK("Time"."Date" by "Employee"."LoginId")

User618255-OC

Thank you Sherry, that is what I did

-abhishek