Drill dialog

Use this dialog to drill from anywhere in the current worksheet to one of the following:

a different level of data (e.g. from Year to Month)
a related item (e.g. from Sales SUM to Store)
a level of detail set up by the Discoverer manager (e.g. from Year to all items in the Product folder)
another worksheet or Internet page

For more information, see:

"About drilling in Discoverer worksheets"

Where do you want to drill from?

Use this drop down list to select the worksheet item that you want to drill from. For example, if you want to drill down from year to month, you might select an item called Year.

Where do you want to drill to?

Use this drop down list to select the type of drill you want to do. Use this drop down list as follows:

select Drill Up/Down and select an item from the list below to drill to a different level in a drill hierarchy (e.g. to drill from Year to Month)
select Drill to a Related Item and select a worksheet item from the list below to add related information to the worksheet (e.g. to drill from Sales SUM to Store)
select Drill to Detail and select a worksheet item from the list below to drill to a different level of detail (e.g. from Year to all items in the Product folder)
select Drill to Link and select a worksheet item from the list below to drill to a worksheet or Internet page

Use this list to select the target item, folder, or link you want to drill to. For example, if you select Drill Up/Down in the Where do you want to drill to? field, you might select Month to drill down to monthly sales data.

Show Advanced/Hide Advanced

Use this button to display or hide the advanced drill options.

Expand sheet to include new item

Use this radio button to add the drilled item to the worksheet. For example, if you want to drill from Year to Month, select this option to add the Month item to the worksheet.

Replace current item

Use this radio button to remove the currently selected item from the worksheet and display the drilled item instead. For example, if you drill from Year to Month, select this option to remove the Year item from the worksheet and display the Month item instead.

Place drill results in a new sheet

Use this check box when you want Discoverer to create a new worksheet to display the results of the drill.

Table

Use this radio button when you want Discoverer to create a new table worksheet to display the results of the drill.
Crosstab

Use this radio button when you want Discoverer to create a new crosstab worksheet to display the results of the drill.