BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« SSRS 2008: repeating headers | Main | PPS 2007: Add link to detail report to KPI in scorecard »

December 7, 2009

SSRS 2008: hidden parameter queries not right after editing dataset MDX query manually

One thing that really irritated me when working with SSRS reports is that if I created a custom MDX query after each change all hidden datasets for the parameters where overwritten.

For example is I had a DataSet called DataSet1 that used a certain parameter like region, this parameter was overwritten after changing the DataSet1 query but then without using the other parameters that sliced down the Region parameter.

I found out that this only happened when I was manually editing the MDX query for DataSet1 (mostly for adding member properties which is not supported by the query designer). So here is how I deal with it:

1. first I create the query with the designer, called for example DataSet1Design
2. before manually editing I create a 2nd dataset, called DataSet1Edit
3. I import the first dataset with the import function of the query designer selecting the same file I'm working on (don't forget to save it first)
4. I only edit the 2nd dataset manually with all modifications I need
5. After closing the designer all the hidden datasets for the parameters are overwritten wrongly
6. Just open the DataSet1Design query and press OK. All hidden datasets are recreated but now the way they should be

20091208 BdR: As David said in his comment; there is a better way to do this: http://blog.summitcloud.com/2009/12/suppress-auto-update-of-mdx-parameter-datasets-in-reporting-services-2008/

Thanks David. I will try this soon. Still my method can be usefull if you want the hidden queries to be regenerated if you alter your main MDX DataSet, but most of the time you just want the designer to leave your customizations alone.

Posted by Ben de Ridder at December 7, 2009 2:30 PM

Comments

That workaround is unnecessary.

You get deal with the hidden datasets using this method which applies native SSRS handlers:

http://blog.summitcloud.com/2009/12/suppress-auto-update-of-mdx-parameter-datasets-in-reporting-services-2008/

Posted by: David at December 7, 2009 2:10 PM

Wonderful goods from you, man. I've understand your stuff previous to and you're just too fantastic. I really like what you have acquired here, really like what you are saying and the way in which you say it. You make it enjoyable and you still care for to keep it wise. I can not wait to read much more from you. This is really a wonderful website.

Posted by: London escort girls at May 16, 2011 2:23 PM

Blog is very good quality, would maintain the level and comes to the top of google.

Posted by: escort London agency at May 17, 2011 1:18 AM

Post a comment




Remember Me?