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

Creating aggregate tables

Aggregate tables should be designed according to business requirements. We should monitor the usage statistics of the analysis and then we'll make a decision about the levels of hierarchies that will be stored in the aggregate tables.

How to do it...

  1. Let's assume that the most frequently accessed hierarchy levels are:
    • Product hierarchy: Subtype level
    • Time hierarchy: Year level
    • Customer hierarchy: State level

    So we're going to create three aggregate dimension tables and one aggregate fact table based on our sample scenario. The first table is named as DIM_STATE_AGG. This table stores the attribute columns regarding the STATE level and also it contains higher levels as well, which is the REGION level. You can see the sample view ...

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