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 queriesWork with tuples, sets, and expressionsBuild complex sets to retrieve the exact data users needPerform aggregation functions and navigate data hierarchiesAssemble time-based business metricsCustomize an Analysis ...
Read More
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 queriesWork with tuples, sets, and expressionsBuild complex sets to retrieve the exact data users needPerform aggregation functions and navigate data hierarchiesAssemble time-based business metricsCustomize an Analysis Services cube through the MDX scriptImplement dynamic security to control data accessDevelop MDX-driven reports in SQL Server Reporting Services CD features: Practice exercisesDatabase and code samplesFully searchable eBook
Read Less
