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

Get Oracle Business Intelligence 11g R1 Cookbook now with O’Reilly online learning.

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