The query contains the XXXXXName parameter, which is not declared. SSRS2008/MDX query

Question

Parser: The query contains the XXXXXName parameter, which is not declared. (msmgdsrv)

I have no idea why I keep getting this error. It occurs when I change the MDX in the query designer and trying OKing out of the query designer.

The strange thing is that the parameter DOES exist, I can see it in the parameters section of the dataset dialog. I am creating it before I do anything else with the query.

Answer 1

Although the seemingly intuitive thing to do is add the Parameter in the Dataset Properties window, this actually does not declare the parameter for the query for some odd reason.

To add the parameter, click the Parameters toolbar button in the Query Designer window. From there you can add your parameter names and default values.

Once you've done this, the global parameter list will contain that parameter and allow you to use expressions etc..