Avoid defining measure groups with zero dimensional overlap

This rule analyzes cubes to determine whether the cube contains a measure group that has zero dimensional overlap with any other measure group.

For best performance, you should typically consider moving measure groups that have no dimensional overlap into different cubes.

Having many measure groups in a cube can adversely affect the query performance of the cube, even for queries that only use a single measure group. If your data source view contains many potential fact tables that will not typically be used together, consider creating multiple smaller cubes that contain topic areas that are used together. Then, you can enable occasional cross-topic querying by creating linked measure groups that join together all measure groups in a special cross-topic cube.

For more information, see Measures and Measure Groups in SQL Server Books Online.

Community Additions