Popup/tooltip Functionality in Obiee11g

The Popup/tooltip functionality is same as Mouse-Over functionality which is very useful in case anyone want to avoid drill down feature.

Here are the steps to implement in BI.

1.       Create the new report you want to use as a Popup report and make the column is prompted on which you want to implement this feature.

2.       In the main report, add following script in Static Text view.

<script type="text/javascript" src="/jquery.min.js"></script>

<script type="text/javascript" src="/tipped-3.2.0.1/js/tipped/tipped.js"></script>

<script type="text/javascript" src="/tipped-3.2.0.1/js/excanvas/excanvas.js"></script>

<link rel="stylesheet" type="text/css" href="/tipped-3.2.0.1/css/tipped/tipped.css"/>

3.       Add the Static text view in compound layout which you will be exposing in the dashboard.

4.       Update the formula for the column on which you want to implement popup feature.

'<div id="popup' ||"Opportunity"."Opportunity ID"|| '">

' ||"Opportunity"."Opportunity ID"||

' </div>'

||'<script type="text/javascript">

$(document).ready(function()

{Tipped.create("#popup' ||"Opportunity"."Opportunity ID"||'",

"saw.dll?Go&path=%2Fshared%2FSI Fusion%2FSI Pipeline and Forecast%2FMy Top Deals%2FTop Deals (tipped details)&Action=extract&p0=1&p1=eq&p2=%22Opportunity%22.%22Opportunity%20ID%22&p3='||"Opportunity"."Opportunity ID"||'",

{ajax: true,

skin:"white", 

hook: "bottomright", 

border: { size:1}, 

afterUpdate: function()

{}

} );

});

</script>'

Because the column formula does not include the whole script (it references to the scripts loaded in the Narrative View) we will get a “Formula syntax is invalid” error:

We can ignore it, as it will work correctly with the whole script at the report execution.

5.      We need to override Default Data Format in order to treat text as HTML:

6.       Here is the final output.

For reviewing this feature, you can refer to SI Pipeline and Forecast dashboard - > My Top Deals (Testing) tab in SI DEV.