Adding Aggregations
Why is it so important to add the correct amount of aggregations to your cube(s)? As stated previously, it may not be. It's important to remember that some SSAS cubes do not require aggregations to function acceptably. Similar to the the idea that tiny OLTP tables need no relational indexes, if your cube is quite small (under 1GB) and if you have a small number of end users (100 or fewer), you probably won't have to add any aggregations at all.
Unlike adding indexes to a relational database, which can be time consuming if manually done, adding aggregations to an SSAS cube can be done pretty quickly via a couple of wizards (or tools) in BIDS. There are a couple of considerations when adding aggregations to a cube: aggregations ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.