dbTalk Databases Forums  

Exporting cube browser slices to Excel

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Exporting cube browser slices to Excel in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vicent Palasí
 
Posts: n/a

Default Exporting cube browser slices to Excel - 12-11-2004 , 10:52 PM






Hi.

I want to know if there is a way to export the results (that is, the slices)
shown in the cube browser (when browsing a cube) to Excel.

I know how to connect from Excel to a cube with PivotTable report but I am
not asking this. I don't want to retrieve the whole cube, only the slice
that appears in cube browser. This slice only has one or two dimensions
(each dimension with only one level) so I want to export to a basic Excel
sheet (not to a Pivot table). I DON'Tt want to be able to expand and
collapse levels, manipulate the results in a OLAP way, generate graphics or
Web pages. I am looking for something *simple and quick* and the kind of
Excel sheet a newbie in Excel can understand (the kind that it is learned in
first class of Excel).

(By the way, wouldn't it be great if cube browser had an "Export to Excel"
button?)

Is there a solution to do this? Any help would be greatly appreciated,

Vicent Palasi



Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Exporting cube browser slices to Excel - 12-12-2004 , 08:57 AM






what is this "cube browser" tool?

"Vicent Palasí" <vpalasi (AT) nospamaurumsol (DOT) com> a écrit dans le message de
news: uqDS2ZA4EHA.2196 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Quote:
Hi.

I want to know if there is a way to export the results (that is, the
slices)
shown in the cube browser (when browsing a cube) to Excel.

I know how to connect from Excel to a cube with PivotTable report but I am
not asking this. I don't want to retrieve the whole cube, only the slice
that appears in cube browser. This slice only has one or two dimensions
(each dimension with only one level) so I want to export to a basic Excel
sheet (not to a Pivot table). I DON'Tt want to be able to expand and
collapse levels, manipulate the results in a OLAP way, generate graphics
or
Web pages. I am looking for something *simple and quick* and the kind of
Excel sheet a newbie in Excel can understand (the kind that it is learned
in
first class of Excel).

(By the way, wouldn't it be great if cube browser had an "Export to Excel"
button?)

Is there a solution to do this? Any help would be greatly appreciated,

Vicent Palasi





Reply With Quote
  #3  
Old   
Michael Vardinghus
 
Posts: n/a

Default Re: Exporting cube browser slices to Excel - 12-12-2004 , 03:25 PM



The cube browser is only a server-tool

But you can just connect to as from excel directly and do the same
slice.....

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Quote:
what is this "cube browser" tool?

"Vicent Palasí" <vpalasi (AT) nospamaurumsol (DOT) com> a écrit dans le message de
news: uqDS2ZA4EHA.2196 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Hi.

I want to know if there is a way to export the results (that is, the
slices)
shown in the cube browser (when browsing a cube) to Excel.

I know how to connect from Excel to a cube with PivotTable report but I
am
not asking this. I don't want to retrieve the whole cube, only the slice
that appears in cube browser. This slice only has one or two dimensions
(each dimension with only one level) so I want to export to a basic
Excel
sheet (not to a Pivot table). I DON'Tt want to be able to expand and
collapse levels, manipulate the results in a OLAP way, generate graphics
or
Web pages. I am looking for something *simple and quick* and the kind of
Excel sheet a newbie in Excel can understand (the kind that it is
learned
in
first class of Excel).

(By the way, wouldn't it be great if cube browser had an "Export to
Excel"
button?)

Is there a solution to do this? Any help would be greatly appreciated,

Vicent Palasi







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.