Aggregations for Max Performance

In the past, I blindly opted for MOLAP and set the percentage to 100% while designing the aggregations for my cubes. Of course, it rarely got to 100%, but I figured that was the best way to get the maximum performance for my cubes in terms of aggregations.

Now fast forward to today, I decided to go through the wizard again because I've recently added a few measure groups and they currently do not have any aggregations right now.

I went through each partition again, opted for MOLAP with 100%, and noticed that most of them went down in percentage. Why is that the case?

Perhaps more importantly, anything "wrong" with my approach of MOLAP 100%? I assume that the only concern I have with doing so is the processing time of the cube? If so, I'm not worried about that as we doing nightly.

Thanks!

Hello

You should take a look at this great post by Chris Webb:

http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!907.entry

More aggregations are not always better. In some cases, overdoing the number of aggregations can have a negative impact on performance.