Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Video on Analysis Services Aggregation Designs


By:   |   Read Comments   |   Related Tips: > Analysis Services Development


Free MSSQLTips Webcast Today >> Optimize SQL Server Performance




 






Enter your email address to
get free SQL Server tips.

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



Last Update:


signup button

next tip button



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

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Learn more about SQL Server tools