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