Business Intelligence Architect Bill Pearson introduces simple Usage-Based Optimization in MSSQL Server 2005 Analysis Services. In this article, we practice employing the Usage-Based Optimization Wizard to fine tune our aggregation design based upon cube usage statistics.

This story continues at http://www.databasejournal.com/featu...le.php/3575751