Avoid having 10 or more dimensions with a single attribute. Consider unifying them.

This rule analyzes database dimensions to determine whether there are dimensions that contain a single attribute and, if so, whether there are 10 or more of these dimensions.

For best performance, you should typically consolidate dimensions that contain a single attribute. Consolidating attributes into one dimension enables attributes to be organized into groups of related attributes and hierarchies to be created. Organizing attributes into dimensions will also improve the usability of the cubes that use these dimensions.

For more information about defining dimensions and attributes, see Configuring a Database Dimension Using Dimension Designer and Defining and Configuring Dimension Attributes in SQL Server Books Online.

Community Additions