index > SQL Server Analysis Services > Aggregate function "None"

Aggregate function "None"

Hi,

I created a Fact table with one measure (which represents a rate), 2 dimensions : Time and Countries (which is Parent/child Hierarchy)
I don't wantaggregation on this measure, so I changed measure properties to "None" for aggregation function.
But When I browse the cube and drill down on the Hierarchy Parent/Child, sub totals still appear...

Thanks
Sandrine

sandmil Tuesday, June 30, 2009 8:02 AM

Hi Sandrine,

I think you need to set the IsAggretable property for the parent-child hierarchy, not setting the aggregate function for the measure.

Double click the Countries dimension, right-click Parent/Child hierarchy in the Attributes pane of the Dimension Structure tab, and then click Properties. Scroll to the IsAggregatable property, and then click False in the property’s drop-down list. After that, the subtotal/total will not appear.

Aggregate function for a measure determines how to display the value along with the dimensions, it will change the fact value aggregate behavior, has no relationship with subtotal/total of a dimension. And if you select None for the aggregation, no aggregation is performed, and all values for leaf and nonleaf members in a dimension are supplied directly from the fact table for the measure group that contains the measure. If there is no value, it will show NULL. More information, see:

http://msdn.microsoft.com/en-us/library/ms175623.aspx#AggFunction

Hope this helps.

Raymond