Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Include the granularity attribute of the time dimension in all the aggregations of measure groups with only semi-additive measures
Collapse the table of content
Expand the table of content

Include the granularity attribute of the time dimension in all the aggregations of measure groups with only semi-additive measures

This rule analyzes aggregation designs in measure groups that contain only semi-additive measures to verify that the granularity attribute of the time dimension has been included.

You should include the granularity attribute of the time dimension in all of the aggregations. Queries to semi-additive measures are always evaluated at the grain-level of the time dimension. For example, the calculation engine will automatically calculate a query for the inventory count in Q1 at the month level, if the grain of the time dimension is months, and it will then compute the result for Q1 "on-the-fly". Because of this query time behavior, aggregations above the month level will never be used.

Community Additions

ADD
Show:
© 2015 Microsoft