Databases Reference
In-Depth Information
font along with the estimated count of members as shown in
Figure
13-22
. For the partition count column, since the fact table only in-
cludes the granularity attribute (the customer key), that count is also
available for Analysis Services to determine the aggregation design.
You have the option to include or exclude attributes for consideration
for aggregation design. By default, Analysis Services includes the
key attributes for consideration during aggregation design. All the at-
tributes that are levels of natural hierarchies are considered for ag-
gregation design. If a user hierarchy is unnatural the topmost level is
considered for aggregation design. The remaining levels of the un-
natural hierarchy from the top most level are included for considera-
tion if there is a one-to-many relationship from that level to the next
level. As soon as there is no relationship between successive levels
then the remaining levels below that level of the unnatural hierarchy
are not considered during aggregation design. Click the Next button.
Figure 13-22
8. You are now in the Aggregation Options page, as shown in
Figure
13-23
. The engine gives you four possible options for how to design
the aggregations:
Search WWH ::
Custom Search