Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft