Database Reference
In-Depth Information
Specify Source Information
On the third page of the wizard, select which data source view contains the table or tables you are going to use for
your dimension. In the PubsBICubes project, we have only one data source view to choose from (Figure
9-36
).
Figure 9-36.
The Specify Source Information page in the Dimension Wizard
After having selected the data source view, select a table from the “Main table” dropdown box. Each
dimension may have only one table, which of course will be its main table. In cases where the dimension is
designed in a snowflake format, such as the Titles dimension in the PubsBICubes project, the main table is the
one directly connected to the fact table. This means you do not have to select both the DimTitles table and the
DimPublishers tables. Only select the main DimTitles table, as shown in Figure
9-37
.
