Now that you understand the fundamentals of cube design, it’s time to learn how to query them. This unit will introduce you to the basics of using SQL Server 2008 R2 Analysis Services Multi-Dimensional Expressions (MDX) to develop powerful queries against your cubes. You will also learn how to use MDX to enhance the design of your cubes with calculated members, named sets and key performance indicators (KPIs).
Hands-On Labs
Videos
Presentation: Introduction to SQL Server 2008 R2 Analysis Services MDX
This presentation provides an introduction to SQL Server 2008 R2 Analysis Services MDX. MDX stands for "multi-dimensional expressions", and is used to write queries, formulas and calcuations for performing multi-dimensional analysis and reporting. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Exploring SQL Server 2008 R2 Analysis Services MDX Query Techniques
This presentation explores query techniques used in SQL Server 2008 R2 Analysis Services MDX, including defining an axis, creating a set, set manipulation, using functions and keywords, asymmetrical queries and cell properties. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Introducing SQL Server 2008 R2 Analysis Services MDX Query Development
This demonstration introduces simple SQL Server 2008 R2 Analysis Services MDX query statements. MDX, or Multi-Dimensional eXpressions, makes it easy to perform powerful analytic queries and calculations against cube data. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Presentation: Exploring SQL Server 2008 R2 Analysis Services Cube Calculations
This presentation covers calculations and formulas in SQL Server 2008 R2 Analysis Services. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
Demo: Enriching a SQL Server 2008 R2 Analysis Services Cube with Calculations
This demo shows how to enrich a SQL Server 2008 R2 Analysis Services cube with calculated members, named sets and key performance indicators (KPIs). These calculations make it possible to incoporate consistent business rules in a Unified Dimensional Model. Presenter: Peter Myers, Mentor, Solid Quality Mentors.