Edit

Attribute Relationships - Create, Modify, or Delete Relationship

  • Article

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

You can create, modify, or delete an attribute relationship between attributes in a dimension by using the Attribute Relationships tab of Dimension Designer in SQL Server Data Tools.

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.

    Note

    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.

    Note

    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.

See Also

Attribute Relationships