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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Access Cube stored in File System and not SSAS db

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 ?
   

- Advertisement -