Share via

How to: Define, Rename, Modify, or Delete a Diagram using Data Source View Designer

  • Article

You use Business Intelligence Development Studio to define, modify, rename, or delete a data source view diagram in an Analysis Services project or database.

To define a new diagram

  1. In Business Intelligence Development Studio, open the project or connect to the database that contains the data source view in which you want to define a new diagram.

  2. In Solution Explorer, expand the Data Source Views folder, then open the data source view in Data Source View Designer by doing one of the following:

    • Double-click the data source view.
    • Right-click the data source view and click Open.
    • Click the data source view and then on the View menu, click Open.

  3. Define a name for a new diagram by doing one of the following:

    • Right-click anywhere in the Diagram Organizer pane, click New Diagram, and then type a name for the new diagram in the Diagram Organizer pane.
    • On the Data Source View menu, click New Diagram, and then type a name for the new diagram in the Diagram Organizer pane.
    • On the Data Source View Designer toolbar, click New Diagram, and then type a name for the new diagram in the Diagram Organizer pane.

    A blank diagram appears in the Diagram pane.

  4. Add tables, views, and named queries from the Tables pane to the new diagram by doing one of the following:

    • Drag selected tables from the Tables pane into the empty Diagram pane.
    • Right-click an open area of the Diagram pane, click Show Tables, select one or more tables to display in the Diagram pane and click OK.
    • On the Data Source View menu, click Show Tables, select one or more tables to display in the Diagram pane and click OK.
    • Right-click a table in the Diagram pane, and then click Show Related Tables.
    • Click a table in the Diagram pane, and then click Show Related Tables.

  5. Optionally, add new tables or views to the new diagram and to the <All Tables> diagram. For more information on how to add tables and views, see How to: Add or Remove Tables or Views in a Data Source View Using Data Source View Designer.

  6. Optionally, add new named queries to the new diagram and to the <All Tables> diagram. For more information on how to add named queries, see How to: Add, View, Modify, or Delete a Named Query Using Data Source View Designer.

  7. Save the modified data source view by doing one of the following:

    • On the File menu, click Save Selected Items or Save All.
    • On the Data Source View Designer toolbar, click Save Selected Items or Save All.
    • Close the Data Source View Designer in Business Intelligence Development Studio and then click Save when prompted.

To remove tables from a diagram

  1. In the Diagram Organizer pane in Business Intelligence Development Studio, click the diagram from which you wish to remove a table, named query, or view.

  2. In the Diagram pane, select the tables, views or named queries that you wish to remove from the selected diagram and then do one of the following:

    • Right-click one of the selected objects and then click Hide Table.
    • On the Data Source View menu, click Hide Table.

    Removing tables from a diagram does not remove them from the data source view. However, deleting tables from a diagram deletes the table from the data source view itself.

To rename a diagram

  1. In Business Intelligence Development Studio, open the project or connect to the database that contains the data source view in which you want to rename a diagram.

  2. In Solution Explorer, expand the Data Source Views folder, then open the data source view in Data Source View Designer by doing one of the following:

    • Double-click the data source view.
    • Right-click the data source view and click Open.
    • Click the data source view and then on the View menu, click Open.

  3. Rename the diagram by doing one of the following:

To delete a diagram

  1. In Business Intelligence Development Studio, open the project or connect to the database that contains the data source view in which you want to delete a diagram.

  2. In Solution Explorer, expand the Data Source Views folder, then open the data source view in Data Source View Designer by doing one of the following:

    • Double-click the data source view.
    • Right-click the data source view and click Open.
    • Click the data source view and then on the View menu, click Open.

  3. Delete the diagram by doing one of the following:

    • In the Diagram Organizer pane, right-click the diagram that you wish to delete, click Delete and then click OK in the Delete Objects pane.
    • In the Diagram Organizer pane, click the diagram that you wish to delete, click Delete on the Data Source View Designer toolbar and then click OK in the Delete Objects pane.

  4. Save the modified data source view by doing one of the following:

    • On the File menu, click Save Selected Items or Save All.
    • On the Data Source View Designer toolbar, click Save Selected Items or Save All.
    • Close the Data Source View Designer in Business Intelligence Development Studio and then click Save when prompted.

See Also

Tasks

How to: View Objects in a Data Source View Using Data Source View Designer

Concepts

Working with Data Source Views (Analysis Services)
Working with Diagrams in a Data Source View (Analysis Services)

Other Resources

Working with Data Source Views How-to Topics (SSAS)

Help and Information

Getting SQL Server 2005 Assistance