Databases Reference
In-Depth Information
Figure 5-10
9. The next screen in the Dimension Wizard is to define Parent-Child
relationship within a dimension. A commonly used example of a
Parent-Child relationship is readily seen in any organizational chart;
it is the relationship between managers and their direct reports. You
learn more about Parent-Child relationships later in this chapter.
There is no Parent-Child relationship in the DimGeography table.
You don't need to make any change here, so click Next.
10. On the Detecting Hierarchies screen, the wizard gets a sample of the
data from the data source and scans for relationships between the
columns in the table. If one-to-many relationships are detected within
this sample, the wizard suggests hierarchies. The attributes that form
the different levels within the hierarchies will be detected and shown
to you on the following screen. The wizard gives you the option of in-
cluding or excluding the detected hierarchies; in this example the Di-
mension Wizard does not detect any such hierarchies (see feedback
from the Dimension Wizard after it analyzed the DimGeography table
as shown in
Figure 5-11
). Hence the following screen does not have
any hierarchies. Click Next on this screen, and click Next again on
the following screen of the wizard.
Search WWH ::
Custom Search