SSAS Troubleshooting: A string store of binary store with a compatibility level of '1050' is at the maximum file size of 4 gigabytes

Analysis Services returns an error if the physical storage of string data exceeds 4 gigabytes. This error can occur while browsing a cube or during processing. The full text of the error message is:

"File system error: A string store or binary store with a compatibility level of '1050' is the maximum file size of 4 gigabytes. To store additional strings, you can change the StringStoresCompatibilityLevel property of the associated dimension or distinct count measure to '1100' and reprocess. This option is only available on databases with a compatibility level of '1100' or higher."

The best way to resolve this error is to increase string storage capacity. This is a multi-step process that starts with having the database at certain compatibility level (1100 or higher), setting the StringStoresCompatibilityLevel property on the object, and concludes with reprocessing the object.

You can set the property on individual objects (dimensions or partitions).

This setting is available in SQL Server 2012 and later.  See Configure String Storage for Dimensions and Partitions for more information.