How to drill down in worksheets

You drill to navigate worksheet data quickly and easily. For example, you might drill down into a worksheet item to see data in more detail.

To drill down in a worksheet:

1. Display the worksheet that you want to analyze (for more information, see "How to open a Discoverer worksheet").

2. The available drill tools depend on the type of data source, as follows:

   • on a worksheet containing relational data, you:

     • Select a drill icon next to the item heading of the worksheet item you want to drill down into.

     • Select a level of detail below the current level of detail (indicated by a dot).

       For example, to drill down from Region to City, select the City option.

       Discoverer updates the worksheet according to the drill level you selected. For example, if you drill down from Region to City, Discoverer adds city data to the worksheet.

   • on a worksheet containing multidimensional data, you:

     • Select a Drill Expand (+) icon next to the worksheet value you want to drill down into.

       Discoverer displays the next level of data in the data hierarchy. For example, if you drill into the 2005 value, you might display quarterly data for 2005.

   Discoverer updates the worksheet according to the drilling options you have specified.

   Note: For information about drilling in graphs, refer to the Discoverer Plus Help systems.