How can I build MDX statement as a string and pass it into Reporting Services?

Written by Vidas Matelis. Posted in Reporting Services FAQ

Q: How can I build MDX statement as a string and pass it into Reporting Services?

A: At first use Query Builder to create initial MDX statement. Then select button "..." that is close to data set. This button will allow you to Edit Selected Dataset. In MDX Query String box you can change MDX statement to string:

="SELECT [Measures].[Orders Count] ON 0 FROM " & "[Adventure Works]"

Tags: mdx, faq, ssrs