Avoid defining many-to-many relationships when either the intermediate measure group ...

Written by webadmin. Posted in SSAS Tips

Avoid defining many-to-many relationships when either the intermediate measure group or any of the intermediate dimensions have 1 million or more rows.

Importance - High.
Source - SSAS 2008 (Katmai) June CTP Cube design warning rules.

Tags: tip, many-to-many