SSRS: Shared DataSet, Not So Shared!!!

Who is online?  0 guests and 0 members
Home  »  Blogs  »  PatrickLeBlanc  »  SSRS: Shared DataSet, Not So Shared!!!
 
0
/5
Avg: 0/5: (0 votes)

Comments (5)

jonmcrawford
jonmcrawford said:

Haven't fully used them yet because I'm not sure how my copy of the dataset will change the server 'shared' copy when I want to start from that template, but filter slightly, etc. SQLlunch topic?

3/14/2011
 · 
 
by
Daniel
Daniel said:

That's a bit frustrating.  Thanks for the heads up.

3/15/2011
 · 
 
by
arcanecode
arcanecode said:
3/17/2011
 · 
 
by
briankmcdonald

hmmm. Very interesting. I'll have to keep that in my back pocket for now. Have you put it on the special Microsoft site for MVP's? :)

3/18/2011
 · 
 
by
AllenSmith
AllenSmith said:

I create shared datasets for common, reusable report parameters.  In your example, I would create the embedded dataset and let SSRS create the hidden dataset.  Open the hidden datset, copy the MDX out to create a shared dataset for Fiscal Dates.  Delete both of the embeded datasets.  Then when you build reports, add both shared data sets (the report data and the date list).   Point your date paramter to the shared date dataset under 'Available Values'.   

Depending on the cube, it is sometimes faster to query the relational table for the date dim and use SQL text functions to build a list of MDX pointers for the parameters, but that's a separate article.

6/6/2011
 · 
 
by
Blogs RSS Feed

PatrickLeBlanc's latest blog posts

Blogs RSS Feed

Latest community blog posts