OBIEE Dashboard Export to Excel PDF HTML using Custom Links

people celebrating at the office

Oracle Business Intelligence Application in it's out of the box form do not provide any solution to export a dashboard from another dashboard using custom links. But given the available resources, it is possible to create custom links to export a dashboard in Excel format, PDF format, or HTML format. To do this we need to create few snippets of HTML and Javascript coding, and can add some cool animations as well if need be.

OBIEE Dashboard Export to Excel PDF HTML using Custom Links
OBIEE Dashboard Export to Excel PDF HTML using Custom Links

To achieve our goal, we first need to have the name of the dashboard and the tab which we will be using to create our extracts. Once that is ready, the below HTML and Javascript codes will help create few export links that will extract exactly what we want.

<blockquote class="tr_bq">
<div id="exports_hdr">
<span style="color: mediumblue; font-size: small;">
<u>
<b>
Export
</b>
</u>
</span>
</div>

<div id="exports_dtls" style="display: none;"><img style="vertical-align: middle; margin: 0 0 0 5px;" src="res/sk_blafp/catalog/exporttoexcel_ena.png" alt="">&lt;a name="ReportLinkMenu" title="Export to different format" href="javascript:void(null)" onclick="return saw.dashboard.exportToExcel('&lt;&gt;', '&lt;&gt;', true);"&gt;<span style="color: mediumblue; font-size: small;">
<b>Excel 2007+</b></span><br><img style="vertical-align: middle; margin: 0 0 0 5px;" src="res/sk_blafp/catalog/printtopdf_ena.png" alt="">&lt;a name="ReportLinkMenu" title="Export to different format" href="javascript:void(null)" onclick="return PortalPrint('&lt;&gt;', '&lt;&gt;', true, 'pdf');"&gt;<span style="color: mediumblue; font-size: small;">
<b>PDF</b></span><br><img style="vertical-align: middle; margin: 0 0 0 5px;" src="res/sk_blafp/catalog/printtohtml_ena.png" alt="">&lt;a name="ReportLinkMenu" title="Export to different format" href="javascript:void(null)" onclick="return PortalPrint('&lt;&gt;', '&lt;&gt;', true, 'html');"&gt;<span style="color: mediumblue; font-size: small;">
<b>HTML</b></span></div></blockquote>

Once this is working fine, it will show a cool 'Export' link, and when we do a mouse hover it will instantly show three Export links for Excel format, PDF format, and HTML format.

Let me know if you have any other ideas to export in different formats!

Author: Rahul Bhattacharya

Rahul is a journalist with expertise in researching a variety of topics and writing engaging contents. He is also a data analyst and an expert in visualizing business scenarios using data science. Rahul is skilled in a number of programming languages and data analysis tools. When he is not busy writing, Rahul can be found somewhere in the Appalachian trails or in an ethnic restaurant in Chicago.

2 thoughts on “OBIEE Dashboard Export to Excel PDF HTML using Custom Links

  1. Hi Rahul, Thanks for a very useful post.I could get it to working for pdf and html but Excel doesn't work. It gives me an error for Excel. Any thoughts or pointers on this? Thank you.

Leave a Reply