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.
See Also
Concepts
Using Analysis Services MDX Query Designer in Query Mode
Using Analysis Services DMX Query Designer
Report Designer How-to Topics