Share via

Data Source View (Dimension Structure Tab, Dimension Designer) (SSAS)

  • Article

Use the Data Source View pane to view tables and columns from the data source view associated with the selected dimension. This pane is used to create attributes, member properties, hierarchies, and levels, by dragging columns from the Data Source View pane to the Attributes or Hierarchies and Levels pane.

Options

Term Definition

Data Source View

Displays the data source view associated with the selected dimension.

(Move viewpoint)

Click the lower right corner of the pane, between the scrollbars, to select an area of the Data Source View pane to view.

Diagram Context Menu

The options listed in the following table are available in the context menu displayed by right-clicking the diagram background of the Data Source View pane.

Term

Definition

Show Tables

Displays the Show Table dialog box. For more information about the Show Table dialog box, see Show Table Dialog Box (SSAS).

Show All Tables

Displays in the pane all tables included in the data source view associated with the dimension.

Show Only Used Tables

Displays in the pane only those tables used by the dimension from the associated data source view.

Show Friendly Names

Select to show friendly names for the objects in the pane.

Select All

Selects all of the objects in the pane.

Find Table

Displays the Find Table dialog box. For more information about the Find Table dialog box, see Find Table Dialog Box (SSAS).

Arrange Tables

Arranges the objects in the pane according to the layout specified by selecting either Switch to Diagonal Layout or Switch to Rectangular Layout.

Switch to Diagonal Layout

Select to arrange objects in a diagonal pattern.

ms189025.note(en-US,SQL.90).gifNote:

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

Switch to Rectangular Layout

Select to arrange objects in a rectangular pattern.

ms189025.note(en-US,SQL.90).gifNote:

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

Edit Data Source View

Displays Data Source View Designer for the data source view associated with the dimension. For more information about Data Source View Designer, see Data Source View Designer (SSAS).

Show Data Source View In

Select one of the following options to toggle between viewing the Data Source View pane in the following modes:

  • Diagram
    Displays a diagram of the tables and columns associated with the current dimension.
  • Tree
    Displays a tree view that contains the tables and columns associated with the current dimension.

Copy Diagram From

Select one of the diagrams included in the data source view associated with the dimension to display it in the Data Source View pane.

Zoom

Select an available zoom option.

Properties

Displays the Properties window in Business Intelligence Development Studio for the data source view associated with the dimension.

Table Context Menu

The options listed in the following table are available in the context menu displayed by right-clicking the name of a table or view in the Data Source View pane.

Term Definition

Show Related Tables

Displays in the pane the tables related to the selected table in the data source view.

Hide Table

Removes the table from the pane.

Explore Data

Displays the Explore Data dialog box for the selected table. For more information about the Explore Data dialog box, see Explore Data Dialog Box (SSAS).

Edit Data Source View

Displays Data Source View Designer for the data source view that contains the selected table. For more information about Data Source View Designer, see Data Source View Designer (SSAS).

Properties

Displays the Properties window in Business Intelligence Development Studio for the selected table.

Column Context Menu

The options listed in the following table are available in the context menu displayed by right-clicking the name of a column in a table or view in the Data Source View pane.

Term Definition

New Attribute from Column

Displays in the pane the tables related to the selected table in the data source view.

Explore Data

Display the Explore Data dialog box for the table that contains the selected column. For more information about the Explore Data dialog box, see Explore Data Dialog Box (SSAS).

Edit Data Source View

Displays Data Source View Designer for the data source view that contains the selected column. For more information about Data Source View Designer, see Data Source View Designer (SSAS).

Properties

Displays the Properties window in Business Intelligence Development Studio for the selected column.

Relationship Context Menu

The options listed in the following table are available in the context menu displayed by right-clicking a relationship in the Data Source View pane.

Term Definition

Edit Data Source View

Displays Data Source View Designer for the data source view that contains the selected relationship. For more information about Data Source View Designer, see Data Source View Designer (SSAS).

Properties

Displays the Properties window in Business Intelligence Development Studio for the selected relationship.

See Also

Reference

Dimension Structure (Dimension Designer) (SSAS)
Toolbar (Dimension Structure Tab, Dimension Designer) (SSAS)
Attributes (Dimension Structure Tab, Dimension Designer) (SSAS)
Hierarchies and Levels (Dimension Structure Tab, Dimension Designer) (SSAS)

Help and Information

Getting SQL Server 2005 Assistance