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

  • Article

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.

Options

  • 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.

See Also

Reference

Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Data Source View Designer (Analysis Services - Multidimensional Data)