Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
11
Views
2
Comments
User618255-OC
User618255-OC Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

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

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    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
    User618255-OC Rank 3 - Community Apprentice

    Thank you Sherry, that is what I did

    -abhishek