The short version of my question: Is there a way to prevent 2008 BI Studio from overwritingmy MDX parameter values query with its own auto-generated version?More detail if required:I am using Reporting Services 2008 Enterprise against a Analysis Services 2005 Enterprise cube (SP2).When I parameterise my data set, a Report Parameter is automatically created for me along with a new dataset to return the values for the parameter. I need to modify the MDX for retrieving the parameter values as it is not exactly what I need.My problem is that every time I turn my back, BI Studio keeps replacing my custom MDX Query with its own auto-generated one. This is a huge problem for me as the auto-genearted one returns AllMembers on a very large dimension and unless I change it back before previewing the report, it hangs.This was an occasional issue in 2005 if you weren't careful, but seems to happen all the time in 2008. EDIT: I see the pattern in the behaviour now. Whenever you change the query that uses the parameter, the other query that returns the valid values for the parameter select list is replaced by an autogenerated one. Is there a way to stop this happening?

This is a real hinderance on us moving from 2005 to 2008. Even if you don't know a solution, I would appreciate if there is anyone who can confirm that this is expected behaviour? I would think that anyone using Reporting Services 2008 to report from SSAS would find this a significant problem - or is it just me?

I am seeing the same behaviour and it's an issue. Have you reported this to Microsoft?Home page and blog: http://www.prologika.com/

Thanks for replying and confirming my fears. I am still using RS2008 and this issue is driving me crazy having to copy and paste all my queries back in again. I even tried fooling it by editing MDX in the RDL directly but as soon as the report reloads the fields collection, the parameter queries just get wiped again.Not sure how to report an issue. Maybe you could report it for me? Being a well known figure in theSQL world, I am sure your complaint will be taken more seriously. If you do come across a work around, please let me know. Thanks for your help.

There are no shortcuts but I am planning to submit this as a support case, as well as the issue that SSRS refreshes parameterswhen a parameter value is changed although theparameters are not dependent. BTW, the new Import feature in the BIDS 2008 Report Designer helps somewhat by letting you overwrite the changed dataset from another report definition. Home page and blog: http://www.prologika.com/

Until know I haven't noticed this behaviour, but right now it's driving me as crazy as the original poster. Is there some news on this topic? If there's already a report on the connect website please post the link to it. I have already deleted the rd:AutoGenerated and other rd-Tags from the RDL source, but without any success. I'm working with the Englisch version of Microsoft Visual Studio 2008 and Service Pack 1 (9.0.30729.1 SP). The Reportingt Services Designer has version number 10.0.2799.0. Thanks in advance and best regards, Gerald

Doing some further investigation I have found the following two blog entries which also led me to the corresponding report on Microsoft Connect (which was, btw, posted by Teo Lachev): Prevent SSRS 2008 from Overwriting Datasets Stop Reporting Services (SSRS) 2008 from overwriting custom Parameter Datasets MDX Query Designer Overwrites Parameter Queries (Microsoft Connect) The workaround to preserve changes is to modify the RDL source code as follows: <Query> ... <rd:SuppressAutoUpdate>true</rd:SuppressAutoUpdate> </Query> Best regards, Gerald