Chris Miller
asked on
Business Objects Query
I am using BI4 and need some help with a business objects query. the query works fine except for returning all dates. The query has an effective date field and I dont want every date for each person just the latest date.
ASKER
ASKER
Also, what do I need to replace to get it to work.
select * from
(select t.*,row_number() over(partition by person order by effective_date desc) rn
from your_table t)
where rn = 1
select * from
(select t.*,row_number() over(partition by person order by effective_date desc) rn
from your_table t)
where rn = 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
or, if you don't have the option of putting that in the database, you could create a derived table within the universe much the same way and then use the derived table instead of the original source table
ASKER
ok, I will try that. Thanks.
(select t.*,row_number() over(partition by person order by effective_date desc) rn
from your_table t)
where rn = 1