Databases Reference
In-Depth Information
ance gain (> 30%) that forces Analysis Services to expand the
search space to deeper levels. Click the Next button after the ag-
gregations have been designed.
22. On the process options page, select the Process Partitions Immedi-
ately check box and click Finish as shown in
Figure 13-34
.
The new
aggregations will be created and applied to the Internet_Sales_2001
partition.
Figure 13-34
If you have existing aggregations at the start of design usage-based aggrega-
tion, Analysis Services doesn't take that existing aggregation design into con-
sideration. You can design aggregations by writing your custom AMO pro-
gram. You can download samples from this topic's companion web site that
show how to design aggregations using AMO.
Aggregation Design Options
So far you have learned to design aggregations using the Aggregation design
wizard and the Usage Based Optimization wizard. In both wizards you have
Search WWH ::
Custom Search