Select the Main Dimension Table (Dimension Wizard)
Use the Select the Main Dimension Table page to select the main dimension table, key columns, and member name column for the dimension to be created.
Note
This page is displayed only if you selected Build the dimension using a data source on the Select Build Method page and if you selected Standard dimension on the Select the Dimension Type page.
Options
- 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 of the columns included in the composite primary key.
- Column containing the member name (optional)
Select the column from the table specified in Main table that provides the member names for the dimension. Select the empty value at the top of the drop-down list to indicate that the table does not contain a separate column for member names.
See Also
Reference
Dimension Wizard F1 Help (SSAS)
Other Resources
Dimensions (Analysis Services)
Defining and Configuring Dimensions, Attributes, and Hierarchies