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.