What is drilling?
In terms of Oracle Discoverer, drilling is a technique that enables you to quickly navigate through worksheet data, finding the answers to the questions facing your business. As mentioned, depending on your needs, you can use drilling to view the data you're working with in deeper detail or, in contrast, drill it up to a higher level. The drilling to detail technique enables you to look at the values making up a particular summary value. Also, you can drill to related items, adding related information that is not currently included in the worksheet.
So, Discoverer supports a set of drilling tools, including the following:
Drilling up and down
Drilling to a related item
Drilling to detail
Drilling out
The following sections cover the above tools in detail, providing examples on how you might use them.