Edit Worksheet dialog: Parameters tab

Use this tab to specify parameters for the current worksheet. This tab displays a list of existing parameters available to the worksheet. Use this tab to manage existing parameters and create new parameters.

For more information, see:

"What are parameters?"

"About using parameters"

"About designing workbooks for maximum performance".

Available parameters

This list shows which parameters are available to the current worksheet and enables you to create, edit, and delete parameters. The check box next to each parameter indicates whether it is activated (i.e. turned on) or not. Activate and de-activate parameters as follows:

• If the parameter is included in a condition, display the Conditions tab and select the check box next to the condition containing the parameter, then click OK to close the dialog.

• If the parameter is included in a calculation, display the Calculation tab and select the check box next to the calculation containing the parameter, then click OK to close the dialog.

Description

This field displays the formula of the currently selected parameter.

New

Use this button to display the New parameter dialog (see "New Parameter dialog"). Use the New parameter dialog to create new parameters.

Edit

Use this button to display the Edit parameter dialog (see "Edit Parameter dialog"). Use the Edit parameter dialog to edit the currently selected parameter.

Delete

Use this button to permanently remove the selected parameter.

Note: When you remove parameters, you also remove items that are dependent on the parameter (e.g. calculations, conditions). For example, if the parameter that you delete is used in a worksheet calculation, the calculation is also removed.

Move Up

Use this button to change the order of the parameter currently selected in the View parameters for list. Click this button to move the item one position up the list.

Move Down

Use this button to change the order of the parameter currently selected in the View parameters for list. Click this button to move the item one position down the list.

Options

Use this button to display the Options dialog. Use the Options dialog to specify:

• how Discoverer handles queries (see "Options dialog: Query Governor tab")

• how Discoverer formats worksheets (see "Options dialog: Sheet Format tabs")

Notes

• To remove a parameter from a worksheet without deleting the parameter, hide the parameter using the View parameters for drop down list.

• You are not allowed to delete parameters created for you by the Discoverer manager.