I have a report which shows user Number values, which are measured values, I have formated the column to show two decimals with 1000 separator.
So my number looks like 18596.68
But I would like to achieve, when user bring the mouse over the measue can see the whole value likr 18596.682563.
How we can achieve that in OBIEE 11g. Thanks
In the case you have data coming in as 18596.682563 from DB, you can use the below code to achieve your result
single quote <p title = "'||<field name>||'"> single quote ||round(<field name>,2)|| singe quote</p> single quote
I had implemented this using narrative view in a report, I have listed out the detailed steps along with the code over here -
Feel free to comment in case of any concerns.
Yes. And googling for 3sec just showed me that this has actually already been blogged about: http://obiee2go.wordpress.com/2012/07/04/obiee-11g6-adding-tooltips-and-conditional-coloring-to-currency-data/