This property specifies the highest level of a dimension to be materialized. Levels higher than the specified level will be aggregated at run time.
Dimensions not specified in this property will be materialized based on default settings.
This property reduces the time to build a cube and decreases the cube size.
All levels of all dimensions are pre-aggregated.
Specified Dimension:Level is the highest level materialized. Dimension:Level value is defined within the properties dialog.
Cube: If the property is set on a cube, then the value will override the connection level value for that cube’s build job.
Comes into effect:
This property requires a full cube build to take effect.
Incremental builds will fail until the full build completes.
Set this property when shorter build times and/or smaller cubes are a higher priority than query performance.