Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Slow response when not in server role

Status
Not open for further replies.

trier

Technical User
Oct 3, 2001
6
I have a user that accesses a cube via excel 2007. If they connect to the cube and start loading dimension data everything works ok until they get to about 6 dimensions at which point the response back from analysis services cube becomes very slow (minutes). However if I add that user to the Analysis services server role then the response time back is greatly improved (seconds). The cube role the user is in has access to all dimensions. Does the user have to be in the server role or is there something else that needs to be set up.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top