MDX query for SSRS2008 parameter, to be used as filter in dataset
- by adolf garlic - SAVE BBC6MUSIC
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?