Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2010-08-02 : 10:21:08
|
Hi,We have a very large cube, size of cube is roughly 4GB. This cube only holds static and histortical data. It would not be updated anymore going foward.Question 1) Can we store this cube in a file system instead and users would still be able to access the cube via Excel Services ?2) Is there any other way to be able to access this cube even when it is not stored on the SSAS database.We want to remove this cube from the SSAS database due to the amount of space that can be saved and used for other processing cubes.Is there any other method to be used to handle this situation ? |
|
|
|
|