What are parameters?

Parameters are workbook items that allow Discoverer users to analyze worksheets by entering dynamic input values (see figure below). Input values are typically used to:

• provide input to conditions that are used to filter worksheets - for example, when a workbook or worksheet is opened or refreshed, the parameter is used to first ask the worksheet user 'What month do you want to analyze?'. A worksheet user can choose to look at data for the month of January only.

• provide input to calculations - for example, a worksheet user can enter the value '3' when prompted, which is then used to divide data into three bands using a predefined calculation containing a banding function (see "About using parameters to collect dynamic user input")

Figure 11-1 Parameters dialog used to set parameters

Description of the illustration d_par1.gif