Examples of parameters

This section contains examples of using parameters in Discoverer.

Example 1: Using a parameter to filter a worksheet

In this example you want worksheet users to be able to select which region's data they want to analyze. In the figure below, the value Central is entered in the Edit Parameter Values dialog. This displays only data for the Central region on the worksheet.

Figure 11-3 A parameter value being used to filter a worksheet

Description of the illustration param11.gif

Example 2: Using a parameter that enables multiple values to filter a worksheet

In this example you want worksheet users to select more than one region with which to analyze data. In the figure below, the values Central and East are entered at the Edit Parameter Values dialog. This displays only data for the Central and East region on the worksheet.

Figure 11-4 A parameter enabling multiple values being used to filter a worksheet

Description of the illustration param3.gif

Example 3: Using a parameter to collect dynamic user input

In this example you might want worksheet users to be able to select how many bands worksheet data is arranged into. When the value '2' is entered, the Profit SUM figures are placed into two bands.

Figure 11-5 A parameter used to provide dynamic input to a banding calculation

Description of the illustration param10.gif