Well, good for you then - but, according to this document, Aggregation Usage should only be set to "Full" in special cases: http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7 151b2011c/SSAS2005PerfGuide.doc >> Analysis Services 2005 Performance Guide .. Change the value of the Aggregation Usage property from Default to Full in the unusual case that it is used in virtually every query you want to optimize. This is a very rare case and should only be used for attributes that have a relatively small number of members. .. >> - Deepak Deepak Puri Microsoft MVP - SQL Server *** Sent via Developersdex http://www.developersdex.com ***
