Drill dialog

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

  • a different level of data (for example, from Year to Month)

  • a related item (for example, from Sales SUM to Store)

  • a level of detail set up by the Discoverer manager (for example, 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 you want to drill from. For example, 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 (for example, 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 (for example, 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 (for example, 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

<List of drill targets>

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 option to add the drilled item to the worksheet. For example, to drill from Year to Month, select this option to add the Month item to the worksheet.

Replace current item

Use this option 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 worksheet to display the results of the drill.

  • Table

    Use this option when you want Discoverer to create a table worksheet to display the results of the drill.

  • Crosstab

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