O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

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

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