Any idea when Excel is going to support connecting to 2005 cubes?

next release... Excel 12
you can access the cubes using excel 2003, but the display of the dimensions
is not optimal.

"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

Excel can connect now, using OLE DB for OLAP 9:

http://groups.google.com/group/micro...olap/msg/64c44
d794b59963b
From: Deepak Puri
Date: Wed, 05 Oct 2005 08:31:54 -0700

Subject: Re: 2005 Analysis Services and End User Access

Users can certainly connect to AS 2005 cubes via Excel; but only the
next version (Office 12, Beta likely late this year) will specifically
support new AS 2005 features like KPI's. Some of the 3rd-party OLAP
client tools will support AS 2005-specific features sooner. Mosha's
MSOLAP info pages provide a list of Analysis Services client software:

http://www.mosha.com/msolap/util.htm#Clients
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Jeje ,
what you mean <but the display of the dimensions is not optimal.>.

Thanks.

Ramunas Balukonis


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

It means that Excel 2003 displays all the hierarchies in the cube in the
flat list, not grouped by dimensions and not grouped within dimension by
display folders.
People who use Excel 2003 and below to connect to AS2005 cubes sometimes
find it easier to introduce naming convention in hierarchy names to include
dimension name as well - to get the hierarchies grouped together by name.
Otherwise - Excel 2003 works just fine with AS2005 cubes - I use it every
day and did so for the last few years

--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==============================*=================== =
"Ramunas Balukonis" <ramblk2 (AT) hotmail (DOT) com> wrote