Add/Remove Tables Dialog Box (Analysis Services - Multidimensional Data)

 

Applies To: SQL Server 2016

Use the Add/Remove Tables dialog box in Data Source View Designer to add or remove tables in a data source to or from a data source view. You can display the Add/Remove Tables dialog box by:

  • Clicking Add/Remove Objects in the Toolbar pane of Data Source View Designer.

  • Right-clicking the Diagram pane of Data Source View Designer and selecting Add/Remove Tables.

Data source
Select the data source to add or remove tables.

Available objects
Displays the objects and their types in the data source that are not already included in the data source view.

Click >> to transfer all objects listed in Available objects to Included objects, or select one or more objects and click > to transfer the selected objects to Included objects.

Filter
Type the filter used to restrict the objects listed in Available objects, and then click the button to filter the listed objects.

Show system objects
Select to display system objects for the data source in Available objects.

Included objects
Displays the objects and their types that have already been added to the data source view.

Click << to transfer all objects listed in Included objects to Available objects, or select one or more objects and click < to transfer the selected objects to Available objects.

Add related tables
Click to add all tables that are related to the selected tables in Included objects.

Community Additions

ADD
Show: