Skip to main content

Professional Microsoft SQL Server Analysis Services 2008 with MDX

Professional Microsoft SQL Server Analysis Services 2008 with MDX

Sivakumar Harinath, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Denny Guang-Yeu Lee

ISBN: 978-0-470-24798-3

Mar 2009

1056 pages

Select type: Paperback

Product not available for purchase

Description

  • 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
Introduction.

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.

Index.

Readme FIRST
Download
Chapter 2
Download
Chapter 4
Download
Chapter 5
Download
Chapter 6
Download
Chapter 7
Download
Chapter 8
Download
Chapter 9
Download
Chapter 11
Download
Chapter 12
Download
Chapter 13
Download
Chapter 16
Download
Chapter 17
Download
Chapter 18
Download
Chapter 19
Download
Chapter 20
Download
Chapter 22
Download
Chapter 23
Download
Chapter 24
Download
Chapter 25
Download
Online Appendix - MDX Functions
This is the final version of the appendix.
Download
ChapterPageDetailsDatePrint Run
11, 12Error in Figures 1-6 and 1-7
Figures 1-6 and 1-7

The arrows need to be pointing from "Sales Fact" to "Time" rather than the opposite.
8/2/11