Skip Headers
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus
11g Release 1 (11.1.1)

Part Number B40105-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

Parameters dialog

Use this dialog to select a worksheet item on which to create a parameter for the selected worksheet to prompt end users for a parameter value. For example, if you create a link to a worksheet with an active City parameter, you might want to activate a Region parameter instead. In this scenario, when an end user selects the link, they are prompted for a Region, not a City.

You can also change the default parameter value that is used to refine the worksheet displayed when a link is used to connect two worksheets. For example, if you want a link to display a worksheet called Sales that contains a parameter on the Month item, you might want to change the default month from January to February.

Note: If you enter all possible values in the Parameters field, the end user is not prompted to specify a parameter value when they use the link. For example, if you create a link that displays a worksheet with a month parameter, if you specify all twelve months in the Parameters field, Discoverer does not prompt the end user for a month, but displays data for all months.

You can also create a dynamic link, which displays different data for each worksheet cell depending on the value of the cell. For example, you might want to click a link on a worksheet item called Year to display a sales information for that particular year. The value of the worksheet cell is passed to the target worksheet using a worksheet parameter. For more information, see "How to create drill links to Discoverer worksheets".

For more information, see:

"About user defined drill links"

"About drilling in Discoverer worksheets"

"What are parameters?"


Use this field to change the default parameter value that you pass to the target worksheet by doing one of the following:

<Down arrow button>

This button displays a list of select a worksheet items whose value you can to pass to the target worksheet.

For example, if you create a link on a worksheet item called Year to a target worksheet has an active parameter on year, select Year from the drop down list. Discoverer passes the value of each cell (for example, 2005, 2006) to the target worksheet as a parameter value and filters the worksheet data using the parameter value. In other words, if you select the link on the 2005 worksheet value, Discoverer displays a worksheet filtered on 2005 data. If you select the link on the 2006 worksheet value, Discoverer display a worksheet filtered on 2006 data.


This read-only field displays a description of the current parameter that can contain additional information such as hints on using the parameter.