To Add an Attribute Relationship
1 Attribute relationships are defined automatically when a User Defined hierarchy is inherited from an underlying relational dimension.
2 To add an Attribute Relationship, right-click on an OLAP Dimension in the left pane and select "Add Attribute Relationship". Fill out the dialog box with the relevant details.