9780735626188

Microsoft SQL Server 2008 Mdx Step by Step

by ;
  • ISBN13:

    9780735626188

  • ISBN10:

    0735626189

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2/25/2009
  • Publisher: Microsoft Press
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $2.00
  • eBook
    $47.99
    Add to Cart

    DURATION
    PRICE

Supplemental Materials

What is included with this book?

  • The eBook copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Summary

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 CD features: Practice exercises Database and code samples Fully searchable eBook

Author Biography

Bryan C. Smith is an architect with Hitachi Consulting, where he implements data warehouse solutions with SQL Server. He also leads Analysis Services and MDX training courses, participates in the Analysis Services forums on MSDN, and is coauthor of Professional SQL Server 2008 Reporting Services.

Table of Contents

List of Figures
List of Tables
Acknowledgements
Introduction
MDX Fundamentals
Welcome to MDX
Using the MDX Query Editor
Understanding Tuples
Working with Sets
Working with Expressions
MDX Functions
Building Complex Sets
Performing Aggregation
Navigating Hierarchies
Working with Time
MDX Applications
Enhancing the Cube
Implementing Dynamic Security
Building Reports
Appendix : Appendix
Table of Contents provided by Publisher. All Rights Reserved.

Rewards Program

Write a Review