CHAPTER 11Refining Items, Drilling, and Hyper-Drilling

During the first ten chapters of this book, we taught you how to create worksheets using the Workbook Wizard, how to analyze your data, and how to convert your queries into reports.

Most queries are not very efficient when first built. You run them to make sure that they at least work. Having avoided “The Query from the Twilight Zone” and decided that a query is worth keeping, you may have followed the steps in Chapter 9 and converted it into a report. Later, however, when working on a completely different problem, you may realize that a previous query satisfies most of the requirements. With a little tweaking and manipulation, you can modify or refine one query and turn it into another. ...

Get Oracle Discoverer 10g Handbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.