{"id":1153,"date":"2015-08-17T12:38:56","date_gmt":"2015-08-17T11:38:56","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=1153"},"modified":"2015-08-18T11:44:54","modified_gmt":"2015-08-18T10:44:54","slug":"ssas-interview-question-what-are-aggregates-what-is-the-purpose-of-defining-an-aggregation-design-in-analysis-services","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/ssas-interview-question-what-are-aggregates-what-is-the-purpose-of-defining-an-aggregation-design-in-analysis-services\/","title":{"rendered":"SSAS Interview question: What are aggregates? What is the purpose of defining an aggregation design in Analysis Services?"},"content":{"rendered":"

Aggregates are summarized values, each of which corresponds to a combination of an attribute from each dimension and a measure group. An aggregate in SSAS is the differentiating factor between OLAP and OLTP, and is the fundamental principle of SSAS\/OLAP, which offers blazing fast performance.<\/p>\n

In theory, many people believe that SSAS stores aggregated values for every combination of each attribute from each dimension and in each measure group. However, in reality, SSAS stores only a part of all combinations and not all the possible combinations. In some scenarios it might be helpful to create certain percentage of aggregations every time the cube is processed, without leaving the decision to SSAS. This is achieved by defining aggregation design.<\/p>\n

The Aggregation Design Wizard is used to design aggregations in SSAS and it provides the following options as part of the aggregation design process:<\/p>\n