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 comment:

  1. Thanks for your information, which made me to join OBIEE online training @www.monstercourses.com

    ReplyDelete

Thanks to Comment
--Add--