文件名称：Microsoft SQL Server 2008 MDX Step by Step Feb 2009
文件大小：18.27MB
文件格式：PDF
更新时间：2013-04-21 10:07:11
SQLServer2008 MDX
Microsoft SQL Server 2008 MDX Step by Step Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: Construct and execute MDX queries Work with tuples, sets, and expressions Build complex sets to retrieve the exact data users need Perform aggregation functions and navigate data hierarchies Assemble time-based business metrics Customize an Analysis Services cube through the MDX script Implement dynamic security to control data access Develop MDX-driven reports in SQL Server Reporting Services Contents at a Glance Part I MDX Fundamentals 1 Welcome to MDX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2 Using the MDX Query Editor. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 3 Understanding Tuples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 4 Working with Sets. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 5 Working with Expressions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 Part II MDX Functions 6 Building Complex Sets. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123 7 Performing Aggregation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 8 Navigating Hierarchies. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 9 Working with Time. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 Part III MDX Applications 10 Enhancing the Cube. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239 11 Implementing Dynamic Security . . . . . . . . . . . . . . . . . . . . . . . . . 273 12 Building Reports. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 311