Category Archives: text

Different Tool tip for different column values in OBIEE11g/12c

In OBIEE 11g or 12c, we can add ToolTip to the report on columns. Last week i had a requirement to display different tooltips/text on every column value to users when user hovers on different row in that column of a report.
This is not an OBIEE feature. To get a solution to it, we can try using Javascript in Narrative view. But i tried a different solution.

Req: We have to display different text over different column values. For example below, we have to show Response values in ToolTip, when users hovers over the Product column. Responses can differ.

Step 1: So we created a Dummy KPI in RPD, called Responses and stored the different values (Good/Fair etc ) in it.
Step2: Now in Obiee Report, over the Product column made few changes:
     a) In the ‘Column Properties’ , under ‘Data Format’ tab, I am choosing HTML
     b) In column edit formula wrote below:

‘ || “Dim”.”Product” ||’

i) You can skip using HTML.      
ii) You can write a Case formula in place of Product column, ie column on which you want the hover text.
iii) For Numeric column value, use Cast function to convert it to Char().

Courtesy: Google

Adding Mouse hover text on column Rows/data in OBIEE 11g

Creating a report that contains HTML links or mouse hover is quite easy now. You can even “parameterize” the HTML link to include values from other columns on a row by row basis. For example, if you have a product column, and wish to create a column containing a URL which will redirect the user to a Google search using the Product  value as the keyword, here are the steps to implement it in OBI report :
1.     Create a report, and add any column
2.     Choose the Edit Formula for that column
3.     Enter in HTML using OBIEE syntax, such as this in formula area:
a)   to add hyper link:
‘<a target=”_blank”
href=”’ || Products.Name || ‘&btnG=Google+Search”>’ || ‘’
b) to add mouseover :
4.     The single quotes signify a string
5.     The pipes || (in hyperlink) act a string operator to concatenate HTML with an actual OBIEE column.
6.     NOTE: we’ve added the target =”_blank” tag to open the URL in a new browser window
7.     NOTE: if the column values contain spaces, you may need to enclose the column in a REPLACE function to replace spaces with %20, which represents a space in a URL.
8.    NOTE: In mouseover HTML text,  you can place the mouseover text in quotes and then mention the column name.
9.     Once you are finished editing the formula click OK and then go to the
   Column Properties -> Data Format tab. Override the       Default Data Format and select Treat Text As : HTML