Implementing Aggregations

Why is it so important to add the correct amount of aggregations to your cube’s partitions? As stated previously, it might not be. Keep in mind that some SSAS cubes do not require aggregations to enable them to function acceptably. Similar to the the idea that small OLTP databases need no relational indexes, if your cube is quite small (under 5 GB) and you have a small number of end users (100 or less), you might not have to add any aggregations at all. Also, adding aggregations to a particular partition is done for the same reason that you add indexes to an RDBMS—to speed up query response times. The process to add these aggregations is only marginally similar to the process of adding indexes to an RDBMS. BIDS includes ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.