How to set a mouse hover tool tip in results of an OBIEE 11g Analysis or Dashboard.

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.5.0 [1308] [Release 11g]
Business Intelligence Answers Option - Version 11.1.1.5.0 [1308] to 11.1.1.5.0 [1308] [Release 11g]
Business Intelligence Reporting and Publishing Option - Version 11.1.1.5.0 [1308] to 11.1.1.5.0 [1308] [Release 11g]
Information in this document applies to any platform.

Goal

How to set a tool tip in results of an OBIEE 11g Analysis or Dashboard.

Solution

To get a tool tip for the column data of an analytics or Dashboard, follow the steps below :

For text variables follow the steps below:

a) On the Criteria, Right-click on the required text column and select Column Properties

b) Once you see window for "Column Properties" click on tab "Data Format".

c) Check mark "Override Default Data Format" and set:

Treat text As      = Custom Text Format
Custom Text Format = [html]<p title=\""Type your tool tip here" \">@

(Where @ is the text sign)

For Numeric values follow the steps below:

a) On the Criteria, Right-click on the required text column and select Column Properties

b) Once you see window for "Column Properties" click on tab "Data Format".

c) Check mark "Override Default Data Format" and set

Treat Numbers As      = Custom
Custom Numeric Format = [html]<p title=\""Type your tool tip here" \">#

( Where # is the number sign )

Note:
* Use <a or <H instead of <p if you do not want to disturb existing column height and width.

Example :

Treat text As      = Custom Text Format
Custom Text Format = [html]<H title=\""Type your tool tip here" \">@

(Where @ is the text sign)