Skip to main content
Pentaho Documentation

Simple Metadata Output Parameterization

This procedure requires a Metadata data source type. Establish this data source and a query before continuing with the instructions below.

You can add dynamic interactivity to a published report such that when a user executes or views it, he can specify how to constrain certain parts of the query data. This is called parameterization. Follow the procedure below to parameterize a Metadata-based report.

  1. Open the report you want to parameterize.
  2. Right-click the Parameters item in the Data pane, then select Add Parameter... from the context menu. The Add Parameter dialogue will appear.
  3. Select or change the options according to the definitions specified in Simple SQL Output Parameterization.
  4. Edit your query and add the columns you want to parameterize to the Conditions field.
  5. Create a parameter token in the Value field of each row in the Conditions area, and a valid default value in the Default field. Parameter tokens are in {braces} and do not contain spaces.
  6. Click OK to save the query.
  7. Include the parameterized fields in your report by dragging them onto the canvas.
  8. Publish or preview the report.
When a user runs this report, he will be presented with an interactive field that specifies an adjustable constraint for the column or columns you specified.