Avoid non-materialized reference dimensions

This rule analyzes reference dimensions to see whether the dimensions are materialized.

Best Practices Recommendations

For best performance, you typically materialize reference dimensions. However, a reference dimension relationship between a local dimension and a linked measure group cannot be materialized.

For More Information

For more information about materializing reference dimensions, see Defining a Referenced Relationship and Referenced Relationship Properties in SQL Server Books Online.

For more information about performance issues related to reference dimensions, see the section "Reference relationships" in the SQL Server 2005 Analysis Services Performance Guide.