Thursday, February 27, 2014

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:


Posted by at
Labels:

3 comments:

  1. sunita vJune 10, 2014 at 1:07 AM

    Hi
    I want to export entire dashboard to excel in agent. Could you please confirm in which version the same is available.
    I am using 11.1.1.7.0 (Build 130303.2025 ) version

    ReplyDelete
    Replies
    1. Arun KumarJune 10, 2014 at 4:35 AM

      I have only tried in 11.1.1.7.1, you will have to check yourself for 11.1.1.7.0 version (and let me know as well :) )

      Delete
    2. gurramJune 10, 2014 at 7:45 AM

      Option available in 11.1.1.7.0 as well.i have checked.

      Delete

Subscribe to: Post Comments (Atom)