Professional SQL Server Analysis Services 2005 with MDX

by Harinath, Sivakumar; Quinn, Stephen R.

• ISBN13: 9780764579189
• ISBN10: 0764579185
• Format: Paperback
• Copyright: 2006-05-30
• Publisher: Wrox

Summary

SQL Server Analysis Services 2005 provides you with the business intelligence platform needed to build full-scale, multidimensional databases. MDX is the query language used to extract information from those multidimensional databases. Analysis Services 2005 supports core business functions such as market analysis, budgeting and forecasting.

Author Biography

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, Canada, and has been at Microsoft since February of 2002. Siva started as a Software Design Engineer in Test (SDET) in the Analysis Services Performance Team and is currently an SDET Lead for Analysis Services 2005. Siva’s other interests include high performance computing, distributed systems and high speed networking. Siva is married to Shreepriya and had twins Praveen and Divya during the course of writing this book. His personal interests include travel, games/sports (in particular, Chess, Carrom, Racquet Ball, Board games) and Cooking. You can reach Siva at [e-mail]

Stephen Quinn was born in San Luis Obispo, California. Stephen has a Masters degree (1988) in Cognitive Psychology from California State University, Chico and is scheduled to receive his Masters of Business Administration (MBA) from the University of Washington, Seattle, in June 2006. Stephen is married to Katherine and is raising his daughter, Anastasia. He has been in most roles common to the R&D environment i.e., software developer, technical writer, technical support specialist and several quality assurance roles. Stephen has published some 20 articles in the magazines Byte, InfoWorld and Datamation. With 15+ years of software experience; Stephen has worked the last 8 years at Microsoft; most recently as a Technical Writer in SQL User Education and before that, for several years as Test Manager in the SQL Business Intelligence Unit. You can reach Stephen at [e-mail].

Table of Contents

1. Introduction.

2. A First Look at SQL Server Analysis Services 2005 Tools.

3. Introduction to MDX Working with Data Sources and Data.

4. Source Views.

5. Creating and Working with Dimensions.

6. Creating and Working with Cubes.

I: ADVANCED TOPICS IN MDX, DIMENSIONS, CUBES, AND EXTENSIONS.

7. Advanced Topics in MDX.

8. Enhancements to Your Dimensions.

9. Enhancements to Your Cubes.

10. Extending MDX User Designed Functions.

II: ADMINISTRATION / INTEGRATION.

11. Administering Analysis Services.

12. Performance Optimization.

13. Data Mining.

14. Introduction to Integration Services.

15. Introduction to Supporting Services.

16. Client Components.

III: SEENARIOS.

17. Designing Real Time Cubes.

18. Securing Your Data in Analysis Services.

19. Updating Your UDM Data.