Microsoft SQL Server 2008 Mdx Step by Step
by Smith, Bryan; Clay, C.Edition: 1st
Format: Paperback
Pub. Date: 2009-02-25
Publisher(s): Microsoft Press
Other versions by this Author
List Price: $49.99
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
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. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.