Professional SQL server analysis services 2005 with MDX
(eBook)

Professional SQL Server Analysis Services 2005 with MDX; About the Authors; 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 Analysis Services 2005; A Closer Look at Data Warehousing; Key Elements of a Data Warehouse; Inmon Versus Kimball Different Approaches; Business Intelligence Is Data Analysis; Analysis Services 2005; The Unified Dimensional Model; Summary

Chapter 2 First Look at Analysis Services 2005Differences between Analysis Services 2000 and Analysis Services 2005; Upgrading to Analysis Services 2005; Using the 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 Query; MDX Expressions; Operators; MDX Functions; Summary; Chapter 4 Working with Data Sources and Data Source Views; Data Source; Data Source Views; Data Source Views in Depth; Multiple Data Sources within a DSV; Summary

Chapter 5 Dimension DesignWorking with the Dimension Wizard; Working with the Dimension Editor; 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 Cube Wizard; Cube Dimensions; Measures and Measure Groups; Calculated Members; Creating Perspectives; Creating Translations; Browsing Perspectives and Translations; Summary; Part II Advanced Topics

Chapter 7 Advanced Topics in MDXCalculation Fundamentals; Restricting Cube Space/Slicing Cube Data; Removing Empty Cells; Filtering Members on Axes; Ranking and Sorting; Parameterize Your Queries; New MDX Functions; Summary; 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 CubeKey Performance Indicators (KPIs); Drill-Through; Actions; Adding Intelligence to the Cube; Working with Partitions; Defining Security; Summary; Chapter 10 Extending MDX using External Functions; COM User Defined Functions; Built-in COM UDFs; .NET User Defined Functions (Stored Procedures); COM UDFs vs. NET Assemblies; Summary; Part III Administration, Performance Tuning Integration; Chapter 11 Updating Your UDM Data; Updating Dimension Data in UDM; Updating Your Cube Data; Summary; Chapter 12 Administering Analysis Services