Connecting to OLAP with Excel??

[Guest_imported]

When using Excel to connect a user to the OLAP server i keep getting the following message.


"Unable to open connection.
Cannot Connect to server 'OLAP Server Name'.
OLAP server error: The operation failed due to network problems."

When I use excel locally on my machine it works just fine. Any ideas?

 

[Guest_imported]

Before using OLAP Cube, You need to set role for the remote user.
Steps to create role:
Right click you cube and select manage role from the menu in your OLAP manager.
Select the network user name and give him full permissions.
If this solution not works then enter remote user name as OLAP administor in User manager.
If you have any doubts then reply me at:bhamireddy@yahoo.com