The request contains parameter XXXXXName, which is not declared. Request SSRS2008 / MDX

Parser: The request contains parameter XXXXXName, which is not declared. (Msmgdsrv)

I have no idea why I keep getting this error. This happens when I modify MDX in the query designer and try to make a conclusion from the query designer.

It is strange that the parameter exists, I see it in the parameters section of the data set dialog box. I create it before doing anything else with the request.

+4
source share
2 answers

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

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

Once you do this, the list of global parameters will contain this parameter and allow you to use expressions, etc.

+3
source

Is the parameter defined at the report level? Perhaps this is not so.

0
source

Source: https://habr.com/ru/post/1307116/


All Articles