Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 21, 2013 8:59 PM by
Top 5 Dates in OBIEE Prompt
Apr 21, 2013 5:16 PM
Hi all ...
I am using OBIEE 220.127.116.11.5 version.
I need to show Top 5 dates from date dimension in descending order in date dashboard prompt.
I checeked prompts and all the properties availabe there but was unable to get Top 5 dates.
Please suggest ...
Edited by: user4175654 on Apr 21, 2013 3:15 PM
This content has been marked as final.
Show 1 reply
Re: Top 5 Dates in OBIEE Prompt
Apr 21, 2013 8:59 PM
in response to
Try to use the query something like below
SELECT Time.Date saw_0 FROM "SA" WHERE TOPN(Time.Date, 5)<=5 ORDER BY saw_0
This would return the top 5 records based on your max date in your database, so to see best results as expected try to use Year filter.
Rest is yours :)
Mark as correct/helpful