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 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

Introduction

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 ...

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