Using the selections

When the analysis is constructed, it'll show all the data as it's in the database. We can implement some filters or grouping options in the analysis after the data is aggregated.

In order to make the demonstration, we're going to use a new analysis that consists of these columns. You can see this in the following screenshot.

  • The Customer hierarchy column
  • The Dollars measure column
Using the selections

How to do it...

  1. After constructing the sample analysis, click on the Results tab. We'll see that this time, Compound Layout consists of the Title and Pivot Table views. This happened because we have selected a hierarchy column instead of selecting an attribute ...

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.