Slicing and Dicing: Attributes and Hierarchies in SSAS 2012

SPEAKER: Thomas LeBlanc, Data Warehouse Architect, eQHealth

This 24 Hours of PASS session will explain how to use attributes and hierarchies in the SQL Server Analysis Services (SSAS) 2012 Semantic Model to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves rows and columns. In SQL Server's Semantic model, these are called attributes and hierarchies, and how you configure them in SSAS is important.

This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension, as well as their configuration for best performance and viewing.

 

 

To access your 24 Hours of PASS session recording, please provide the following:

  •