O'Reilly logo

Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting by Yuli Vasiliev

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required