Hi
A few days ago we hit the following error
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. Physical file: \\?\E:\MSSQL\Data\OLAP\Data\MySSAS.0.db\MyDim.0.dim\39637.Dimension Name.asstore.
I have a SSAS Multidimensional database that was created on an old SSDT for SSAS 2015. We are currently on SSAS 2019 and a requirement has come up to change the CurrentStringStoreCompatabilityLevel to 1100. All dimension objects are on 1050 currently and I am unable to change it as this is a read-only property on SSDT.
SSAS server properties says that supported Default Compatibility Level is 1100

The CurrentStringStoreCompatabilityLevel for any new dimension I create(on SSDT) still gets set to 1050. I have tried creating a new database also with a new DSV and new dimension. It still does NOT reflect the required 1100 compatibility level.
Since on SSDT, CurrentStringStoreCompatabilityLevel is a read-only property, I tried cheating it by updating the XMLA of dimension to 1100. But when I deploy it still gets set as 1050.
Any help is appreciated.
Thanks