Create Attribute Relationship and Edit Attribute Relationship Dialog Boxes (Attribute Relationship Designer Tab, Dimension Designer) (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

Use the Create Attribute Relationship dialog box to define new attribute relationships and the Edit Attribute Relationship dialog box to change an attribute relationship. For more information, see Define Attribute Relationships.

To view the Create Attribute Relationship dialog box

  1. In SQL Server Data Tools (SSDT), in Solution Explorer, double-click a dimension to open the Dimension Designer, and then click the Attribute Relationship tab.

  2. On the toolbar, click the New Attribute Relationship icon.

    —or—

    In the attribute relationship diagram or Attributes list, right-click an attribute, and then click New Attribute Relationship.

To view the Edit Attribute Relationship dialog box

  1. In SQL Server Data Tools (SSDT), in Solution Explorer, double-click a dimension to open the Dimension Designer, and then click the Attribute Relationship tab.

  2. In the attribute relationship diagram or Attribute Relationships list, right-click an attribute relationship, and then click Edit Attribute Relationship.

Name
In the Source Attribute group, specifies the name of the attribute from which the relationship originates.

In the Related Attribute group, specifies the name of the attribute to which the relationship is directed.

Member Count
Specifies the estimated number of members of the specified attribute.

Key Columns
Specifies the key columns that are defined for the attribute.

Relationship type
Specifies the type of relationship to create, either Flexible (may change over time) or Rigid (will not change over time).

Attribute Relationships (Dimension Designer) (Analysis Services - Multidimensional Data)

Community Additions

ADD
Show: