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 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 "Edit Parameter Values dialog". If you leave this field blank, Discoverer creates a default name for you.
This parameter is based on the item named
This read-only field displays the name of the item on which the parameter is based. To create a parameter based on a different item, create a parameter.
If this field displays <NONE> it can be used to provide input to a calculation. For example, <NONE> might be used in a parameter to enable worksheet users to enter a value to choose how much percentage increase they want to display on a worksheet.
What prompt do you want to show for this parameter?
Use this field to enter a question or instruction that tells users what information they must enter when choosing a parameter value. This prompt is displayed on the "Edit Parameter Values dialog". For example, 'What year do you want to look at?', or 'Please choose a region'. If you leave this field blank, Discoverer creates a default prompt for you.
What description do you want to show for this parameter?
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 "Edit Worksheet dialog: Parameters tab", and on the "Edit Parameter Values dialog".
Do you want to allow different parameter values for each worksheet?
Use the Allow only one set of parameter values for all worksheets option to make the same set of parameter values apply to all worksheets in the workbook.
Use the Allow different parameter values for each worksheet option to enable different parameter values to be specified for each worksheet.
Require users to enter a value
Use this check box to make users enter a parameter value before Discoverer displays the worksheet.
Enable users to select multiple values?
Use this check box if you want users to be able to choose multiple values to match against the item.
Note: Clear this check box if <NONE> is displayed in the This parameter is based on the item named field. If a Discoverer end user enters multiple parameter values, only the first parameter value is used.
Enable users to select either indexes or values
Use this check box to enable users to choose whether they want to display parameter values with indexes (for example, (1) January, (2) February) or without (for example, January, February) in the "Edit Parameter Values dialog".
Use this check box as follows:
Select this check box when you want worksheet users to be able to choose whether to display parameter values with or without indexes.
Clear this check box when you want parameter values to always be displayed without indexes.
Note: The Enable users to select either indexes or values check box is only available if indexes have been set up by the Discoverer manager.
For more information, see "About using indexes and values in parameters".
What default value do you want to give this parameter?
Use this field to enter a default value for the parameter on the Edit Parameter Values dialog. If users do not enter a value in the Edit Parameter Values dialog, the value that you enter here is used.
Use the <Index and Value> drop down list (where available) to display default parameter values with indexes (for example, (010) January, (011) February) or without indexes (for example, January, February). For more information about using the <Index and Value> drop down list, see the "Edit Parameter Values dialog".
Note: You determine whether the <Index and Value> drop down list is displayed here, using the Enable users to select either indexes or values check box.
Hint: For date items, click on the calendar icon to the right of the field to specify a date using the graphical "Calendar dialog". If no calendar icon is displayed, click the down arrow to the right of the field and choose Select From Calendar to display the "Calendar dialog".
Note: If Discoverer Plus end users use the word TODAY as the default value of a parameter (for example, to convert to today's date using a DECODE statement in a calculation), they must surround the word in single quotes (that is, 'TODAY'). If TODAY is not surrounded by single quotes, Discoverer interprets the word as a literal value and displays the error message:
- ORA-01858: a non-numeric character was found where a numeric was expected
Do you want to filter the list of values for this parameter?
Use these settings to create cascading parameters in a worksheet. For example, you might have a parameter for Region and a parameter for City. If an end user selects the East region as a parameter value, you might want the LOV for the City parameter to display only cities in the East region.
Use the Show all available values option to display all available parameter values to the user.
Use this option when you do not want to set up a cascading parameter.
Use the Filter the list of values based on the selected conditions option to activate a list of conditions below.
Use this option when you want to set up a cascading parameter by selecting a condition from the <conditions> list below.
For an example, see "About filtering lists of parameter values based on selected conditions (cascading parameters)".
Use the check boxes in the <conditions> list to select one or more conditions to apply to the list of values for this parameter.
For example, when you create a parameter on City you might select the check box next to Region=:ChooseRegion in the <conditions> list to display only cities in the selected region.
When you click a check box in the <selected conditions> list, Discoverer might display a warning symbol indicating that applying this condition might degrade query performance.
Note: The check boxes in the <conditions> list are only available when you select the Filter the list of values based on the selected conditions option.
To enter the literal value of a reserved word in the What default value do you want to give this parameter? field, place single or double quotes around the word. For example, enter "NULL" to find database text values that contain the text NULL. If you enter NULL (that is, without quotes), Discoverer displays null values.