Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster. Topics covered will include:
* Everything there is to know about solve order and its quirks
* Inline named sets and the problems only they can solve
* Using the UnOrder() function to optimise calculations
* Subselects: what they do, when to use them and how they interact with MDX calculations
* Useful connection string properties and their effects
... and lots more!
Presented by Chris Webb at SQLBits XV
Slide Deck 52 KB
Demo Code 13 KB