OLAP cube locations

Last Post 23 Sep 2004 06:09 AM by Shill_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Shill_SQL
New Member
New Member

--
23 Sep 2004 06: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
You are not authorized to post a reply.

Acceptable Use Policy