Export (0) Print
Expand All
Expand Minimize

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

  1. In Data view, in MDX or DMX query view, create a query that includes parameters. Parameter names must be in the form of @parameter.

  2. Click the Query Parameters (Icon for the Query Parameters dialog box) button.

  3. In Query Parameters, for Parameter, type the name of the parameter.

    ms156303.note(en-US,SQL.90).gifNote:
    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.

  4. For Value, type a default value for the parameter.

    ms156303.note(en-US,SQL.90).gifNote:
    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.

  5. Use the up and down arrow buttons to move a parameter up or down in the list, and the delete (Delete) button to remove a parameter from the list.

  6. Click OK.

Community Additions

ADD
Show:
© 2015 Microsoft