Avoid having 15 or more measure groups in a cube
This rule analyzes each cube to determine whether the cube has more than 15 measure groups.
Best Practices Recommendations
Cubes with 15 or more measure groups will usually not perform as well as cubes with fewer measure groups. For best performance, you typically should consolidate measure groups in the cube or separate them into multiple cubes.
For More Information
For more information about how to define cubes and measure groups, see Defining and Configuring Cubes and Cube Properties in SQL Server Books Online.