文件名称：Microsoft SQL Server 2008 Analysis Services Step by Step Apr 2009
文件大小：16.18MB
文件格式：PDF
更新时间：2013-04-21 04:47:30
SQLServer2008 Analysis Services
Teach yourself to use SQL Server 2008 Analysis Services for business intelligence—one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you’ll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author’s own, professional techniques—direct from the companion Web site. Contents at a Glance Part I Understanding Business Intelligence and Analysis Services 1 Business Intelligence: A Data Analysis Foundation ……………1 2 Understanding OLAP and Analysis Services ……………………… 23 3 Accessing Source Data …………………………………………………37 Pa rt I I Design Fundamentals 4 Creating Dimensions ……………………………………………………57 5 Creating a Cube …………………………………………………………101 6 Creating Advanced Measures and Calculations ……………………139 7 Advanced Dimension Design ……………………………………………177 Part III Advanced Design 8 Working with Account Intelligence ……………………………197 9 Currency Conversion and Multiple Languages …………………215 10 Interacting with a Cube……………………………………………233 11 Retrieving Data from Analysis Services ………………………257 12 Implementing Security………………………………………………293 13 Designing Aggregations ……………………………………………313 Part Iv Production Management 14 Managing Partitions and Database Processing ………………341 15 Managing Deployment ………………………………………………371 16 Advanced Monitoring and Management Tools ……………………385