I have read about aggregation design tab in ssas.It is telling we can precalculate the aggregation and it will improve the response time.But when i tried that option,i haven't go thorough any step which is showing what kind of aggregation(eg:sum,avg etc) we have to do.In one of the steps, there is an option of specifying count of rows.So aggregation means only count of rows in table? Other than this we know,there is one calculated measure option using we can specify sum or avg or etc.This also one kind of aggregation right?
So, Can any one please make it clear about there two?
Thank You in advance.. :)
I'm not sure if I understand your question, but the method of aggregation is defined for each measure. See the properties of your measures to know what kind of aggregation method is used.
The estimated row count (of each partition) is used by SSAS to determine the necessary storage space of your aggregation design.