Chapter 1. Elementary MDX Techniques
In this chapter, we will cover:
Putting data on x and y axes
Skipping axes
Using a WHERE clause to filter the data returned
Optimizing MDX queries using the
NONEMPTY()
functionUsing the
PROPERTIES()
function to retrieve data from attribute relationshipsBasic sorting and ranking
Handling division by zero errors
Setting a default member of a hierarchy in the MDX script