Microsoft SQL Server 2008 MDX Step by Step - Brossura

Smith, Bryan C.; Clay, C. Ryan; Hitachi Consulting

Brossura

ISBN 10: 0735626189 ISBN 13: 9780735626188

Casa editrice: Microsoft Pr, 2009

Riassunto

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

Su questo libro

L'autore

Bryan C. Smith is an architect with Hitachi Consulting, where he implements data warehouse solutions with SQL Server. He also leads Analysis Services and MDX training courses, participates in the Analysis Services forums on MSDN, and is coauthor of Professional SQL Server 2008 Reporting Services.

C. Ryan Clay is a solution architect for Hitachi Consulting, where he develops business solutions based on Microsoft technologies, including OLAP and MDX-based applications. Active in supporting the Microsoft business intelligence community, he’s presented at Microsoft Tech*Ed, SQL PASS, and MSDN events.

Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for Reporting Services

Contenuti

List of FiguresList of TablesAcknowledgementsIntroductionPart I: MDX Fundamentals

• Chapter 1: Welcome to MDX
• Chapter 2: Using the MDX Query Editor
• Chapter 3: Understanding Tuples
• Chapter 4: Working with Sets
• Chapter 5: Working with Expressions

Part II: MDX Functions

• Chapter 6: Building Complex Sets
• Chapter 7: Performing Aggregation
• Chapter 8: Navigating Hierarchies
• Chapter 9: Working with Time

Part III: MDX Applications

• Chapter 10: Enhancing the Cube
• Chapter 11: Implementing Dynamic Security
• Chapter 12: Building Reports

Appendix : Appendix

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2009
• ISBN 10: 0735626189
• ISBN 13: 9780735626188
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 363