Diagram (Data Source View Designer) (SSAS)

  • Article

Use the diagram pane of the Data Source View Designer to view and modify tables, columns, named queries, named calculations, and relationships included in the diagram selected in the Diagram Organizer pane.

The diagram pane displays the diagram selected in the Diagram Organizer pane of the Data Source View Designer.

To change the area of the diagram that appears in the diagram pane, click the four-headed arrow in the lower right corner of the pane, and then drag the selection box over the thumbnail diagram until you select the area that is to appear in the diagram pane.

Diagram Context Menu Options

Right-clicking the background of the current diagram in the diagram pane opens the diagram context menu. The diagram context menu has the following commands:

  • New Named Query
    Opens the Create Named Query dialog box in which you can create a named query for the data source view in the current diagram. For more information, see Create/Edit Named Query Dialog Box (SSAS).
  • Add/Remove Tables
    Opens the Add/Remove Tables dialog box in which you can add or remove tables from the data source view. For more information, see Add/Remove Tables Dialog Box (SSAS).

  • Show Tables
    Opens the Show Tables dialog box. For more information, see Show Table Dialog Box (SSAS).

    Note

    This option does not appear if <All Tables> is selected in the Diagram Organizer pane and all tables appear in the diagram pane.

  • Show All Tables
    Displays all tables included in the data source view.

    Note

    This option does not appear if <All Tables> is selected in the Diagram Organizer pane and all tables appear in the diagram pane.

  • Show Friendly Names
    Shows the friendly names for the objects in the pane.
  • Select All
    Selects all of the objects in the pane.
  • Arrange Tables
    Arranges the objects in the pane according to the layout specified by clicking either Switch to Diagonal Layout or Switch to Rectangular Layout.

  • Switch to Diagonal Layout
    Arranges objects in a diagonal pattern.

    Note

    This option is available only if Switch to Rectangular Layout is selected.

  • Switch to Rectangular Layout
    Arranges objects in a rectangular pattern.

    Note

    This option is available only if Switch to Diagonal Layout is selected.

  • Refresh
    Opens the Refresh Data Source View dialog box in which you can refresh the data source view with updates from the underlying data source. For more information, see Refresh Data Source View Dialog Box.
  • Zoom
    Select one of the available zoom options.
  • Properties
    Displays the properties associated with the data source view in the Properties window of Business Intelligence Development Studio.

Table Context Menu Options

Right-clicking the name of a table or named query in the diagram pane opens the table context menu. The table context menu has the following commands:

  • New Relationship
    Opens the Create Relationship dialog box in which you can create a new relationship in the data source view for the selected table. For more information, see Create/Edit Relationship Dialog Box (SSAS).

  • Edit Named Query
    Opens the Edit Named Query dialog box in which you can edit the selected named query. For more information, see Create/Edit Named Query Dialog Box (SSAS).

    Note

    This option appears only if a named query is selected.

  • Replace Table
    Replaces the table selected in the data source view with either a named query or another table. The following table describes these options.

    Command Description

    With New Named Query

    Opens the Create Named Query dialog box and creates a named query using the structure of the selected table. For more information, see Create/Edit Named Query Dialog Box (SSAS).

    With Other Table

    Opens the Replace Table with Other Table dialog box in which you can replace the selected table with another table or view from the underlying data source. For more information, see Replace Table with Other Table Dialog Box.
  • Show Related Tables
    Displays the tables related to the table selected in the data source view.
  • Hide Table
    Removes the table from the current diagram.
  • Properties
    Displays the properties associated with the selected table in the Properties window of Business Intelligence Development Studio.

Column Context Menu Options

Right-clicking the name of a column or named calculation in a table or named query in the diagram pane opens the column context menu. The column context menu has the following commands:

  • Set Logical Primary Key
    Specifies that the selected column is a logical primary key column for the table.

    Note

    The option is available only if the selected column is not a logical primary key column.

  • New Relationship
    Opens the Create Relationship dialog box in which you can create a new relationship in the data source view for the selected table. For more information, see Create/Edit Relationship Dialog Box (SSAS).

  • Delete Logical Primary Key
    Specifies that the selected column is not a logical primary key column for the table.

    Note

    The option is available only if the selected column is a logical primary key column.

  • Delete Column
    Opens the Delete Objects dialog box in which you can delete the selected named calculation from the data source view. For more information, see Delete objects and files Dialog Box (Analysis Services).

    Note

    This option appears only if a named calculation is selected.

  • Explore Data
    Opens the Explore Data dialog box for the table that contains the selected column. For more information, see Explore Data Dialog Box (SSAS).
  • Properties
    Displays the properties associated with the selected column in the Properties window of Business Intelligence Development Studio.

Relationship Context Menu Options

Right-clicking a relationship in the Diagram pane opens the relationship context menu. The relationship context menu has the following commands:

  • Properties
    Displays the properties associated with the selected relationship in the Properties window of Business Intelligence Development Studio.

See Also

Reference

Data Source View Designer (SSAS)
Toolbar (Data Source View Designer) (SSAS)
Diagram Organizer (Data Source View Designer) (SSAS)
Tables (Data Source View Designer) (SSAS)

Help and Information

Getting SQL Server 2005 Assistance