Friday, September 5, 2014

Debugging MDX queries

To put it simple, IT IS NOT POSSIBLE. I came across this tool http://www.sqlbi.com/tools/mdx-studio/ but it didn't help me a lot. What helped me was this article http://blogs.adatis.co.uk/blogs/jeremykashel/archive/2013/06/14/debug-mdx-with-generate.aspx which talks about using the Generate aggregate function to generate "logs".

It helped me find an incorrect sum in an mdx query, so I highly recommend this technique.

No comments: