---
title: "Create, Modify, or Delete an Attribute Relationship | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: "analysis-services"
ms.topic: conceptual
helpviewer_keywords: 
  - "attributes [Analysis Services], member properties"
  - "member properties [Analysis Services], creating"
ms.assetid: 137b2f40-5dfb-4141-9110-70f961f259cb
author: minewiskan
ms.author: owend
manager: craigg
---
# 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 [!INCLUDE[ssBIDevStudioFull](../../includes/ssbidevstudiofull-md.md)].  
  
### 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](../multidimensional-models-olap-logical-dimension-objects/attribute-relationships.md)