Miscellaneous Analysis Services Topics - SQL Server Analysis Services 2012 Cube Development - page 425

Dimension property name Explanation

using the DISTINCT keyword. Refer to
Chapter 5 , Optimizing Dimension and
Cube Processing , for more information.

The default value is regular . The other
option is lazy aggregations, which allows
building indexes using the background
thread, thereby shortening dimension-
processing time. Refer to Chapter 5 , Op-
timizing Dimension and Cube Processing ,
for more information.

ProcessingMode

StringStoresCompatibilityLevel In Analysis Services versions prior to
2012, dimension string store files were
limited to 4 GB. If your MOLAP dimension
string store file exceeded the 4 GB limit,
processing would immediately fail and re-
port an error similar to: "File system error:
A FileStore error from WriteFile Occurred.
Physical file: \\?\N:\Analysis Ser-
vices\Data\database
name\...\2.string.data . Logical
File:.. Errors in the OLAP Storage Engine:
An error occurred while processing an
XYZ object". One of the most anticipated
fixes in 2012 is the StringStoresCom-
patibilityLevel option, which re-
moves the 4 GB limit if it is set to 1100. If
you restore a database from a backup file
collected using a previous Analysis Ser-