Either disable the attribute hierarchy or set the AttributeHierarchyOptimizedState property to ...
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.
Tags: tip