I have an SSRS report. I created it using BIDS and it uses a Sql Server Analysis Service data source. The data source query is an MDX query with one parameter: @region, a default value has been set for this parameter. The value which @region takes looks like [USA].[Northeast].[New Hampshire].[Coos County].
The MDX query goes like this:
This report runs properly inside BIDS or through web browser after deployment. In my report manager at http://localhost/Reports, I am able to view this report by selecting the value for the @region parameter from a dropdownlist, which contains such values as
I know that we can pass query parameters to SSRS through the URL. I have successfully done so with relational database which uses regular SQL. But, I have not succeeded in passing this @region parameter of my MDX query through the URL.
I tried the following:
View Complete Post