http://www.sqlservercentral.com/blogs/sqldownsouth/2011/03/14/ssrs_3A00_--shared-dataset_2C00_-not-so-shared_210021002100_/

Printed 2014/04/19 11:10PM

SSRS: Shared DataSet, Not So Shared!!!

By Patrick LeBlanc, 2011/03/14

I was really excited about the concept of Shared DataSets when they were introduced.  My excitement diminished a little when I ran into a small issue.  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.

image

Thus creating a drop down list of available choices on the report.

image

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.  Therefore, the parameter is created, but the drop down list created on the report is empty since a dataset does not exist.

image

So, if you do not want to write MDX to populate your parameters then you cannot use Share Datasets based on cubes.  If you find a workaround for this please email me at pleblanc@pragmaticworks.com.

Talk to you soon,

Patrick LeBlanc, MVP, founder SQL Lunch


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.