Looks like I wasted a big time in displaying the city names (horizontally) in a single cell separated by space in my earlier post. The following way is bit easier.
Take a column city in your workbook and open the narrative view.
Select HTML - Use this code for ex: <a> @1 </a>
Note : In the Rows to display option I have selected 100 - But in order to show all the city names, you have to increase the parameter value until you see all the names in the output below.
Let us rename the narrative view ( new feature in OBIEE 11.1.1.6) and change the font color.
Remove extra views from the answer. Look at the result.
Thanks.
Take a column city in your workbook and open the narrative view.
Select HTML - Use this code for ex: <a> @1 </a>
Note : In the Rows to display option I have selected 100 - But in order to show all the city names, you have to increase the parameter value until you see all the names in the output below.
Let us rename the narrative view ( new feature in OBIEE 11.1.1.6) and change the font color.
Remove extra views from the answer. Look at the result.
Thanks.