none
Export data in cube browser to excel

    Question

  • Hi All

    Is there a way to export data directly from the browser of a cube into excel
    formats ?
    ( Just like we have a export option in reporting services.)

    Thanks in advance

    Shubhangi

    Monday, July 31, 2006 9:55 AM

Answers

  • If you are talking about the cube browser in SQL Server Management Studio or BI Studio then you can export to Excel from the pivot table the browser uses.

    1. Put something onto the pivot table.
    2. Invoke the context menu (right mouse button click) of the pivot table and invoke Commands and Options menu.
    3. Go to Behavior tab of the property sheet, which will appear.
    4. Check the "Toolbar" checkbox.

    There will be a toolbar shown for the pivot table, which contains export to Excel button.


    Wednesday, August 02, 2006 6:26 AM

All replies

  • Hello Shubhangi.

    What browsers are you thinking about?

    I think that most of the main third supplier tools support export to Excel in an advanced(with links) or more primitive way(text based export).

    Excel 2007(the next release) will support all AS2005 features that I can think about.

    Kind regards

    /Thomas Ivarsson

     

    Tuesday, August 01, 2006 8:15 PM
    Moderator
  • If you are talking about the cube browser in SQL Server Management Studio or BI Studio then you can export to Excel from the pivot table the browser uses.

    1. Put something onto the pivot table.
    2. Invoke the context menu (right mouse button click) of the pivot table and invoke Commands and Options menu.
    3. Go to Behavior tab of the property sheet, which will appear.
    4. Check the "Toolbar" checkbox.

    There will be a toolbar shown for the pivot table, which contains export to Excel button.


    Wednesday, August 02, 2006 6:26 AM
  •  

    When a cube is viewed in Excel 2007 (that is, the cube as viewed in Browse option in Visual Studio 2005) -- are the hierarchies supposed to show up as nicely as they do in Visual Studio?  That is, do the hierarchies show up in a different line / column etc, instead of "bunching up".

     

    In Excel 2003, the hierarchies dont come up nicely whenever I tried, and I am not having very much luck with Excel 2007.  Am I missing something?

     

    Anything to do with service packs, or the right version of the Cube analysis Add-In for Excel?

     

    Thanks.

    Friday, November 30, 2007 9:13 PM