This article in DM Review suggests the wrong approach to creating aggregate tables. If you try to build an aggregate table in response to specific business needs, you may end up with a large number of aggregates that become a maintenance headache. Besides, unless I’m missing the point, business users don’t need aggregates. What they need is reports that return immediately.