SSAS 2008: New Cube Aggregations tab

The November CTP of SQL Server 2008 was released on the connect MSDN Downloads site at the end of last week and when you open up a cube in BIDS you will see a new tab for aggregations. I figured I might give you a bit a walk through what you can expect from this new tab.

image

What this tab does is to let you see all the aggregation designs that relate to a given measure group. It also lets you manage which partitions are using a particular aggregation design.

As with the other Analysis Services designers, the new AMO warnings are also surfaced in the aggregations tab which lets you see if there are any basic issues with your aggregations.

Such as a particular design no being referenced by any partitions

image

Or even an AggregationUsage property not being set properly.

image

Right-clicking on an aggregation design gives a number of options including

"Design New Aggregations", "Usage Based Optimisation" and "Assign Aggregation designs".

image

 

When you start up the "Design Aggregations" Wizard you can now easily select which aggregations a particular design is to apply to. 

part-wiz1

One of the coolest additions to the aggregation design wizard is the following screen which shows you the aggregation usage setting for all the attributes and gives you the ability to change them.

part-wiz2

The objects count screen appears largely unchanged.

part-wiz3

As does the core Aggregation Options screen. 

part-wiz4

At the end of the whole process you get to give your design a name. I would suggest that you might want to think about including an indication of the design options that you used. (eg "30 pcnt", "upto 150Mb", etc. ) You can see a property for the aggregation level when you view the properties of the aggregation design, which is where I thought information like this would be recorded, but that property did not appear to update (maybe this will change in a future build). But if you have a couple of different aggregation designs, this would let you see at a glance, which was which.

part-wiz5

When you right click an Aggregation Design and choose the option to Assign Aggregations, you get the following dialog box. This gives you a very easy way to apply a given aggregation designs to a group of partitions.

assign-aggs

While this feature does not let you manually build your own aggregations like the "Edit Aggregations" feature in BIDSHelper, I would argue that most people should not need to go to that extent.

Update 20 Nov 07: corrected the download location details

Technorati Tags: , ,

Print | posted on Sunday, November 18, 2007 7:18 PM

Comments on this post

# re: SSAS 2008: New Cube Aggregations tab

Requesting Gravatar...
Here are this and some other articles on SSAS Aggregations: http://ssas-wiki.com/w/Articles#Aggregations
Left by Sam Kane on Feb 24, 2011 8:24 AM

# re: SSAS 2008: New Cube Aggregations tab

Requesting Gravatar...
Here are this and some other articles on SSAS Aggregations: http://ssas-wiki.com/w/Articles#Aggregations
Left by Sam Kane on Feb 24, 2011 8:35 AM

# re: SSAS 2008: New Cube Aggregations tab

Requesting Gravatar...
It would be great to suggest some optimization techniques.
BI Metrics, www.bimetrics.ca
Left by Mike on Nov 17, 2011 6:01 AM

Your comment:

 (will show your gravatar)