Databases Reference
In-Depth Information
added to the script by the Cube Wizard. This statement indicates that the
Analysis Services instance is to aggregate the data from the lowest level of
attributes and hierarchies to higher levels. Aggregation of data to various
levels of a hierarchy is illustrated in
Figures 7-1
through
7-3
. Assume you
have a cube that has three dimensions: Geography, Products, and Time, with
hierarchies Customer Geography, ProductLine, and Date, respectively. For il-
lustration purposes assume Customer Geography and ProductLine are
single-level hierarchies and Date is a multilevel hierarchy with levels Quarter,
Semester, and Year.
Figure 7-1
Search WWH ::
Custom Search