|Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus
11g Release 1 (11.1.1)
Part Number B40105-01
Use this dialog to create a drill link or edit an existing drill link. For example, you might want to create a drill link on a worksheet item called Region to display a worksheet containing more detailed Region information.
For more information, see:
This read-only field shows the name of the item currently selected on the worksheet. To create a drill link from a different worksheet item, click Cancel and select a different worksheet item first.
What would you like to name this link?
Use this field to enter a descriptive name for the drill link. This name is displayed in the list of drill links on the "Manage Links dialog".
Note: You must enter a unique name before you can save the drill link details.
Hint: If you enter an instruction on how to use the drill link into this field, the instruction appears in the worksheet as:
a tooltip (when an item contains a single link)
a link name (when a user selects a drill link icon (when an item contains multiple links)
For example, you might enter 'Click here to connect to the Products Web site', or 'Click here to display the Products worksheet'.
Where do you want to link to?
Use this list to select a link type, as follows:
to connect to an Internet page, select URL and enter the Internet page address (for example, www.company.com/storelist) in the Destination field below
to connect to a Discoverer worksheet, select Worksheet and select a worksheet in the Destination Worksheet field below
Note: If you are editing a drill link, this field is grayed out. To create a drill link of another type, click New Link on the "Manage Links dialog" and create a drill link.
Use this field to specify the Internet page address you want to drill to (if you selected URL in the Where do you want to link to? field). For example, http://www.company.com/storelist.
Note: The URL that you enter must be syntactically correct and must be prefixed with HTTP, HTTPS, FTP, or a protocol authorized by the Discoverer manager.
Use this field to insert (at the cursor position the Internet page address in the Destination field) a value that you specify. This field enables you to create a dynamic Internet page address incorporating worksheet item values.
For example, you might want to display an Internet page for a particular store by incorporating the currently selected worksheet value into an Internet page address. In other words, if you select the drill link for the New York store, you link to the Internet page for the New York store (for example, http://www.company.com/storelist/New_York/Details.htm. To create this dynamic Internet page address, you might do the following:
Enter http://www.company.com/storelist/ in the Destination field.
Click Insert and choose Store name from the drop down list.
Append the text in the Destination field with /Details.htm.
The URL is now http://www.company.com/storelist/Details.htm
Click OK to save the drill link, then click OK again to close the Links dialog.
If a Discoverer end user clicks the drill link for the New York worksheet item, Discoverer displays the http://www.company.com/storelist/New_York/Details.htm Internet page in a browser window. If a Discoverer end user clicks the drill link for the Boston worksheet item, Discoverer displays the http://www.company.com/storelist/Boston/Details.htm Internet page in a browser window.
Note: This button is only displayed when you select URL in the Where do you want to link to? field.
Destination: Destination Workbook
This field displays the name of the currently selected workbook. To link to a worksheet in a different workbook, click Browse to display the "Choose Worksheet dialog".
Use this button to display the "Choose Worksheet dialog", which enables you to locate and select a worksheet to display when the link is selected.
Note: This button is only active when you select Worksheet in the Where do you want to link to? field.
Destination: Destination Worksheet
Use this drop down to select the worksheet in the currently opened workbook you want to drill to. To link to a worksheet in a different workbook, click Browse to display the "Choose Worksheet dialog".
Use this button to display the "Parameters dialog", which enables you to select a parameter or parameter value to refine the worksheet displayed when the drill link is selected, as follows:
to create a static drill link, enter a value surrounded by double quotes (for example, type "3" to specify three as the default parameter value for a calculation)
to create a dynamic drill link, click on the down arrow next to the field and select the name of a worksheet item
Note: This button is only active when select Worksheet in the Where do you want to link to? field and the selected worksheet contains one or more parameters.