Cube aggregations stop unexpectedly

I am trying to design agreegations for all the partitions of my MOLAP cube. The aggregation calculation process starts but stops at 2% performance (about 20MB).

I have tried to re-argregate so many times by selecting all the options :-

Estimated Storage reaches (100 MB) /
Performance gain reaches (30%)/
I click Stop

But, in all these cases it just stops at 2%. I cannot understand why? And its not one particular partition. Rather all the partitions (eight of them) stop at 2%. There is enough free hard disk space as well (27 gb)

Any, clues could be of great help. Thanks.

Any idea from the MS Analysis services group?|||

The problem is that not all attributes are considered during aggregation design.

Try creating more user hierarchies. Try marking cube attribute AggregationUsage property as Unrestricted.

Hope that helps

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights