The granularity attribute of the intermediate dimensions that are used to resolve many-to-many relationships should be included in all aggregation designs
TOC
Collapse the table of content
Expand the table of content

The granularity attribute of the intermediate dimensions that are used to resolve many-to-many relationships should be included in all aggregation designs

This rule analyzes aggregation designs to see whether the granularity attribute of the intermediate dimensions that are used to resolve many-to-many relationships are included in all aggregation designs.

For best performance, the granularity attribute of intermediate dimensions that are used to resolve many-to-many relationships should be included in all aggregation designs.

Aggregations on other attributes of the intermediate dimension might still be useful when the intermediate dimension is used directly and the many-to-many dimension is not used in a query.

Community Additions

ADD
Show:
© 2016 Microsoft