• Thank you, thank you, thank you!

    I have looked over so many books and sites that try to teach MDX and none have simplified it like this article.

    For some reason every other guide tells you to forget everything that you know about T-SQL and instead they start off with the theory of cubes and how to write MDX queries based on cube theory. While it is important to understand how a dimensional model works, there would be a lot more buy-in on MDX if they would instead show how a SQL query would be written in MDX. Then they could explain the dimensional concepts while they show the query differences. Just as this article does. Every single SQL server developer who wants to learn MDX immediately tries to turn standard SQL queries into MDX. So why not teach MDX this way? I will be using this document now as a training resource since it makes so much sense.

    Thanks again and I look forward to more articles on this subject!