Professional Sql Server Analysis Services 2005 With MDX

Shows how Analysis Services and MDX can be used to build data warehouses and multidimensional databases. This book describes the development processes for building dimensions and cubes from various data sources. It demonstrates a variety of techniques in real-world scenarios and shows how MDX can be used for analysis of business problems.

List 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.

Product details

• Authors: Sivakumar Harinath, Sivakumar Quinn Harinath, Stephen R. Quinn
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 30.05.2006
• EAN: 9780764579189
• ISBN: 978-0-7645-7918-9
• No. of pages: 864
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > IT