Microsoft SQL Server 2008 MDX Step by Step

Microsoft SQL Server 2008 MDX Step by Step

4.11 - 1251 ratings - Source

Teach yourself the Multidimensional Expressions (MDX) query languagea€”one step at a time. With this practical, learn-by-doing tutorial, youa€™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 CD features: Practice exercises Database and code samples Fully searchable eBookA quick (manual) inspection of the absolute difference between these two values reveals that the products are infact sorted per the expression in the Order function , even though that value is not present in the cell set. Use the Order function toanbsp;...

Title:Microsoft SQL Server 2008 MDX Step by Step
Author:Bryan Smith, C. Clay
Publisher:Pearson Education - 2009-02-25


You Must CONTINUE and create a free account to access unlimited downloads & streaming