ToolTip in OBIEE Reports
When we hover on any report, we can show a tool tip to the user. Not only the same column text, we can show other column values as a hovering text.
In 'Column Properties' we use 'Custom' or 'HTML' data format to achieve this,and, in 'Edit Formula' you can write HTML codes.
How to do it :
To demonstrate this, I am choosing 2 columns, LOB & Product. When I roll over my mouse on 'Product' I want to get 'Brand' as my tool tip.
Step 1: In the 'Edit Formula', I am introducing HTML codes.
Step 2: In the 'Column Properties' , under 'Data Format' tab, I am choosing HTML
Note:
1) I have used <HTML><B><SPAN> instead we can use <SPAN>, no need to mention <HTML> tags, just for this demo I have used <HTML> tags in column properties
.
2) For Numeric columns, use Cast functions to convert the Numeric data to Char, like , cast ( year as char(4) )
3) Under Column Properties, Data Format Tab: We can either select 'CUSTOM' or 'HTML'
