How to create or edit MDX Query text in Reporting Services dataset definition
Posted: July 1, 2011 Filed under: Business Intelligence, Reporting Services | Tags: SSRS MDX SSAS Leave a comment »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:
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.)
