How to export entire OBIEE dashboard to excel (all tabs) in one shot?

Its a common request, you have an OBIEE dashboard, with multiple tabs on it. How do you export the entire dashboard to excel in one go?

I just found out that in the version OBIEE 11.1.1.7.1, you can do exactly that. Look at the dashboard below with seven tabs. Navigate on top right to page options > Export to Excel > Export Entire Dashboard:

So cool, it saves entire dashboard into an excel file, with one excel tab for each dashboard tab:

There is one caveat to this functionality, i.e. you will have to make sure all dashboard have been defaulted to the right prompt which you want to download. Other than that, its great addition to OBIEE. 

Update: This option is available through Agents as well in 11.1.1.7.1 version: 

 

 

 



Here is the exact version number of OBIEE for reference:

Hiding Export to Excel or CSV function in OBIEE 11g dashboards

OBIEE 11g has multiple export options including PDF, Excel, Powerpoint, Web Archive, CSV, Tab delimited, XML etc. There could be a need where business do not want users to download the report and edit the data before sharing it. This can be prevented by disabling excel / CSV etc options.

 

 

 

The way to do this is uncheck 'Export' Option in the dashboard properties, and leaving the 'Print option' checked. This will give following two options and excel of CSV will be disabled.