O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required