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 4. Working with Multidimensional Data Sources

In this chapter, we will cover:

  • Importing the multidimensional data source
  • Accessing members and member counts
  • Creating the multidimensional Business Model
  • Implementing Horizontal Federation
  • Implementing Vertical Federation

Introduction

Online Transactional Processing (OLTP) databases are optimized for transaction processing. The performance of the Insert, update, and delete SQL statements are very important in the OLTP databases. They store the data in the two-dimensional structures called as tables. Enterprises need to retrieve valuable information from these databases to make strategic decisions. The databases that are optimized for queries are called as data warehouses. The need for the data ...

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