Friday, February 24, 2012

Cube Analysis

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