Data Analysis View Error

[Nach]

Hi, I just successfully build an OLAP cube on PS 2007. Now when i try to
create a data analysis view..I get this error. I'm not able to see the list
drop down where it shows the analysis server database name...when I click to
refresh it...it gives me this error : "Failed to connect to the Analysis
Services Server. Verify the server name and try again" . But when i put our
old PS 2003 server name i am able to see it's cubes. What could be the
problem ..?

Thanks
Nach

 

[Paul Conroy]

Have you installed the following on your workstation, that you're tryint to
create the view from.

MSXML6.0
ASOLEDB9.0
SQL Native Client

--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[Nach]

Yes I have all of that installed on my computer. I do not know why I'm
gettign this error...lookslike few others are getting it too...but dunno how
it got resolved.

 

[Nach]

Finally I'm able to create views! It was a fluke luck...I thought OLE DB 9.0
provider should be installed only in the server which hosts PWA which sounds
logical...but I just tried installing it in my local computer as well....and
it worked! It's kinda weird...we have to make all the admins to install this
in order to create views! But atleast it works! Thanks!