How to: Define the Relationship Type of an Attribute Relationship
You create an attribute relationship for an attribute in a hierarchy by using the Dimension Structure tab in Dimension Designer, which can be accessed from Business Intelligence Development Studio.
When you add an attribute relationship to an attribute, your changes are not available to users until you process the dimension. For more information, see Processing in Analysis Services.
To add an attribute relationship to an attribute in grid view or list view
Open the dimension that you want to work with in Business Intelligence Development Studio.
The Dimension Structure tab opens by default.
In Hierarchies and Levels, expand the hierarchy that contains the attribute that you want to work with.
From Attributes, drag the attribute for which you want to define a relationship and drop it on the <new attribute relationship> line under the appropriate level in the hierarchy.
To add an attribute relationship to an attribute in tree view
Open the dimension that you want to work with in Business Intelligence Development Studio.
The Dimension Structure view opens by default.
From Attributes, drag the attribute for which you want to define a relationship and drop it on the <new attribute relationship> line under the appropriate attribute in the tree.
To delete an attribute relationship from an attribute
In Hierarchies and Levels, expand the hierarchy that contains the attribute relationship that you want to delete.
Right-click the attribute relationship, and then click Delete.
See Also
Concepts
Defining and Configuring an Attribute Relationship
Other Resources
Sorting Attribute Members Based on a Secondary Attribute
Specifying Attribute Relationships Between Attributes in a User-Defined Hierarchy
Working with Database Dimension Basics How-to Topics