Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: Create, Modify, or Delete an Attribute Relationship

You can create, modify, or delete an attribute relationship between attributes in a dimension by using the Attribute Relationships tab of Dimension Designer in Business Intelligence Development Studio. 

To create an Attribute Relationship

  1. In Dimension Designer, open the dimension that contains the attributes that you want to create an attribute relationship between.

  2. On the Attribute Relationships tab, right-click an attribute in the diagram or in the Attributes pane, and then select New Attribute Relationship.

    NoteNote

    To display the Attributes pane, click Show List Views on the toolbar.

  3. In the Create Attribute Relationship dialog box, select a source attribute and a related attribute.

  4. In the Relationship type list, select a relationship type, and then click OK.

To modify an Attribute Relationship

  1. In Dimension Designer, open the dimension that contains the attribute relationship that you want to modify.

  2. Click the Attribute Relationships tab.

  3. Right-click the attribute relationship in the diagram or in the Attribute Relationships pane, and select Edit Attribute Relationship.

    NoteNote

    To display the Attribute Relationships pane, click Show List Views on the toolbar.

  4. In the Edit Attribute Relationship dialog box, select a source attribute and a related attribute.

  5. In the Relationship type list, select a relationship type, and then click OK.

To delete an Attribute Relationship

  1. In Dimension Designer, open the dimension that contains the attribute relationship that you want to delete.

  2. On the Attribute Relationships tab, right-click the attribute relationship in the diagram or in the Attribute Relationships pane, and then select Delete.

  3. In the Delete Objects dialog box, click OK.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.