Databases Reference
In-Depth Information
Figure 5-9
8. Analysis Services 2005 is aware of some common dimension types
often used in business intelligence applications. These common di-
mension types have dimension attributes associated with them that
typically form levels of a hierarchy within the dimension. In the Di-
mension Wizard you can choose the dimension type and specify the
columns in the table that correspond to the dimension attributes. In
the Specify Dimension Type drop-down menu shown in
Figure 5-10
,
the default dimension type selected is Regular, though several other
types are supported, some of which can be seen in the figure. The
Regular dimension type does not have predefined dimension attrib-
utes. If you click a different dimension type such as Organization or
Promotion you will see the dimension attributes that are commonly
associated with it. You can select the dimension attributes and speci-
fy the column in the data source that corresponds to them. When you
complete the wizard, these dimension attributes will be defined and
you will be able to see them in the Dimension Designer. For design-
ing the Geography dimension, select the Regular dimension type
and click Next.
Search WWH ::
Custom Search