Share via


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

Use the Add/Remove Tables dialog box in Business Intelligence Development Studio 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.