Chapter 2. Working with Logical Dimensions

In this chapter, we will cover:

  • Creating level-based hierarchies
  • Creating parent-child hierarchies
  • Creating level-based measures
  • Creating shared measures
  • Creating presentation hierarchies


Logical Dimensions consists of hierarchies and they are created in the Business Model and the Mapping layer. They enable end users to drill down to details, and measures that will be based on levels can also be created. Besides these functions, we can also gain the benefit of using aggregate tables in order to improve query performance.

Logical Dimensions are representations of hierarchical organization of logical columns. There are some common examples of dimensions: Time, Customer, Product, Channels, Employees ...

Get Oracle Business Intelligence 11g R1 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.