Exporting a Cube into MS Excel

Hello,

I am wondering if it is possible to import hierarchies established in a SSAS 2005 cube into MS Excel. Right now, when I import a cube into MS Excel (Office 2003) through the following path in Excel: Data/Import External Data/New Database Query/Olap Cubes/"MyCube".cube, I am able to see cube's dimensions and measures but I cannot see my hiearchies. I would like my users to be able to drill down to the lowest level in a given hierarchy, the same way it works in a Cube Browser in BI Studio. Can it be done?

Any thoughts about it would be greatly appreciated.

Thanks a lot!

Hi.

There shouldn't be any problems using SSAS hierarchies in Excel 2003 (I do it quite a lot myself). One problem though is that the hierarchies are not displayed as such in the Pivot Table Field List but are shown as regular dimension values. Try to change the hierarchies' names, e.g. put a '-' in the beginning of the hierarchies' names to make it easier to distinguish them from regular dimensions.

Hope this helps.

Regards

Kjetil

|||

Yep, I found them. You were right, those hiearchies looked like dimension values. Let me ask you one more thing. My cube is pretty big, and I am wondering if there is a way in SSAS 2005 to get a subset of this cube, let say instead of sales for the whole week, I would like to see one day sales. I know that I could use perspectives in a cube browser but I am not sure how it is translating when you import a cube into an Excel file.?

Thank you very much for your help!

|||

Hi again.

I am not sure if I have understood your question correctly but if you want to break down the displayed data into one-day sales, one thing you can do is to to create a hierarchy with date as the lowes level member, e.g. a 'Year-Month-Week-Date' - hierarchy. This way you can select what level to display and make the calculations on and even filter out unwanted data at any level.

Hope this was what you wanted.

Regards

Kjetil

|||

That's exactly what I am going to do.

Thanks a lot Lars!

Exportar OWC to Excel

some times when exporting a cube of a pagina Web with OWC to Excel, after 5
minutes does not finish and if it finishes not they see the data. That I can
do? thank you very much to help me
FIRST OF ALL, LEARN ENGLISH..!!!!!!!!!!!!!!!|||dude
keep your racist stuff to yourself, thanks
"masterOff" <masterOff.1eec6g@.mail.mcse.ms> wrote in message
news:masterOff.1eec6g@.mail.mcse.ms...
> FIRST OF ALL, LEARN ENGLISH..!!!!!!!!!!!!!!!
>
> --
> masterOff
> Posted via http://www.mcse.ms
> View this thread: http://www.mcse.ms/message1109761.html
>
|||there is a timeout setting somewhere.. but if I were you; i would really
talk about more of your cube design on these newsgroups-- i have been doing
cubes for 2 or 3 years; and I've never had anything take a whole 5 minutes
to run
-aaron
aaron_kempf@.hotmail.com
se hable solamente un pequito espanol.. pero tengo ganas de hablar mas en
espanol.
"ing_hgonzalez" <ing_hgonzalez@.discussions.microsoft.com> wrote in message
news:BFE03A36-2941-4A97-9067-3DBDEE78D6ED@.microsoft.com...
> some times when exporting a cube of a pagina Web with OWC to Excel, after
5
> minutes does not finish and if it finishes not they see the data. That I
can
> do? thank you very much to help me
sql