"T-SQL Tuesday #005" MDX and SSRS
Okay, so this is my first entry into the T-SQL Tuesday series (If you want to know more check here) and this months topic, Reporting, is a topic that is frequently on my mind.
This is going to be more of a rant than anything else, but I will outline my workaround towards the end of the post.
What really gets my goat about SSRS design in BIDS is the total inability of it to handle MDX queries natively. By this I mean that you cannot use the really sweet Report design wizard to get your basic layout set up.