# Add query parameters to Analyzer reports To perform this task, log on to the User Console and open the Analyzer report you created in [Add Filters to an Analyzer Report](/pba/pentaho-analyzer-cp/adding-filters-to-an-analyzer-report/add-filters-to-an-analyzer-report.md). You can parameterize a query in Analyzer. Your parameter is a filter in Analyzer. Whenever this Analyzer report is run, users have a selection of columns to filter by. 1. Drag and drop the dimension member you want to create a parameter for onto the **Filters** canvas. 2. Select the level you want to set as the default parameter value, then click the right arrow to move it to the list on the right. 3. Click the check box at the bottom of the window, then enter a name for the parameter in the **Parameter Name** field. | Parameter Name | Description | | | ---------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------- | | **Include** |

Specifies values to inlcude using the member name.

Specifying the MDX unique name for parameter values on the secondary or lower hierarchy levels improves performance. This method precisely specifies the parameter value in cases where the same member name may appear with different parents.

You can also specify multiple values depending on how the report is run. For parameters in report URLs, you can repeat the parameter name and value.

For parameters in dashboards and scheduler, you can separate multiple values using the pipe " | " character. If a value contains the pipe character, then add double quotation marks around the value.

| | **Exclude** |

Specifies values to exclude using the member name.

Specifying the MDX unique name for parameter values on the secondary or lower hierarchy levels improves performance. This method precisely specifies the parameter value in cases where the same member name may appear with different parents.

You can also specify multiple values depending on how the report is run. For parameters in report URLs, you can repeat the parameter name and value.

For parameters in dashboards and scheduler, you can separate multiple values using the pipe " | " character. If a value contains the pipe character, then add double quotation marks around the value.

| | **Contains** | Specifies multiple values depending on how the report is run. For parameters in report URLs, you can repeat the parameter name and value. For parameters in dashboards and scheduler, you can separate multiple values using the pipe "\|" character. If a value contains the pipe character, then add double quotation marks around the value. | | | **Does not contain** | Specifies multiple values depending on how the report is run. For parameters in report URLs, you can repeat the parameter name and value. For parameters in dashboards and scheduler, you can separate multiple values using the pipe "\|" character. If a value contains the pipe character, then add double quotation marks around the value. | | | **Current**, **Next** and **Previous** | Cannot be parameterized. | | | **Next N Years** or \*\*N Years Ago \*\* | Accepts integer values. | | | **Before** and **After** | Accepts a single member name. | | | **Between** | Generates two query parameters with "\_START" and "\_END" suffixes that accept a single member name each. | | | **Greater / Less Than** | Accepts integer values. | | 4\. Click \*\*OK\*\*. ![Parameter example](/files/skXjaO7uRszgNy9kqX59) After you have created a parameter, you can generate a URL to share with users. You can use the following sample URL by customizing it with your server's name, user, report name, and parameter: ``` http://localhost:8080/pentaho/api/repos/%3Ahome%3Aadmin%3AAnalyzerFiltered.xanalyzer/editor?FYear_START=2003&FYear_END=2005 ``` --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.pentaho.com/pba/pentaho-analyzer-cp/advanced-topics/add-query-parameters-to-analyzer-reports-task-article.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.