Chapter 1. Elementary MDX Techniques
In this chapter, we will cover the following recipes:
- Putting data on x and y axes
- Skipping axes
- Using a WHERE clause to filter the data returned
- Optimizing MDX queries using the NonEmpty() function
- Using the Properties() function to retrieve data from attribute relationships
- Basic sorting and ranking
- Handling division by zero errors
- Setting a default member of a hierarchy in the MDX script
Introduction
MDX is an elegant and powerful language, but also has a steep learning curve.
The goal of this chapter is to use some simple examples to demonstrate the fundamental MDX concepts, features, and techniques that are the foundations for further exploration of the MDX language.
The chapter begins with several basic techniques: ...
Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
