Edit Parameter dialog

Use this dialog to change the way that the currently selected parameter item behaves. For example, you might want to changes the parameter's name, description, prompt, or default values.

For more information, see:

"What are parameters?"

"About using parameters"

What do you want to name this parameter?

Use this field to enter a descriptive name for the parameter. This name is displayed in the parameter list on the Parameter dialog. If you leave this box blank, Discoverer creates a default name for you.

This parameter is based on the item named

This read-only box displays the name of the item on which the parameter is based. If you want to create a parameter based on a different item, create a new parameter.

What prompt do you want to show other users?

Use this field to enter a question or instruction that describes the parameter value that the user should enter. This prompt is displayed on the Edit Parameter Value dialog. For example, 'What year do you want to look at?', or 'Please choose a region'. If you leave this box blank, Discoverer creates a default prompt for you.

What description do you want to show other users?

Use this field to enter a brief description of the parameter that tells users what the parameter is used for. This description is displayed on the parameter list on the Parameters dialog, and on the Edit Parameter Values dialog.

What default value do you want to give this parameter?

Use this field to enter the most commonly used parameter value as default on the Edit Parameter Values dialog. If users do not enter a value, the value that you enter here is used.

Let other users select multiple values?

Use this check box if you want users to be able to choose more than one value to match against the item.

Note: Clear this check box if you selected <NONE> from the Which item do you want to base your parameter on? drop down list. If a Discoverer end user enters more than one parameter value, only the first parameter value is used.

Do you want to allow different parameter values for each worksheet?

• Use the Allow only one set of parameter values for all worksheets radio button to make parameter values cascade across all worksheets in the workbook.

• Click the Allow different parameter values for each worksheet radio button to limit parameter values to the current worksheets.