OLAP cube locations

Last Post 23 Sep 2004 07:09 AM by Shill_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

23 Sep 2004 07:09 AM
Is it possible to have the Analysis Service on one server and the data files for the cubes on another?

What I intend to do is move the data files for our two cubes onto another server where there is plenty of space for the cubes to process. I would be changing the location of the data folder within Analysis Services, something I have done before but this was changing drive locations on the same server not moving to another server.

My thought is as long as the path is valid and a connection can be made this won't cause any problems? The only other alternative I have is to reduce the amount of data used by the cubes but this is a last resort.

Would appreciate any views or previous experience

Acceptable Use Policy