Home Dashboard Directory Help
Search

allow StringStoresCompatibilityLevel to apply to mining structures by GregGalloway


Status: 

Active


3
0
Sign in
to vote
Type: Suggestion
ID: 721171
Opened: 1/27/2012 8:56:26 AM
Access Restriction: Public
0
Workaround(s)
view

Description

As described here:
http://technet.microsoft.com/en-us/library/gg471589(SQL.110).aspx

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

Regards
Ash

Ashvini Sharma
Program Manager
Analysis Services
Sign in to post a workaround.