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:

8 comments:

  1. Maciej KozakiewiczFriday, February 28, 2014

    This is usefull. Still, you cannot send entire dashboard with agent. It's limited to single page.
    Do you know any way to send entire dashboard using agent and have it split to seperate excel tabs (one excel tab for respective dashboard tab)?

    ReplyDelete
    Replies
    1. testSaturday, March 01, 2014

      Yes you can do this in agents as well (at least in the version 11.1.1.7.1). Under 'Delivery Content' tab when creating agent, select the option 'Entire Dashboard', and select any dashboard tab when selecting the dashboard. This will deliver entire dashboard in email. I will add an image on this post to show this.

      Delete
    2. Christian BergWednesday, March 05, 2014

      Nope, 11.1.1.7.1 doesn't contain that. Only higher bundle patch levels will. 11.1.1.7.140114 and 11.1.1.7.140225 for sure....haven't gotten a 131017 running right now.

      Delete
    3. testFriday, March 07, 2014

      Not true. The version we have is older than this patch. See update in post above.

      Delete
  2. UnknownTuesday, June 10, 2014

    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. testTuesday, June 10, 2014

      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. gurramTuesday, June 10, 2014

      Option available in 11.1.1.7.0 as well.i have checked.

      Delete
    3. UnknownWednesday, June 11, 2014

      Hi Arun..the option is not available in 7.0. I have checked in 11.1.1.7.1 (Build 130605.1300 64-bit) l but i don't see the option.Can you please help me with the exact version or patch I can upgrade to from 11.1.1.7.0 so that option is available.

      Delete

Subscribe to: Post Comments (Atom)