Book description
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
Table of contents
- List of Figures
- List of Tables
- Acknowledgements
- Introduction
- I. MDX Fundamentals
- II. MDX Functions
- III. MDX Applications
- Appendix
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft® SQL Server® 2008 MDX Step by Step
- Author(s):
- Release date: February 2009
- Publisher(s): Microsoft Press
- ISBN: 9780735626188
You might also like
book
Professional Microsoft® SQL Server® Analysis Services 2008 with MDX
When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale …
book
Microsoft® SQL Server® 2008 Analysis Services Step by Step
Teach yourself to use SQL Server 2008 Analysis Services for business intelligence one step at a …
book
MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition
Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, …
book
Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model
Build agile and responsive Business Intelligence solutions Analyze tabular data using the BI Semantic Model (BISM) …