O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

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

Adding the pivot table view

We're going to add a pivot table view into the analysis. Normally, when you add an attribute and a measure column in the Criteria tab, the title and table views are added to the compound layout of the analysis. But if you've already created a hierarchy column in the repository, you have an option to select that column. If a hierarchy column is added, then the compound layout will consist of the title and pivot table views.

How to do it...

  1. We're going to add these columns into the analysis in the Criteria tab as shown in the following screenshot:
    • Product: Hierarchy column
    • YEAR: Attribute column
    • Dollars: Measure
    How to do it...
  2. When you click ...

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