What do i enter in the server textbox to access olap?

B

blogsprite

AI am using pivoting in excel and i am trying to access OLAP as an external
data source. I tried entering the server name in the server textbox for the
Analysis Server option, but it's giving me an "Unable to Open Connection.
Unspecified error" message.

Please help. Thanks!
 
Top