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

Importing the multidimensional data source

Detailed data that is stored in OLTP databases should be loaded into core data warehouses and then the structure of the cubes should be created in multidimensional source databases. In our case this source will be based on Essbase Server.

Oracle Business Intelligence Enterprise Edition Server can be configured to connect to these multidimensional sources including Essbase Servers. We're not going to discuss how to build a cube in this recipe. We're going to learn how to create a repository based on the Essbase source.

How to do it...

  1. We're going to use BI Administration Tool to import multidimensional source metadata to the Physical layer of the repository. When you click on the Import Metadata option from ...

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