Step by Step Developer

2 total works

Microsoft(r) SQL Server 2005 Integration Services Step by Step

by Paul Turley, Joe Kaspizak, Scott Cameron, Satoshi Iizuka, Pablo Guzman, and Hitachi Consulting

Published 1 June 2007

Microsoft SQL Server 2008 MDX Step by Step

by Bryan C Smith, C Ryan Clay, and Hitachi Consulting

Published 1 February 2009

Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions.

Discover how to:

• Construct and execute MDX queries
• Work with tuples, sets, and expressions
• Build complex sets to retrieve the exact data users need
• Perform aggregation functions and navigate data hierarchies
• Assemble time-based business metrics
• Customize an Analysis Services cube through the MDX script
• Implement dynamic security to control data access
• Develop MDX-driven reports in SQL Server Reporting Services
  
  

CD features:

• Practice exercises
• Database and code samples
• Fully searchable eBook