August 2, 2010 at 8:20 am
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 ?
August 2, 2010 at 4:17 pm
1) Can we store this cube in a file system instead and users would still be able to access the cube via Excel Services ?
Technically, the cube is currently stored in the file system anyway :ermm: But I get what you're asking, and no, there's not really a way to do this. Assuming it's fully MOLAP right now, you *could* change the storage for the partitions to ROLAP and thereby leave the source data in the source DB. Performance will likely suffer doing this though.
Honestly, 4Gb isn't that much on a drive, and if you're that desperate for drive space your drives probably aren't sized correctly now. Staying with the storage question, you could (depending on which release you're on) split the partitions to different drives and maybe even different servers, but again, for 4gb, this seems like a lot of overhead.
HTH,
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply