Instructor Blogs

AmeriTeach

« Whitepaper- Analysis Services ROLAP for SQL Server Data Warehouses | Main | Resources for 6234 – SQL Server Analysis Services 2008 »
Tuesday
Aug242010

How to create or edit MDX Query text in Reporting Services dataset definition

A frequently-asked question in my SSRS and/or SSAS classes goes something like this: "How do I enter my own MDX query in an SSRS report rather than use the query builder?" While the GUI doesn't make it obvious, the answer is to use the Design Mode toggle button in the Query Designer:

Toggle Design Mode in SSRS MDX editor

WARNING: if you hand-edit the query statement, and then toggle the Query Designer button, your query text will be lost. Be careful! (Happily, the UI does provide a warning dialog box.) Update: for some reason, the graphic is being cut off, hiding the pointer to the toolbar button I'm depicting. Please use this link to see the full picture, until I can re-edit the post

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.