Professional Microsoft SQL Server Analysis Services 2008 with MDX by Sivakumar HarinathProfessional Microsoft SQL Server Analysis Services 2008 with MDX by Sivakumar Harinath

Professional Microsoft SQL Server Analysis Services 2008 with MDX

bySivakumar Harinath, Robert Zare, Sethu Sethu Meenakshisundaram

Paperback | March 16, 2009

Pricing and Purchase Info


Earn 300 plum® points

Prices and offers may vary in store

Out of stock online

Not available in stores


  • When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis.
  • Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions
  • Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more
Sivakumar Harinath was born in Chennai, India. Siva has a Ph.D. in Computer Science from the University of Illinois at Chicago. His thesis title was "Data Management Support for Distributed Data Mining of Large Datasets over High Speed Wide Area Networks." Siva has worked for Newgen Software Technologies (P) Ltd., IBM Toronto Labs, Can...
Title:Professional Microsoft SQL Server Analysis Services 2008 with MDXFormat:PaperbackProduct dimensions:1056 pages, 9 × 7.2 × 2.2 inShipping dimensions:9 × 7.2 × 2.2 inPublished:March 16, 2009Publisher:WileyLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0470247983

ISBN - 13:9780470247983


Table of Contents


Part I: Introduction.

Chapter 1: Introduction to Data Warehousing and SQL Server 2008 Analysis Services.

Chapter 2: First Look at Analysis Services 2008.

Chapter 3: Introduction to MDX.

Chapter 4: Working with Data Sources and Data Source Views.

Chapter 5: Dimension Design.

Chapter 6: Cube Design.

Chapter 7: Administering Analysis Services.

Part II: Advanced Topics.

Chapter 8: Advanced Dimension Design.

Chapter 9: Advanced Cube Design.

Chapter 10: Advanced Topics in MDX.

Chapter 11: Extending MDX Using External Functions.

Chapter 12: Data Writeback.

Part III: Advanced Administration and Performance Optimization.

Chapter 13: Programmatic and Advanced Administration.

Chapter 14: Designing for Performance.

Chapter 15: Analyzing and Optimizing Query Performance.

Part IV: Integration with Microsoft Products.

Chapter 16: Data Mining.

Chapter 17: Analyzing Cubes Using Microsoft Office Components.

Chapter 18: Using Data Mining with Office 2007.

Chapter 19: Integration Services.

Chapter 20: Reporting Services.

Part V: Scenarios.

Chapter 21: Designing Real-Time Cubes.

Chapter 22: Securing Your Data in Analysis Services.

Chapter 23: Inventory Scenarios.

Chapter 24: Financial Scenarios.

Chapter 25: Web Analytics.

Appendix A: MDX Functions.