I have several reports where I have to write the MDX by hand and when I save the report, it spends about 10 minutes doing "Query Preparation" (for a query that runs in less than a second). It seems to be spending all its time in SSAS doing DISCOVER statements. Is there a way to disable this? Ctrl-C is not the solution I'm looking for as it has its own issues and sometimes takes forever to respond as well. As a way around this, I tried making the MDX just a Text expression by coding it as: ="SELECT xxx ...." but that fails. Is there a way to put the MDX in the query text so that it is evaluated at runtime but will bypass the query preparation process? I don't mind managing the fields and parameters manually. Finally, is there anything I can do on SSAS to speed up the DISCOVERY process?

Hi Trent Ballew, Thanks for your question, based on your scenario, I think you can disnable the button of Auto Execute which used to switch between viewing results on demand or deferring query execution until explicitly requested. By default,Auto Execute is enabled when you open the query designer. Please remember to mark the replies as answers if they help and unmark them if they provide no help.