Share via

Specify Source Information (Dimension Wizard)

  • Article

Use the Select the Main Dimension Table page to select the data source view, main dimension table, key columns, and member name column for the dimension to be created.

To open the Dimension Wizard

  • In SQL Server Data Tools (SSDT), in Solution Explorer, right-click the Dimensions folder for an Analysis Services project, and then click New Dimension.

Options

Data source view
Select a data source view.

Main table
Select a table from the selected data source view to use as the main table for the dimension.

Key columns
Select the key columns from the table specified in Main table for the key attribute of the dimension.

Note

More than one column can be selected. If the table contains a composite primary key, select all the columns included in the composite primary key. The order of the key columns is important.

Name column
Select the column from the table specified in Main table that provides the member names for the dimension. A name column must be specified when a composite key is used. To create a name column for a composite key, we recommend that you create a named calculation in the data source view that concatenates the specified key columns. When a single key is used, the name column is optional.

See Also

Dimension Wizard F1 Help
Dimensions (Analysis Services - Multidimensional Data)
Dimensions in Multidimensional Models