Skip to main content

Pentaho+ documentation is moving!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Add query parameters to Analyzer reports

Parent article

To perform this task, log on to the User Console and open the Analyzer report you created in Add Filters to an Analyzer Report.

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.

Procedure

  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 NameDescription
    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.

    ContainsSpecifies 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 containSpecifies 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 PreviousCannot be parameterized.
    Next N Years or N Years Ago Accepts integer values.
    Before and AfterAccepts 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

Next steps

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