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

Implementing aggregate tables

In order to improve query performance, we have created aggregate tables at the database level. Now we're going to modify the Physical and BMM layers of the repository to gain benefit of summary data.

  • Physical layer: Aggregate tables should be imported and physical joins should be created
  • Business Model and Mapping layer: Secondary logical table sources are going to be added to the corresponding logical tables
  • Presentation layer: No modification will be made at this layer. Usage of aggregate tables will be transparent to the end users

How to do it...

  1. As we have already demonstrated how to import tables into the Physical layer in Chapter 1, Exploring and Building the Repository, you won't find every detailed step in this ...

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