Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Add/Remove Tables Dialog Box
Collapse the table of content
Expand the table of content

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

 

Use the Add/Remove Tables dialog box in SQL Server Data Tools (SSDT) 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:
© 2015 Microsoft