Another PASS Summit has come and gone, and a good time was had by all. The song at the opening keynote sums up the experience quite nicely, ''Simply the Best.'' My favorite quote of the week comes from Andy Leonard (blog| twitter) who tweeted on November 9, ''#sqlpass is a family reunion. :{>'' Oddly enough, Andy is one of the few people that I ...

In this post, I continue my exploration of approaches to working with dynamic MDX in a Reporting Services dataset when you are using Analysis Services as a data source. I began this series with a look at string conversion functions in Part 1. In Part 1, the dynamic MDX relied on parameters that work as a filter on the query results. But what if ...

If you're using Analysis Services as a data source for Reporting Services reports, you can build a simple dataset using the graphical query designer, but you'll want to switch to the generic query designer to create the MDX query string manually when you have more advanced requirements. Using the generic query designer, you can:· Impose greater ...