Monday, 9 April 2012

Displaying Top 2 Values in the Dashboard Prompt

In the OTN forum, a good question was raised for displaying top 2 column values in the prompt according to any measure values.

So, I started by writing a SQL in the Prompts as shown below.
First you need to create a prompt with the dimension column which you need to show for the top 2 values
Secondly, you need to write a SQL in the SQL results

SELECT dim_col FROM subject_area
where rank(measure_column)<3

Thirdly, see the results


  1. Thanks for your information, which made me to join OBIEE online training

  2. wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again, Regards,obiee online training


Thanks to Comment