MDX query for SSRS2008 parameter, to be used as filter in dataset

Posted by adolf garlic - SAVE BBC6MUSIC on Stack Overflow See other posts from Stack Overflow or by adolf garlic - SAVE BBC6MUSIC
Published on 2010-04-30T07:30:17Z Indexed on 2010/04/30 7:37 UTC
Read the original article Hit count: 319

Filed under:
|
|
|
|

What I want to do:

The report parameter that the user can select from is a subset of the data available in a dimension. I have a query to retrieve this subset and it works fine.

I am then trying to use the selection as a filter in a dataset.

In the dataset properties, you can add a parameter based on the ones you have specified on the report, but when you look in the filters pane, there seems to be no way to select this. If I try and select something in there, it creates a whole new parameter and dataset.

How can I get a dataset to consume and filter by a parameter that the user has selected?

© Stack Overflow or respective owner

Related posts about mdx

Related posts about ssrs