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

Using the Aggregate Persistence Wizard

Designing and creating the aggregate tables is not an easy task. Especially, creating the aggregate dimension tables and aggregating the fact tables will take some time. You'll have to think about the joins as well.

There's a utility called Aggregate Persistence in BI Administration Tool. This utility will help us create the aggregate tables and load the precomputed data into them automatically. But you'll have to reflect all changes to the ETL process. Once this wizard is executed, the aggregate tables are going to be created in the database. Also, summary data will be calculated and it's going to be inserted into the aggregate tables. Obviously these tables should be imported into the BI repository and the ...

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