SQL Server Video on Analysis Services Aggregation Designs

By:   |   Comments   |   Related: > Analysis Services Development

Problem / Solution

Just like with SQL Server indexes, there are several methods available for setting up aggregations in SSAS. You can use the Aggregation Design wizard or the Usage Based Optimization wizard to setup aggregations in just a few steps. However, SSAS also provides a method of reviewing and even adding individual aggregation designs (aggregation groups) and individual aggregations in a more manual method. In order to create new aggregations, you must switch to the advanced view within the cube aggregation tab. Once on the Advanced view, individual dimension attributes can be added to your own custom aggregations which are tailored to your specific SSAS cube design and usage.

Be sure to read the full tip at: SQL Server Analysis Services Aggregation Designs

Key Learning Items

The video covers:

  • Aggregation Design wizard
  • Usage Based Optimization wizard
Read Companion Tips

Click Here

sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip

About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips

Comments For This Article

get free sql tips
agree to terms