MS SQL Data Warehousing - Cube Analysis

Author

Cube Analysis

Chris

2005-08-25, 11:23 am

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

Jéjé

2005-08-26, 3:23 am

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. sqlserveranalysisser

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

"Chris" <cprime@medmarc.com.(dontspamme)> wrote in message
news:71896A96-B649-472C-B2CB- 9F5C41CE7889@microso
ft.com...
>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

Sponsored Links