Avoid redundant attribute relationships because these relationships may prevent data from being aggregated when the granularity attribute of a cube is a non-key attribute.
Importance - Medium. Source - SSAS 2008 (Katmai) June CTP Dimension design warning rules.