1 Reply Latest reply: Apr 21, 2013 8:59 PM by Srini VEERAVALLI RSS

    Top 5 Dates in OBIEE Prompt

      Hi all ...

      I am using OBIEE 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
        • 1. Re: Top 5 Dates in OBIEE Prompt
          Srini VEERAVALLI
          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