22-25 April 2026 
Advanced MDX Tips And Tricks
2016TL; DR
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.
Session Details
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!
* 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!