Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Smiling DBA

Thomas LeBlanc ( MCITP 2005/2008 & MCDBA 2000) is a Senior SQL Server DBA at Turner Industries, LLC in Baton Rouge, LA. He has been in the IT field for 21 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, upgrading to Visual Basic versions 3-6 and even some .Net(C#). Designing and developing normalized database has become his passion. Full-time DBA work started about 9 years ago for Thomas while working at a Paper Mill in St. Francisville, LA continuing with IEM, then Amedisys. Performance tuning and reviewing database design and code was an everyday occurrence for DBAs at Amedisys. Thomas’ free time is spent helping those less fortunate and improving his relationship with his family and God.

Baton Rouge SQL Server User Group

Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge, LA. The topic will be Attributes and Hierarchies in Analysis Services 2012. The flow will be from requirements gathering thru implementation in the Semantic Model.

My employer, Turner Industries, LLC, will be sponsoring the evening which includes the .Net User and Windows Phone groups in Baton Rouge. We all meet on the same night and have networking/dinner together with a lightening round for all groups. Please come join us at Louisiana Technology Park on Florida Blvd. The park is an business incubator for technology companies in Baton Rouge and Louisiana.

March '13 SQL Server User Group Meeting

Topic: Attributes and Hierarchies in Analysis Services 2012

Date: Wednesday, March 13, 2013

Location: The Louisiana Technology Park

Sponsored By: TBA

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

Leave a comment on the original post [thesmilingdba.blogspot.com, opens in a new window]

Loading comments...