Friday, February 24, 2012

Cube Analysis

I have been searching for a similar Excel Add-in for AS 2005 and am unable t
o
find one. Does anyone have any suggestions for creating an "easy" Excel-base
d
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,
ChrisI 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.sqlserveranalysisservice...etGridIntro.htm
or (maybe for AS2005)
http://reportportal.com/
"Chris" <cprime@.medmarc.com.(dontspamme)> wrote in message
news:71896A96-B649-472C-B2CB-9F5C41CE7889@.microsoft.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

No comments:

Post a Comment