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
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
SELECT dim_col FROM subject_area
where rank(measure_column)<3
Thanks for your information, which made me to join OBIEE online training @www.monstercourses.com
ReplyDelete