Create a cascading list prompt

Pentaho Business Analytics
Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA004-17
A cascading prompt changes based on the value a user selects. For example, when the value in the drop-down list Country changes, this prompt is automatically applied to the second prompt, City, which changes its values.

This task uses the example of creating a country-city cascade prompt.
Cascading prompt example

  1. For Type, select Metadata List to create the drop-down prompt Country.

    Filter from metadata list
  2. For Type, select SQL List which includes a parameter, ${selected_country}, in its associated query for the check box prompt City.

    Filter from SQL list
  3. Set the Default Value for the selected_country parameter to USA with New York City (NYC) as the initially selected value for the check box prompt.
To link the City prompt to the Country prompt, another Source for the selected_country parameter was chosen. The alternate source is the Country prompt. When the prompts are linked, users can choose a country and then choose a city (or cities) in the country of their choice.

Using this example, the report designer can now add a data table, chart, or other content in the dashboard which can be driven by the prompt he or she just created. If the designer adds a pie chart to the dashboard, the pie chart will display the percentage of sales per city. In the Query Editor, the report designer creates a parameter, {City}, with an extended default value: NYC|Las Vegas. The resulting pie chart displays values for New York City and Las Vegas. Under the Parameters tab associated with the pie chart, the Source value for the City parameter is changed to the City prompt.

When the report is saved, users of the dashboard can see results for a country and multiple cities in that country.