Using Dynamic MDX in Reporting Services
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 control over the sets that you want to add to the rows axis by using set functions.
- Add query-scoped named sets to the query in addition to calculated members. (Calculated members can also be added in the graphical query designer, but not named sets.)
- Build dynamic MDX queries.