SSAS-Info.com website update information for November 2007.
This newsletter can be accessed online at:http://www.ssas-info.com/newsletters/website_update/ssas-info.com_november_2007.html
Either disable the attribute hierarchy or set the AttributeHierarchyOptimizedState property to notOptimized for non-key attributes that have 1000000 or more members and a cardinality within 95% of the key attribute.
Importance - Medium. Source - SSAS 2008 (Katmai) June CTP Dimension design warning rules.