How to: Define Parameters in MDX and DMX Query Designer for Analysis Services (Report Designer)

To define a parameter in MDX or DMX query designer for Analysis Services

In Data view, in MDX or DMX query view, create a query that includes parameters. Parameter names must be in the form of @parameter.
Click the Query Parameters () button.
In Query Parameters, for Parameter, type the name of the parameter.

Note

This must match the name of the parameter specified in the query. Do not include the at (@) symbol. You must specify one parameter for each parameter in the query.
For Value, type a default value for the parameter.

Note

This value is used in the results view of the designer. If the query parameter is associated with a report parameter, you can change the default value of the report parameter independently of this value.
Use the up and down arrow buttons to move a parameter up or down in the list, and the delete () button to remove a parameter from the list.
Click OK.