Skip to content

attribute-relationships-create-modify-or-delete-relationship.md

Latest commit

 

History

History
59 lines (39 loc) · 2.58 KB

attribute-relationships-create-modify-or-delete-relationship.md

File metadata and controls

59 lines (39 loc) · 2.58 KB
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 [!INCLUDEssBIDevStudioFull].

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