Question on Cube aggregation percentage?

Hi, all experts here,

As I am a bit confused about the aggregation percentage of a cube, when we partition the cube, we need to set the aggregation percentage. But how does the analysis services really work here with the pre-defined cube aggregation percentage? Does not the analysis services engine only aggregates data on cube hierarchies and user-defined aggregations? (assume we have defined both the natural and user-defined hierarchies and user-defined aggregations), how can we determine how much percentage of aggregations it will be for that?

Hope it is clear for your advices and help and I am looking forward to hearing from you shortly and thanks a lot in advance.

With best regards,

Yours sincerely,

The aggregation percent number is only an approximate representation of the number of aggregations and estimated performance benifit of aggregations designed by the aggregation wizard. Note that it's a bit misleading in that you don't want 100% but something more like 30%. I recommend reading http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc for more information on this subject.|||

Hi, Matt,

Thanks a lot for your kind advices and the very helpful imformation.

With best regards,

Yours sincerely,