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.
