I have a series of share data sets that draw on SSAS Data Sources. These datasets have parameters, one of which is a list of companies. In the query designer I set the default for this parameter to "All" and when returning to the SSRS DataSet dialog, the parameter looks fine, with the correct default set like [Company].[Company].[All]. However If I close this dialog, then re-open it, the default has changed to an expression, which looks like this: "=new Object() {[Company].[Company].&[AU], [Company].[Company].&[CO], [Company].[Company].&[ND], [Company].[Company].&[NC], [Company].[Company].&[RA]}" This is the full enumerated list of the members of the .All level of the orginal query. If I change this back to the correct value and OK the dialog, then open it again it has gone back to the Object version. Of course none of this would be too bad if that version works, but it always causes an error when trying to render the report. The other thing I tried was to turn off the default value check box on these shared data sets, but if I do that, and OK the dialog, when re-opening the default check boxes are all set again. This is very frustrating and causing hours of lost time. What am I doing wrong that causes these behaviours? Is there an alternative solution? Tas Ranson

Hi Tas Ranson, Based on your information, I do a test in local in local environment using Product dimension, if I select [All Products], the parameter's default value in the shared dataset is [Product].[Category].[All Products], If I select Accessories and Bikes, the parameter's default value in the shared dataset is =new Object() {[Product].[Category].&[4], [Product].[Category].&[1]} ,no matter how many times I reopen this dialog box it always the same value. I am using the latest CU8 in SSRS 2008 R2, if possible, could you please install it and have a try. Generally, it does not recommend to Shared Dataset which retrieve data from cub, as it is not real shared. Why? please see: When you create an embedded data set based on a SSAS Cube that includes a parameter, a hidden dataset is automatically created that provides the parameter values. However, if the data set was created from a Shared Dataset the Hidden Dataset is not created when you add the shared dataset to the report. Even if the parameter is created, but the drop down list created on the report is empty since a dataset does not exist. So, if you do not want to write MDX to populate your parameters then you cannot use Share Datasets based on cubes. Thanks, Challen Fu Forum Support If you have feedback for TechNet Subscriber Support, please contact us Please remember to mark the replies as answers if they help and unmark them if they provide no help.