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

Chapter 3. Using Aggregates and the Time Series Functions

In this chapter, we will cover:

  • Creating aggregate tables
  • Implementing aggregate tables
  • Using the Aggregate Persistence Wizard
  • Creating calculations by using the time series functions

Introduction

As a general practice, the data warehouse is maintained at the lowest granular level. Data warehouse performance bottlenecks are often due to measure aggregation. For example, to have some amount of dollars at different levels of dimension hierarchy, a calculation will be needed at runtime. This will impact the performance. Business users should wait for the result set until the calculation regarding the required aggregation is done. Based on the amount of data, the calculations at runtime will be ...

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