Chapter 7. Drilling Data Up and Down

Pivoting discussed in the preceding chapter is not the only technique that allows you to rearrange data on worksheets to answer the business questions you need to get answered. In Oracle Discoverer, you can also use drilling to analyze data, getting a new angle on the data you're dealing with.

There are several ways supported by Discoverer in which you can accomplish drilling. For example, you can drill data down to see more detailed information for a certain product. Or, on the contrary, you may need to view data at a higher level, drilling data up from products to categories. Another example is drilling to a related item, allowing you to add a related item that is not currently in the worksheet but can be found in a folder used by the worksheet.

This chapter will walk you through the simple steps required to drill data on Discoverer worksheets. With the help of many examples, this chapter will introduce you to the following:

• Navigating a Discoverer worksheet...