Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Change StringStoresCompatibilityLevel on a dimension


Overview

When executing a large dimension you might run into an error stating:

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.

Since there currently is no way to change the StringStoresCompatibilityLevel property in Jet Data Manager directly, you need to do this with a script.

  1. Create a new script action in JDM
  2. Copy the below 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>


  3. Give the scrip a name and hit OK
  4. On the dimension you want to add the script as an inline script


  5. 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.

PLEASE NOTE: This requires SQL Server Analysis Services 2012 or later. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments