Cube Analysis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 25 Aug 2005 15:38 GMT

I have been searching for a similar Excel Add-in for AS 2005 and am unable to
find one. Does anyone have any suggestions for creating an "easy" Excel-based
client for our datawarehouse connection? We currently pay for a
datawarehousing application and we are trying to replace it with one that is
more user-friendly and Excel is the obvious choice. The Cube Analysis add-in
for AS 2000 would probably be sufficient in this case, but it doesn't work
with 2005 (at least I haven't been able to get it to). So, any help would be
appreciated.

Thank you,
Chris

Reply to this Message

Jéjé - 26 Aug 2005 03:13 GMT

I don't know any Excel client for AS2005.
But its possible to connect Excel to an AS2005 cube, install the driver on
the client computer and setup a connectionstring using this property
provider=msolap.3

also there is web based tools:
try :
http://www.sqlserveranalysisservices.com/cellsetgrid/CellSetGridIntro.htm

or (maybe for AS2005)
http://reportportal.com/

>I have been searching for a similar Excel Add-in for AS 2005 and am unable
>to
[quoted text clipped - 12 lines]
> Thank you,
> Chris

Reply to this Message