Acadiana SQL - Meeting - May 2014

Topic: Attributes & Hierarchies in Analysis Services 2012

Date: Tuesday, May 27

Location: South Regional Library

Agenda:

  • 5:45 - 6:15 pm: Networking and Refreshments
  • 6:15 - 6:30 pm: Announcements
  • 6:30 - 8:00 pm: Main Topic Speaker

Speaker: Thomas LeBlanc (twitter | blog)

Presentation 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.

Speaker Bio: Thomas LeBlanc (MCITP 05/08 DBA & 08 BI) a BI Architect in Baton Rouge & PASS Data Architecture VC. Chair specialties include normalization, performance tuning, database design, ETL-SSIS, SSAS cubes and T-SQL code. He spends most of his time gathering requirements, designing, coding and presenting Data Marts using SSIS, SSAS Cubes, Excel & PerformancePoint migrating to 2012 tabular. Spends his free time helping those less fortunate & improving his relationship with his family & God.

Directions from out of town:

From I-10, take exit 10 and head South on (LA-3184) Ambassador Caffery Pkwy for approx 4 miles
Turn Right onto (US-167) S Johnston Street for approx 1 mile
Make a U-turn at (LA-724) Duhon Road
South Regional Library will be on the right hand side


View Larger Map

Contact Us

You can contact us in any of the following ways:

Twitter: @acadianaSQL

Email: info@acadianasql.org

SQL