Microsoft SQL server 2005 analysis services /

Microsoft SQL server 2005 analysis services /

Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query languag MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as...

Full description

Saved in:
Bibliographic Details
Main Author: Melomed, Edward
Format: Electronic eBook
Language:English
Published: [Indianapolis, Ind.?] : Sams, 2006.
Subjects:
SQL server.
Client/server computing.
Relational databases.
Online Access:CONNECT
Table of Contents:
  • 1. What's new in analysis services 2005
  • 2. Multidimensional databases
  • 3. UDM : linking relational and multidimensional databases
  • 4. Client/server architecture and multidimensional databases : an overview
  • 5. Conceptual data model
  • 6. Dimensions in the conceptual model
  • 7. Cubes and multidimensional analysis
  • 8. Measures and multidimensional analysis
  • 9. Multidimensional models and business intelligence development studio
  • 10. MDX concepts
  • 11. Advanced MDX
  • 12. Cube-based MDX calculations
  • 13. Dimension-based MDX calculations
  • 14. Extending MDX with stored procedures
  • 15. Key performance indicators, actions, and the DRILLTHROUGH statement
  • 16. Writing data into analysis services
  • 17. Loading data from a relational database
  • 18. DSVs and object bindings
  • 19. Multidimensional models and relational database schemas
  • 20. physical data model
  • 21. Dimension and partition processing
  • 22. Using SQL server integration services to load data
  • 23. Aggregation design and usage-based optimization
  • 24. Proactive caching and real-time updates
  • 25. Building scalable analysis services applications
  • 26. Server architecture and command execution
  • 27. Memory management
  • 28. Architecture of query execution
  • calculating MDX expressions
  • 29. Architecture of query execution
  • retrieving data from storage
  • 30. Client/server architecture and data access
  • 31. Client components shipped with analysis services
  • 32. XML for analysis
  • 33. Adomd.Net
  • 34. Analysis management objects
  • 35. Security model for analysis services
  • 36. Object security model for analysis services
  • 37. Securing dimension data
  • 38. Securing cell values
  • 39. Using trace to monitor and audit analysis services
  • 40. Backup and restore operations
  • 41. Deployment strategies.

Similar Items