allow StringStoresCompatibilityLevel to apply to mining structures - by GregGalloway

Status : 


Sign in
to vote
ID 721171 Comments
Status Active Workarounds
Type Suggestion Repros 1
Opened 1/27/2012 8:56:26 AM
Access Restriction Public


As described here:

AS2012 allows you to set the StringStoresCompatibilityLevel=110 property on dimensions or (distinct count) partitions.

AS2012 does not allow you to set this property on mining structures, and some customers who are building very large mining structures are running into this 4GB string store limit. Please add that property to mining structures.

As an alternative, add a database level property which sets the default string store compatibility level for the whole database, but can be overridden per object as desired.
Sign in to post a comment.
Posted by Microsoft on 1/27/2012 at 10:06 AM
Hi Greg,

Thanks for logging this issue, we'll consider it for a future release of Analysis Services based on the amount of feedback received.


Ashvini Sharma
Program Manager
Analysis Services