Set SSAS Default Directories

Error Resolution

File system error: A string store or binary store with a compatibility level of '1050' is at the maximum file size of 4 gigabytes.

If you are getting abovementioned error, that means that the data file is not fitting in the Directory. You can anytime set the Directory for a Dimension or a fact to a custom directory but it is a good practice that you set the default data directory values to other than C:.

In order to set the default data directory in SSAS:

1. Connect to SSAS from SSMS
2. Right Click on the server, Click Properties
3. In the dialog box navigate to DataDir
4. Set the desired value.
5. Navigate to LogDir
6. Set the desired value.
7. Navigate to BackupDir
8. Set the desired value.
9. Click Ok
10. Redeploy the SSAS database.
11. Done