By: Devin Knight
Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all you need is the Query Designer to create a drag and drop datasets then it’s a piece of cake, but have you ever wondered what’s going on with all the MDX that the Query Designer creates. Or how about how do the parameters work that it creates inside MDX. I’ve heard many report writers that use Analysis Services as a data source (including myself) say it is too difficult to create parameters and that’s why they use the Query Designer.