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 6. Pivoting Through Data

This chapter comes back to Oracle Discoverer, explaining how you can reorganize data on a worksheet for more effective analysis. In particular, you will learn to explore data relationships with pivoting.

Generally speaking, pivoting is a tool that allows you to look at the data from a different angle, rearranging worksheet items to meet your needs. For example, you may need to explore the sales by product or product category, rearranging the data so you can instantly see the sales figures for each product or category. In Discoverer, you can easily accomplish a pivoting operation using a drag and drop technique.

In this chapter, you will look at an example of pivoting and learn how to do the following:

  • Create a crosstab ...

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