Edit Parameters page

Previous

Next

---

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 flashlight 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.

• If a Discoverer List Of Worksheets portlet includes a worksheet that has parameters with lists of values (LOV) (where a default value is not specifed for each parameter), Discoverer displays a "404 Not Found" error when you do the following:

  1. Select the List Of Worksheets portlet link to display the worksheet in Discoverer Viewer.

  2. Click on the flashlight icon to display the "Search and Select page" to display the parameter values from a LOV.

  To resolve this issue after launching Discoverer Viewer, run the worksheet again by pressing the Go button (you might need to enter some parameter values before pressing Go), then use the flashlight icon to display the "Search and Select page" to search for, and select parameter values from a LOV.

  Note: This issue does not arise when a default value is specified for each parameter.