Create/Edit Relationship Dialog Box (Analysis Services - Multidimensional Data)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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.
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.