Defining and Configuring an Attribute Relationship
You can create an attribute relationship between any two attributes in a dimension. With the Attributes pane of Dimension Designer set to tree view, drag the attribute that you want to relate to another attribute onto the <new attribute relationship> field under the attribute.
Note
For more information about the importance and implications of defining and configuring attribute relationships, see the "SQL Server 2005 Analysis Services Blog by Richard Tkachuk" in the Additional Resources section on the SQL Server 2005 – Analysis Servi c es page on the Microsoft TechNet Web site, and see the section “Enhancing Query Performance” in the SQL Server 2005 Analysis Services Performance Guide.