How to drill up in worksheets

You drill to navigate worksheet data quickly and easily. For example, you might drill up from a worksheet item to consolidated data.

To drill up 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 up to.

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

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

       Discoverer updates the worksheet according to the drill level you selected. For example, if you drill up from City to Region, Discoverer removes City data from the worksheet.

   • on a worksheet containing multidimensional data, you:

     • Select a Drill Collapse icon (-) next to the worksheet value you want to drill up from.

       Discoverer collapses the worksheet value. For example, if you collapse the 2005 value, you remove 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.