March '13 SQL Server User Group Meeting

posted Feb 21, 2013, 4:36 PM by BRSSUG SQLPass BatonRouge   [ updated Mar 4, 2013, 9:18 PM ]

Topic: Attributes and Hierarchies in Analysis Services 2012


Date: Wednesday, March 13, 2013

Location: The Louisiana Technology Park


Sponsored By: Turner Industries


Agenda:

5:45 - 6:15 pm: Networking and Refreshments

6:15 - 6:30 pm: Lightning Round Topic

6:30 - 8:00 pm: Main Topic

8:00 - until: Open Forum for questions and giveaways


Main Topic: Attributes and Hierarchies in Analysis Services 2012

Main Topic Speaker: Thomas LeBlanc, Turner Industries

Summary: The session explains Attributes and Hierarchies in Analysis Services 2012 Semantic Model. They are used to slice (filter) and dice (group) measures and dimensions used to view analytical data. The slicing and dicing of data involves fields, columns, or whatever you want to labeled them. But, in SQL Server Semantic model these are called Attributes and Hierarchies. The configuration of these slicers and dicers are important in SQL Server Analysis Services. This session will demonstrate the difference between an attribute and columns in a hierarchy in the dimension as well as the configuration of these for best performance and viewing.

Summary: Thomas LeBlanc (MCITP DBA/BI) is a Sr. SQL Server DBA @ Turner Industries & the PASS Data Architecture Virtual Chapter Chair. His specialties include normalization, performance tuning, database design, ETL-SSIS, SSAS cubes and T-SQL code. DBA work includes monitoring many SQL Server instances at Turner for performance and uptime then spends the other half of his time gathering requirements, designing, coding and presenting Data Marts using SSIS, SSAS Cubes, Excel & PerformancePoint while migrating some cubes to 2012 Tabular Model for PowerView.



Comments