Identify Fact and Dimension Tables (Diagram Tab) (Cube Wizard)

  • Article

Use the Identify Fact and Dimension Tables page to indicate which tables from the specified data source view to include in the cube, and to identify whether a table is to be used as a fact table, a dimension table, or both within the cube. If the Auto build option on the Select Build Method page was selected, the tables will already have recommended types set.

The Diagram tab displays the tables and their relationships in diagram form. To modify a table, select that table by clicking on it in the diagram. To select more that one table at a time, drag the cursor across the tables. To change which portion of the diagram appears on the tab, click the navigation button (a four-headed arrow) in the lower-right corner and then drag the selection pane to the area that you want to display.

If you want to see the tables displayed in a grid instead of in a diagram, click the Tables tab.

Note

This page will appear only if you have selected Build the cube using a data source on the Select Build Method page.

Note

You can select both Fact and Dimension for a selected table. Selecting both options indicates that the table is to be used as both a fact table and as a dimension table. If both options are selected, the dimension created from the selected table has a fact dimension relationship to the measure group created from the selected table.

Options

  • Time dimension table
    Select the table to use as the time dimension table. If there is no time dimension table in the data source view, select <None>.

Diagram Tab Options

  • Zoom
    Select the zoom ratio to resize the tables.

  • Fact
    Click to indicate that the selected table is a fact table. The table will turn yellow if it is only a fact table or green if it is both a fact table and a dimension table.

    Note

    The fact table will turn red if the table has no relationship to any dimension table.

  • Dimension
    Click to indicate that the selected table is a dimension table. The table will turn blue if it is only a dimension table, or green if it is both a fact table and a dimension table.

    Note

    The dimension table will turn red if the table has no relationship to any fact table.

See Also

Reference

Cube Wizard F1 Help (SSAS)

Other Resources

Cubes (Analysis Services)
Defining and Configuring Cubes and Cube Properties
Defining and Configuring Dimensions, Attributes, and Hierarchies

Help and Information

Getting SQL Server 2005 Assistance