Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

Create/Edit Relationship Dialog Box (Analysis Services - Multidimensional Data)

Use the Create/Edit Relationship dialog box in SQL Server Data Tools (SSDT) to define or modify a relationship in a data source view. You can display the Create/Edit Relationship dialog box by:

  • Clicking New Relationship in the Toolbar pane of Data Source View Designer.

  • Right-clicking a table in either the Tables or Diagram pane of Data Source View Designer and selecting New Relationship.

  • Right-clicking a relationship in the Diagram pane of Data Source View Designer and selecting Edit Relationship.

Note Note

You can create relationships in Data Source View Designer that do not exist in the underlying data source, and remove relationships created by Data Source View Designer from existing foreign key relationships in the underlying data source.

Source (foreign key) table

Select the table or named query that contains the reference to one or more columns in the destination table.

Destination (primary key) table

Select the table that contains one or more columns referenced by the source table. For self-joins, select the same table selected in Source (foreign key) table.

Source columns

Select the columns that reference columns in the destination table.

Destination columns

Select the columns that are referenced by columns in the source table.

Reverse

Click to reverse the direction of the relationship.

Description

Type an optional description for the relationship.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.