Creating chart or data table parameters

Pentaho Business Analytics

Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA004-17

To create a parameter, in the Value field, enter the name of the parameter inside curly braces, as in {Parameter Name}. In the example below, the designer created a parameter called {TERRITORY}; the default value, or source, for the parameter is NA (North America). When a chart or data table renders, it displays data associated with North America. Remember that this a default value. When you enclose a parameter name with curly braces, you are creating a parameter query, which means that users can change the query dynamically by replacing the default value NA with a different territory acronym, (for example, EMEA), when the query runs.
Filter parameter example

You can define multiple default parameter values by adding a pipe character (|) between the values, as in NA|EMEA|APAC.

Suppose a dashboard designer chooses to limit the data to North America (NA) exclusively? In this instance, he or she would not include the curly braces around NA (as shown in the example below), and Default (value) is disabled. This is an example of a static query.
Static query