Select Dimension Table (Dimension Wizard)

Analysis Services

Analysis Services

Select Dimension Table (Dimension Wizard)

In this step of the wizard, you select the table or tables from which you want to create your dimension. If you select multiple tables, all the tables must come from the same data source.

This wizard step is not displayed if you selected Virtual Dimension: The member properties of another dimension or Mining Model: Predictable column of OLAP mining model in the second step of the wizard.

Under Available tables, the wizard displays a list of the tables in your data source that are available for creating dimensions. Click the expand (+) button to expand the data source and view the tables contained within.

Options

Available tables

Select the table you want to add. If you do not see the table you want to use for the dimension, choose another data source.

Note  All the tables you select must come from the same data source. If you add a table from a data source that is different from that of the other selected tables, the list of tables under Selected tables will be cleared.

Details

View the columns of the table selected in Available tables.

New Data Source

Click to choose a data source that is not listed under Available tables.

Browse Data

Click to view data in the table selected in Available tables.