Overview
When executing a large dimension, the following error message is displayed:
File system error: A string store or binary store with a compatibility level of '1050' is at 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.
Resolution Process
Since there currently is no way to change the StringStoresCompatibilityLevel property in Jet Data Manager directly, you would need to do this with a script.
-
Create a new script action in JDM
-
Copy the following text into the script window
<Script xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300">
<AddNameSpace Alias="my" AddNameSpace="http://schemas.microsoft.com/analysisservices/2003/engine"/>
<InsertEnd Node="//my:Dimension" SearchType="Path" Operator="All">
<ddl300:StringStoresCompatibilityLevel>1100</ddl300:StringStoresCompatibilityLevel>
</InsertEnd>
</Script>
-
Give the script a name, then click OK
-
On the dimension to which you want to add the script, right-click and select Edit Dimension
-
Modify the setting for Inline Script to Change Storage Settings
-
Deploy and execute the dimension
Once deployed, the compatibility level has been changed, and the dimension can now handle 4 billion unique string combinations instead of the default 4Gb of data in total.
Comments