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

Exploring the table view properties

We already noticed that the Title and Table views are added to Compound Layout when the Analysis is first created. According to business requirements, we may need to modify the Table view properties. For example, Subtotals and Grand Totals are not displayed in the default layout. Some additional modifications can be performed in the Table views:

  • Table prompts
  • Sections
  • Subtotals and Grand Totals
  • Excluded columns

How to do it...

  1. We're going to create a simple analysis and click on the Results tab in the Analysis Editor. You will see that the Title and the Table views are added by default. You'll need to click on the Pencil icon to open the table view editor.
  2. When the table view editor is opened, you'll see the Layout ...

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