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().