Table of Contents

1 Hello World - Easy Yet Effective Queries
2 Astrophysical - Playing with Dimensions
3 Families and Friends - Navigating Dimensions
4 Bring Order - Sorting Results
5 Slice, Dice, and Filter - Using Where and Filter
6 Using the Abacus - Introduction to Calculations
7 Is Time a Dimension? Working with Dates and Times
8 Clockwork - Calculations Using Dates and Times
9 Venn Diagrams - Visualizing and Manipulating Sets
10 Views on Cubes - Working with Subcubes
11 Not All There - Dealing with Empty Cells
12 Smiley Faces - Working with Key Performance Indicators (KPIs)
13 Hodgepodge - A Chapter of Miscellaneous Techniques
14 After You Finish

About the Author

Art Tennick has worked in relational database design and SQL queries for over 20 years, and in MDX queries for 10 years. He has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Recently, Art worked with several major retail and banking corporations to implement BI solutions using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2007/2010. His website is www.MrCube.net.