Professional Microsoft SQL Server Analysis Services 2008 with MDX -- About the Authors -- Credits -- Acknowledgments -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- p2p.wrox.com -- Part I: Introduction -- Chapter 1: Introduction to Data Warehousing and SQL Server 2008 Analysis Services -- A Closer Look at Data Warehousing -- Key Elements of a Data Warehouse -- Inmon Versus Kimball - Different Approaches -- Business Intelligence Is Data Analysis -- Microsoft Business Intelligence Capabilities -- SQL Server Analysis Services 2008 -- The Unified Dimensional Model -- Summary -- Chapter 2: First Look at Analysis Services 2008 -- Differences between Analysis Services 2000, Analysis Services 2005, and Analysis Services 2008 -- Upgrading to Analysis Services 2008 -- Using Business Intelligence Development Studio -- Using SQL Server Management Studio -- Querying Using the MDX Query Editor -- Summary -- Chapter 3: Introduction to MDX -- What Is MDX? -- Fundamental Concepts -- MDX Queries -- MDX Expressions -- Operators -- MDX Functions -- Summary -- Chapter 4: Working with Data Sources and Data Source Views -- Data Sources -- Data Source Views -- Data Source Views in Depth -- Multiple Data Sources within a DSV -- Summary -- Chapter 5: Dimension Design -- Working with the Dimension Wizard -- Working with the Dimension Designer -- Browsing the Dimension -- Sorting Members of a Level -- Optimizing Attributes -- Defining Translations in Dimensions -- Creating a Snowflake Dimension -- Creating a Time Dimension -- Creating a Parent-Child Hierarchy -- Summary -- Chapter 6: Cube Design -- The Unified Dimensional Model -- Creating a Cube Using the Cube Wizard -- Cube Dimensions -- Measures and Measure Groups -- Calculated Members.

Creating Perspectives -- Creating Translations -- Browsing Perspectives and Translations -- Summary -- Chapter 7: Administering Analysis Services -- Administration Using SQL Server 2008 Tools -- Online Mode -- Summary -- Part II: Advanced Topics -- Chapter 8: Advanced Dimension Design -- Custom Rollups -- Enhancements to Parent-Child Hierarchies -- Using Properties to Customize Dimensions -- Dimension Intelligence Using the Business Intelligence Wizard -- Server Time Dimension -- Dimension Writeback -- Summary -- Chapter 9: Advanced Cube Design -- Measure Groups and Measures -- Adding and Enhancing Dimensions -- Adding Calculations to Your Cube -- Key Performance Indicators (KPIs) -- Drillthrough -- Actions -- Adding Intelligence to the Cube -- Working with Partitions -- Defining Security -- AMO Warnings -- Summary -- Chapter 10: Advanced Topics in MDX -- Calculation Fundamentals -- Restricting Cube Space/Slicing Cube Data -- Removing Empty Cells -- Filtering Members on Axes -- Ranking and Sorting -- Parameterize Your Queries -- MDX Functions -- Summary -- Chapter 11: Extending MDX Using External Functions -- Built -In UDFs -- .NET User-Defined Functions (Stored Procedures) -- COM User-Defined Functions -- COM UDFs versus .NET Stored Procedures -- Summary -- Chapter 12: Data Writeback -- Dimension Writeback -- Cell Writeback -- Summary -- Part III: Advanced Administration and Performance Optimization -- Chapter 13: Programmatic and Advanced Administration -- Analysis Management Objects (AMO) -- Resource and Activity Monitoring -- HTTP Connectivity to Analysis Services -- Analysis Services and Fail-Over Clustering -- Summary -- Chapter 14: Designing for Performance -- Optimizing UDM Design -- Optimizing for Processing -- Designing Aggregations -- Managing Aggregation Designs -- Scalability Optimizations -- Summary.

Chapter 15: Analyzing and Optimizing Query Performance -- The Calculation Model -- Query Execution Architecture -- Performance Analysis and Tuning Tools -- Analyzing Query Performance Issues -- Query Optimization Techniques -- Scale Out with Read-Only Database -- Writeback Query Performance -- Summary -- Part IV: Integration with Microsoft Products -- Chapter 16: Data Mining -- The Data Mining Process -- Real-World Applications -- Data Mining Algorithms in SQL Server Analysis Services 2008 -- Working with Mining Models -- Summary -- Chapter 17: Analyzing Cubes Using Microsoft Office Components -- Analyzing Data in Excel 2007 -- ProClarity -- Microsoft Performance Point Server 2007 -- Summary -- Chapter 18: Using Data Mining with Office 2007 -- Configuring Your SSAS -- Table Analytics -- Data Mining Tools -- Visio Add-In -- Summary -- Chapter 19: Integration Services -- Creating an Integration Services Project -- Creating Integration Services Packages for Analysis Services Operations -- Automating Execution of SSIS Packages -- Summary -- Chapter 20: Reporting Services -- Report Designer -- Report Server -- Creating a Report on a Relational Database -- Creating Reports Based on a UDM -- Managing Your Analysis Services Reports -- Ad-Hoc Reports Using Report Builder -- Summary -- Part V: Scenarios -- Chapter 21: Designing Real-Time Cubes -- Proactive Caching -- Proactive Caching at Work -- Long Latency Scenario -- Average Latency Scenario -- No Latency Scenario -- Summary -- Chapter 22: Securing Your Data in Analysis Services -- Securing Your Source Data -- Securing Your Dimension Data -- Securing Your Cube Data -- Summary -- Chapter 23: Inventory Scenarios -- Inventory Control and Orders -- Forecasting -- Understanding Inventory -- Summary -- Chapter 24: Financial Scenarios -- Presenting Budget Information -- Currency Conversion Scenario (m:n).

Precision Considerations -- Employee Scenario (P/C) -- Custom Rollup Scenarios -- Summary -- Chapter 25: Web Analytics -- What Is Web Analytics? -- Collecting Data -- Transforming Web Log Data -- Step-by-Step Guide -- Summary -- Appendix A: MDX Functions -- Index.