Adding or Removing Tables or Views in a Data Source View (Analysis Services)

After you have created a data source view (DSV) in SQL Server Data Tools (SSDT), you can modify it in Data Source View Designer by adding or removing tables and columns, including tables and columns from another data source.

To open the DSV in Data Source View Designer, you double-click the DSV in Solution Explorer. Once you open the DSV, you can use the Add/Remove Tables command on the button bar or menu to modify or extend the DSV. You can also work with the objects in the diagram. For example, you can select an object and then use the Delete key on your keyboard to remove an object.

Warning

Use caution when removing a table. Removing a table deletes all the associated columns and relationships from the DSV and invalidates all objects bound to that table.

Selecting Tables or Views to Add or Remove

Using the Add/Remove Tables dialog box, you can move tables or views between the Available objects and Included objects lists. The Available objects list initially includes any tables or views in the primary data source that are not already in the data source view. If the primary data source supports the OPENROWSET function, you can also add tables or views from other data sources in the project or database.

Adding or removing a table to the DSV also adds or removes the table to the currently selected diagram in the DSV. For more information on diagrams, see Work with Diagrams in Data Source View Designer (Analysis Services).

After you move a table to the Included objects list in the Add/Remove Tables dialog box, you can add all related tables. This operation adds tables according to foreign key constraints in the data source, if such constraints exist. If foreign key constraints do not exist, you can use the NameMatchingCriteria property of the data source view to determine relationships by specifying a criterion for matching column names in tables to generate likely relationships. If the NameMatchingCriteriaproperty is specified for the data source view, click Add Related Tables to add tables from the data source that have matching column names. For more information about setting the NameMatchingCriteria property, see Data Source Views in Multidimensional Models.

Note

Adding or removing objects in a data source view does not affect the underlying data source.

See Also

Data Source Views in Multidimensional Models
Work with Diagrams in Data Source View Designer (Analysis Services)