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.

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 about how to define cubes and measure groups, see Defining and Configuring Cubes and Cube Properties in SQL Server Books Online.

Community Additions