---

Edit Parameters page

Use this page to specify parameter values. Parameter values are typically used to:

• provide input to conditions that are used to filter worksheets (e.g. when prompted to choose a month, you might enter January to analyze January data only)

• provide input to calculations (e.g. when prompted to choose a rolling average value, you might enter the number 3 to calculate a three month rolling average)

Parameters Needed

This area contains one or more fields into which you enter parameter values. Each field has a prompt (typically an instruction or question) telling you what value to enter. For example, if the prompt is 'Please choose a month', enter 'January' to analyze performance figures for January.

Note: Parameters that are required are shown with an asterisk.

To select parameters to apply to the current worksheet, you:

• use the Go button to display the worksheet using the default parameter values currently displayed

• use the torch icon to display the "Search and Select page" where you can search for and select parameter values from a list of values (LOV)

• enter a value into a text field and click the Go button

Discoverer Viewer might display an <Index and Value> drop down list for a parameter (for more information, see "About using indexes and values in parameters").

Note: You specify in Discoverer Plus whether or not the <Index and Value> drop down list is displayed here (for more information, see the Oracle Business Intelligence Discoverer Plus User's Guide).

Go

Click this button to display the worksheet.

Notes

• You can enter the following reserved words into a parameter field:

  • SYSDATE or TODAY

    Enter the reserved word SYSDATE or TODAY into a parameter field (must be of data type DATE) to display worksheet data that matches the system or today's date.

  • USER

    Enter the reserved word USER into a parameter field (must be of the same data type as the data type of the parameter) to display worksheet data that matches the current database user.

  • NULL

    Enter the reserved word NULL into a parameter field (must be of data type DATE, STRING or NUMERIC) to display worksheet data where the item that this parameter is based upon has a NULL value.

  Note that the reserved word must have the same data type as the parameter (e.g. SYSDATE or TODAY can only be used with a parameter that has the data type DATE).

  Note: You can enter reserved words using upper or lower case letters. However, you must not enter any additional text or text symbols. For example, you cannot use NULL% or 'NULL'. Discoverer would treat NULL% as a text string and not as a reserved word.