in

jetlounge

the minty fresh blog that whitens your teeth!


Syndication


Suppress Auto Update of MDX Parameter Datasets in Reporting Services 2008

by David Leibowitz | June 25, 2009 | Comments: 1

 

 

With the MDX Query Designer in SSRS 2008 Report Designer and Report Builder 2.0, changing the main dataset overwrites the parameter datasets, which will kill any manual adjustments made. Bummer.

The hack to fix is to add a SuppressAutoUpdate =true to the parameter dataset:

<Query>

<DataSourceName>DataSource1</DataSourceName>

<CommandText> …

<rd:SuppressAutoUpdate>true</rd:SuppressAutoUpdate>

<rd:Hidden>false</rd:Hidden>

</Query>

del.ico.us digg this technorati BlinkList Furl reddit DotNetKicks google! live Facebook Stumble Upon Yahoo!



Comments

 

MS BI Consultant said:

Hi David,

Thanks for the tip. That was very helpful.

Iman

May 19, 2010 10:43 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
Powered by Community Server (Non-Commercial Edition), by Telligent Systems