SSAS 2008 R2 allows users to change the Storage Location for a cube partitions in BIDS. However, when doing so on an already processed partition, SSAS will unprocess the partition. For large scale data sets, this is not a viable option.
We need the ability to move a partition to a different storage location without unprocessing the data. In order to accomplish this goal today, we have to use the following hack:
1. Stop the SSAS Service
2. Copy the *.prt partition directory and its contents from the source default location to the new target volume directory
3. Make a backup copy of the *.prt.xml file for the affected partition in the source default partition parent directory
4. Change the <StorageLocation> option in the *.prt.xml in the source default partition parent directory to the new target volume parent directory
5. Restart the SSAS Service so that SSAS will create a new GUID style subdirectory under the new target volume’s parent directory
6. Expand the Partitions so that SSAS will create a new GUID style subdirectory under the new target volume’s parent directory
7. Stop the SSAS Service
8. Move the files from the new partition volume parent directory into the new target volume’s GUID subdirectory
9. (Optionally) Delete all files EXCEPT the info*.xml file from the source default partition location (and leave the directory intact)
10. Copy the info*.xml file back to the source partition directory
11. Start the SSAS Service
Obviously, this is not a good long term solution.