Databases Reference
In-Depth Information
DimGeography table from the Main table drop-down list as shown in
Figure 5-7
and click Next.
Figure 5-7
6. At this point, the Dimension Wizard analyzes the DSV to detect any
outward-facing relationships from the DimGeography table. An
outward-facing relationship is a relationship between the DimGeo-
graphy table and another table, such that a column in the DimGeo-
graphy table is a foreign key related to another table.
Figure 5-8
shows that the wizard detected an outward relationship between the
DimGeography table and the DimSalesTerritory table. If you want to
model the selected main table as a star-schema table, deselect any
of the tables shown on that screen. You can try this out in the Geo-
graphy dimension you are creating now. Make sure the DimSalesTer-
ritory table is deselected and click Next.
Search WWH ::
Custom Search